VWAP Calculations

	A	B	C	D	E	F	G	H	I	J	K
1	time	open	high	low	close	Volume	Typical Price (H+L+C)/3	Px x Volume	Cum(Price x Vol)	Cum. Vol	VWAP

2	2020-08-06T17:00:00Z	0.72356	0.72381	0.72346	0.72368	47	0.72365	34.01155	34.01155	47
3	2020-08-06T17:05:00Z	0.72368	0.72377	0.72344	0.7237	36	0.72364	26.05092	60.06247	83	0.72364
4	2020-08-06T17:10:00Z	0.7237	0.72374	0.72344	0.7235	29	0.72356	20.98324	81.04571	112	0.72362
5	2020-08-06T17:15:00Z	0.7235	0.72354	0.72317	0.72318	32	0.72330	23.14549333	104.1912033	144	0.72355
6	2020-08-06T17:20:00Z	0.72318	0.72324	0.72314	0.72318	28	0.72319	20.24922667	124.44043	172	0.72349
7	2020-08-06T17:25:00Z	0.72318	0.72343	0.72308	0.72343	15	0.72331	10.8497	135.29013	187	0.72348
8	2020-08-06T17:30:00Z	0.72343	0.72357	0.72328	0.72332	27	0.72339	19.53153	154.82166	214	0.72347
9	2020-08-06T17:35:00Z	0.72332	0.72342	0.72332	0.72338	16	0.72337	11.57397333	166.3956333	230	0.72346
10	2020-08-06T17:40:00Z	0.72338	0.72351	0.72328	0.72351	28	0.72343	20.25613333	186.6517667	258	0.72346
11	2020-08-06T17:45:00Z	0.72351	0.72381	0.72344	0.72381	45	0.72369	32.5659	219.2176667	303	0.72349
12	2020-08-06T17:50:00Z	0.72381	0.72392	0.72338	0.72349	38	0.72360	27.49667333	246.71434	341	0.72350
13	2020-08-06T17:55:00Z	0.72349	0.72349	0.7229	0.72305	41	0.72315	29.64901333	276.3633533	382	0.72346
14	2020-08-06T18:00:00Z	0.72305	0.72331	0.72297	0.72312	41	0.72313	29.64846667	306.01182	423	0.72343
15	2020-08-06T18:05:00Z	0.72312	0.72334	0.72308	0.7233	27	0.72324	19.52748	325.5393	450	0.72342
16	2020-08-06T18:10:00Z	0.7233	0.72347	0.72314	0.72314	25	0.72325	18.08125	343.62055	475	0.72341
17	2020-08-06T18:15:00Z	0.72314	0.7232	0.72284	0.7229	31	0.72298	22.41238	366.03293	506	0.72339
18	2020-08-06T18:20:00Z	0.7229	0.72296	0.72276	0.72282	36	0.72285	26.02248	392.05541	542	0.72335
19	2020-08-06T18:25:00Z	0.72282	0.72307	0.7227	0.72296	36	0.72291	26.02476	418.08017	578	0.72332
20	2020-08-06T18:30:00Z	0.72296	0.72306	0.72286	0.7229	16	0.72294	11.56704	429.64721	594	0.72331
21	2020-08-06T18:35:00Z	0.7229	0.72307	0.72282	0.72306	25	0.72298	18.07458333	447.7217933	619	0.72330
22	2020-08-06T18:40:00Z	0.72306	0.7232	0.72303	0.7232	18	0.72314	13.01658	460.7383733	637	0.72329
23	2020-08-06T18:45:00Z	0.7232	0.7233	0.72307	0.7233	21	0.72322	15.18769	475.9260633	658	0.72329
24	2020-08-06T18:50:00Z	0.7233	0.72358	0.7233	0.72341	25	0.72343	18.08575	494.0118133	683	0.72330
25	2020-08-06T18:55:00Z	0.72341	0.72348	0.72331	0.72342	22	0.72340	15.91487333	509.9266867	705	0.72330
26	2020-08-06T19:00:00Z	0.72342	0.72378	0.72328	0.72372	38	0.72359	27.49654667	537.4232333	743	0.72332
27	2020-08-06T19:05:00Z	0.72372	0.72378	0.72354	0.72354	39	0.72362	28.22118	565.6444133	782	0.72333
28	2020-08-06T19:10:00Z	0.72354	0.72368	0.72282	0.72352	141	0.72334	101.99094	667.6353533	923	0.72333
29	2020-08-06T19:15:00Z	0.72352	0.72372	0.72338	0.72361	72	0.72357	52.09704	719.7323933	995	0.72335
30	2020-08-06T19:20:00Z	0.72361	0.72368	0.72346	0.72354	54	0.72356	39.07224	758.8046333	1049	0.72336
31	2020-08-06T19:25:00Z	0.72354	0.7236	0.72329	0.7236	37	0.72350	26.76937667	785.57401	1086	0.72336
32	2020-08-06T19:30:00Z	0.7236	0.72378	0.72356	0.72358	39	0.72364	28.22196	813.79597	1125	0.72337
33	2020-08-06T19:35:00Z	0.72358	0.72376	0.72353	0.72372	26	0.72367	18.81542	832.61139	1151	0.72338
34	2020-08-06T19:40:00Z	0.72372	0.72373	0.72358	0.72366	28	0.72366	20.26238667	852.8737767	1179	0.72339
35	2020-08-06T19:45:00Z	0.72366	0.72382	0.72358	0.72369	47	0.72370	34.01374333	886.88752	1226	0.72340
36	2020-08-06T19:50:00Z	0.72369	0.72394	0.72369	0.72388	33	0.72384	23.88661	910.77413	1259	0.72341
37	2020-08-06T19:55:00Z	0.72388	0.72391	0.72374	0.72388	36	0.72384	26.05836	936.83249	1295	0.72342
38	2020-08-06T20:00:00Z	0.72388	0.72392	0.72364	0.72386	27	0.72381	19.54278	956.37527	1322	0.72343
39	2020-08-06T20:05:00Z	0.72386	0.72392	0.72373	0.72388	15	0.72384	10.85765	967.23292	1337	0.72344
40	2020-08-06T20:10:00Z	0.72388	0.72388	0.7237	0.72381	10	0.72380	7.237966667	974.4708867	1347	0.72344
41	2020-08-06T20:15:00Z	0.72381	0.72381	0.72365	0.72372	17	0.72373	12.30335333	986.77424	1364	0.72344
42	2020-08-06T20:20:00Z	0.72372	0.72376	0.72362	0.72362	7	0.72367	5.065666667	991.8399067	1371	0.72344
43	2020-08-06T20:25:00Z	0.72362	0.72381	0.72358	0.72378	25	0.72372	18.09308333	1009.93299	1396	0.72345
44	2020-08-06T20:30:00Z	0.72378	0.72384	0.72374	0.72381	7	0.72380	5.066576667	1014.999567	1403	0.72345
45	2020-08-06T20:35:00Z	0.72381	0.72384	0.72358	0.72358	16	0.72367	11.57866667	1026.578233	1419	0.72345
46	2020-08-06T20:40:00Z	0.72358	0.72378	0.72358	0.72376	13	0.72371	9.408186667	1035.98642	1432	0.72345
47	2020-08-06T20:45:00Z	0.72376	0.72376	0.72369	0.72376	4	0.72374	2.894946667	1038.881367	1436	0.72345
48	2020-08-06T20:50:00Z	0.72376	0.72376	0.72366	0.72376	18	0.72373	13.02708	1051.908447	1454	0.72346
49	2020-08-06T20:55:00Z	0.72376	0.72376	0.72355	0.72355	8	0.72362	5.78896	1057.697407	1462	0.72346
50	2020-08-06T21:00:00Z	0.72355	0.72355	0.7234	0.72351	2	0.72349	1.446973333	1059.14438	1464	0.72346
51	2020-08-06T21:05:00Z	0.72351	0.7237	0.72351	0.7237	3	0.72364	2.17091	1061.31529	1467	0.72346
52	2020-08-06T21:10:00Z	0.7237	0.7237	0.72365	0.72365	1	0.72367	0.7236666667	1062.038957	1468	0.72346
53	2020-08-06T21:15:00Z	0.72365	0.72365	0.72352	0.72352	3	0.72356	2.17069	1064.209647	1471	0.72346
54	2020-08-06T21:20:00Z	0.72352	0.72352	0.72251	0.72293	27	0.72299	19.52064	1083.730287	1498	0.72345
55	2020-08-06T21:25:00Z	0.72293	0.72338	0.7227	0.72338	38	0.72315	27.47982667	1111.210113	1536	0.72344
56	2020-08-06T21:30:00Z	0.72338	0.72348	0.72248	0.72316	56	0.72304	40.49024	1151.700353	1592	0.72343
57	2020-08-06T21:35:00Z	0.72316	0.72348	0.72316	0.72348	10	0.72337	7.233733333	1158.934087	1602	0.72343
58	2020-08-06T21:40:00Z	0.72348	0.72356	0.72347	0.72356	6	0.72353	4.34118	1163.275267	1608	0.72343
59	2020-08-06T21:45:00Z	0.72356	0.72356	0.72327	0.72334	26	0.72339	18.80814	1182.083407	1634	0.72343
60	2020-08-06T21:50:00Z	0.72334	0.72339	0.72334	0.72339	2	0.72337	1.446746667	1183.530153	1636	0.72343
61	2020-08-06T21:55:00Z	0.72339	0.72339	0.72326	0.72332	3	0.72332	2.16997	1185.700123	1639	0.72343
62	2020-08-06T22:00:00Z	0.72332	0.72375	0.72326	0.72375	22	0.72359	15.91890667	1201.61903	1661	0.72343
63	2020-08-06T22:05:00Z	0.72375	0.72378	0.72365	0.72365	5	0.72369	3.618466667	1205.237497	1666	0.72343
64	2020-08-06T22:10:00Z	0.72365	0.72372	0.72365	0.72365	6	0.72367	4.34204	1209.579537	1672	0.72343
65	2020-08-06T22:15:00Z	0.72365	0.72368	0.72346	0.72354	9	0.72356	6.51204	1216.091577	1681	0.72343
66	2020-08-06T22:20:00Z	0.72354	0.72379	0.72354	0.72376	14	0.72370	10.13175333	1226.22333	1695	0.72344
67	2020-08-06T22:25:00Z	0.72376	0.72376	0.72349	0.72362	21	0.72362	15.19609	1241.41942	1716	0.72344
68	2020-08-06T22:30:00Z	0.72362	0.72368	0.72344	0.72344	11	0.72352	7.95872	1249.37814	1727	0.72344
69	2020-08-06T22:35:00Z	0.72344	0.72344	0.72332	0.72332	12	0.72336	8.68032	1258.05846	1739	0.72344
70	2020-08-06T22:40:00Z	0.72332	0.72338	0.72324	0.72328	13	0.72330	9.4029	1267.46136	1752	0.72344
71	2020-08-06T22:45:00Z	0.72328	0.72334	0.72321	0.72326	13	0.72327	9.40251	1276.86387	1765	0.72344
72	2020-08-06T22:50:00Z	0.72326	0.72356	0.72318	0.72342	25	0.72339	18.08466667	1294.948537	1790	0.72343
73	2020-08-06T22:55:00Z	0.72342	0.72342	0.72326	0.72334	10	0.72334	7.2334	1302.181937	1800	0.72343
74	2020-08-06T23:00:00Z	0.72334	0.72345	0.72331	0.72345	17	0.72340	12.29785667	1314.479793	1817	0.72343
75	2020-08-06T23:05:00Z	0.72345	0.72368	0.72342	0.72365	11	0.72358	7.959416667	1322.43921	1828	0.72344
76	2020-08-06T23:10:00Z	0.72365	0.72368	0.72318	0.72324	42	0.72337	30.3814	1352.82061	1870	0.72343
77	2020-08-06T23:15:00Z	0.72324	0.72325	0.72314	0.72325	18	0.72321	13.01784	1365.83845	1888	0.72343
78	2020-08-06T23:20:00Z	0.72325	0.72334	0.72314	0.72324	20	0.72324	14.4648	1380.30325	1908	0.72343
79	2020-08-06T23:25:00Z	0.72324	0.72342	0.72324	0.72337	24	0.72334	17.36024	1397.66349	1932	0.72343
80	2020-08-06T23:30:00Z	0.72337	0.72348	0.72337	0.72346	10	0.72344	7.234366667	1404.897857	1942	0.72343
81	2020-08-06T23:35:00Z	0.72346	0.72368	0.72346	0.72368	20	0.72361	14.47213333	1419.36999	1962	0.72343
82	2020-08-06T23:40:00Z	0.72368	0.72368	0.72317	0.72326	30	0.72337	21.7011	1441.07109	1992	0.72343
83	2020-08-06T23:45:00Z	0.72326	0.72334	0.72312	0.72316	20	0.72321	14.46413333	1455.535223	2012	0.72343
84	2020-08-06T23:50:00Z	0.72316	0.72342	0.72316	0.72339	32	0.72332	23.14634667	1478.68157	2044	0.72343
85	2020-08-06T23:55:00Z	0.72339	0.72346	0.72305	0.72316	36	0.72322	26.03604	1504.71761	2080	0.72342
86	2020-08-07T00:00:00Z	0.72316	0.72357	0.72277	0.7235	84	0.72328	60.75552	1565.47313	2164	0.72342
87	2020-08-07T00:05:00Z	0.7235	0.72388	0.72346	0.72374	51	0.72369	36.90836	1602.38149	2215	0.72342
88	2020-08-07T00:10:00Z	0.72374	0.72386	0.72364	0.72376	34	0.72375	24.60761333	1626.989103	2249	0.72343
89	2020-08-07T00:15:00Z	0.72376	0.72406	0.72368	0.72406	31	0.72393	22.44193333	1649.431037	2280	0.72343
90	2020-08-07T00:20:00Z	0.72406	0.72424	0.72355	0.72362	81	0.72380	58.62807	1708.059107	2361	0.72345
91	2020-08-07T00:25:00Z	0.72362	0.72382	0.72358	0.72379	49	0.72373	35.46277	1743.521877	2410	0.72345
92	2020-08-07T00:30:00Z	0.72379	0.72432	0.72376	0.72418	56	0.72409	40.54885333	1784.07073	2466	0.72347
93	2020-08-07T00:35:00Z	0.72418	0.72422	0.7237	0.72388	37	0.72393	26.78553333	1810.856263	2503	0.72347
94	2020-08-07T00:40:00Z	0.72388	0.72388	0.72368	0.72378	27	0.72378	19.54206	1830.398323	2530	0.72348
95	2020-08-07T00:45:00Z	0.72378	0.72403	0.72364	0.7238	31	0.72382	22.43852333	1852.836847	2561	0.72348
96	2020-08-07T00:50:00Z	0.7238	0.72392	0.72332	0.72332	58	0.72352	41.96416	1894.801007	2619	0.72348
97	2020-08-07T00:55:00Z	0.72332	0.72339	0.72318	0.72339	36	0.72332	26.03952	1920.840527	2655	0.72348
98	2020-08-07T01:00:00Z	0.72339	0.7234	0.7228	0.72288	75	0.72303	54.227	1975.067527	2730	0.72347
99	2020-08-07T01:05:00Z	0.72288	0.72314	0.72284	0.72298	59	0.72299	42.65621333	2017.72374	2789	0.72346
100	2020-08-07T01:10:00Z	0.72298	0.72342	0.72298	0.72334	49	0.72325	35.43908667	2053.162827	2838	0.72345