PREVIEW / futures_daily / 2020-05-01

all futures daily files

  file:    by_date/futures_daily/2020/2020-05-01.parquet
  size:    9 KB
  rows:    98

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2020-05-01	ES	Futures	3177.27	3186.4	3111.16	3122.23	1647259.0
2020-05-01	NQ	Futures	10142.55	10179.24	9941.93	9994.66	414560.0
2020-05-01	YM	Futures	25664.8	25692.5	25107.8	25202.7	169783.0
2020-05-01	CL	Futures	14.17	15.25	13.45	14.73	403201.0
2020-05-01	GC	Futures	2053.7	2079.1	2032.5	2062.7	168016.0
2020-05-01	ZN	Futures	137.284433	137.57771	137.160948	137.19182	870887.0
2020-05-01	A6	Futures	0.66799	0.6684	0.65864	0.65884	66225.0
2020-05-01	AD	Futures	0.72703	0.72703	0.71821	0.71994	56266.0
2020-05-01	ALI	Futures	1808.68	1808.68	1808.68	1808.68	0.0
2020-05-01	B	Futures	17.8	18.41	17.01	17.46	216975.0
2020-05-01	B6	Futures	1.279	1.2792	1.2672	1.2676	56275.0
2020-05-01	BR	Futures	0.15013	0.15013	0.14616	0.14685	785.0
2020-05-01	BTC	Futures	12308.8	12719.1	12037.6	12294.9	5127.0
2020-05-01	BZ	Futures	17.08	17.87	16.46	16.9	28681.0
2020-05-01	C	Futures	1853.0	1864.0	1818.0	1820.0	1702.0
2020-05-01	CB	Futures	137.826	138.384	137.826	138.384	3.0
2020-05-01	CC	Futures	1573.0	1583.0	1559.0	1570.0	16432.0
2020-05-01	CNH	Futures	7.0286	7.0768	7.0281	7.0768	618.0
2020-05-01	CSC	Futures	2.455	2.457	2.409	2.409	127.0
2020-05-01	CT	Futures	55.81	56.02	53.93	54.43	13579.0
2020-05-01	DC	Futures	19.66	19.8	19.23	19.39	316.0
2020-05-01	DX	Futures	95.856	95.948	95.503	95.827	12234.0
2020-05-01	E1	Futures	1.18021	1.18909	1.17918	1.18556	18333.0
2020-05-01	E6	Futures	1.17805	1.18531	1.17617	1.18079	88703.0
2020-05-01	E7	Futures	1.1719	1.1791	1.1701	1.1747	4409.0
2020-05-01	ED	Futures	96.3388	96.3484	96.3194	96.3243	230862.0
2020-05-01	ER	Futures	98.328	98.328	98.328	98.328	0.0
2020-05-01	ESG	Futures	257.59	257.67	254.3	254.91	255.0
2020-05-01	EW	Futures	1722.8	1725.9	1661.2	1679.2	11836.0
2020-05-01	FTUK	Futures	5491.4	5510.7	5392.8	5407.4	65879.0
2020-05-01	G	Futures	126.08	126.28	125.71	125.81	98502.0
2020-05-01	GF	Futures	244.444	250.829	242.939	244.652	1504.0
2020-05-01	GSCI	Futures	267.54	269.3	266.9	266.9	760.0
2020-05-01	HE	Futures	42.094	43.915	41.989	43.915	16849.0
2020-05-01	HG	Futures	2.6291	2.6314	2.5685	2.5977	42859.0
2020-05-01	HH	Futures	10.303	10.341	10.053	10.064	2822.0
2020-05-01	HO	Futures	0.5565	0.5754	0.5225	0.5281	62115.0
2020-05-01	HRC	Futures	1344.0	1378.2	1344.0	1369.7	205.0
2020-05-01	J1	Futures	0.0108022	0.0108595	0.0107774	0.0108335	59047.0
2020-05-01	J7	Futures	0.010768	0.010825	0.010743	0.010798	598.0
2020-05-01	JB	Futures	140.14	140.27	139.91	140.0	871.0
2020-05-01	KC	Futures	99.42	100.78	98.2	99.7	9841.0
2020-05-01	KE	Futures	658.05	658.05	645.23	651.98	14346.0
2020-05-01	KRW	Futures	0.0008034	0.0008034	0.0008027	0.0008027	11.0
2020-05-01	L	Futures	99.73	99.745	99.72	99.735	56740.0
2020-05-01	LBS	Futures	484.0	502.7	484.0	494.6	70.0
2020-05-01	LE	Futures	128.471	132.11	127.32	129.585	32067.0
2020-05-01	M2K	Futures	1419.6	1419.6	1352.4	1375.8	85302.0
2020-05-01	MES	Futures	3105.76	3112.79	3039.55	3050.36	990942.0
2020-05-01	MFS	Futures	1621.1	1623.4	1590.7	1606.6	31727.0

> showing 50 of 98 rows — these rows as CSV

> unlock the full archive -- $79 one-time