PREVIEW / futures_daily / 2020-04-17

all futures daily files

  file:    by_date/futures_daily/2020/2020-04-17.parquet
  size:    10 KB
  rows:    119

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-04-17	ES	Futures	3167.87	3192.21	3121.4	3175.61	1924019.0
2020-04-17	NQ	Futures	10214.49	10279.84	9961.99	10098.99	509555.0
2020-04-17	YM	Futures	25686.1	25958.2	25290.2	25778.9	231633.0
2020-04-17	CL	Futures	19.67	19.94	18.29	18.63	712975.0
2020-04-17	GC	Futures	2108.3	2108.7	2051.0	2060.2	227069.0
2020-04-17	ZN	Futures	137.160948	137.747502	136.852236	137.207255	1365292.0
2020-04-17	A6	Futures	0.6534	0.65607	0.64888	0.65278	73766.0
2020-04-17	AD	Futures	0.72298	0.72414	0.71811	0.72293	56058.0
2020-04-17	ALI	Futures	1843.94	1845.14	1839.76	1839.76	50.0
2020-04-17	B	Futures	21.95	22.16	21.13	21.51	286171.0
2020-04-17	B6	Futures	1.2682	1.2717	1.2598	1.2681	59640.0
2020-04-17	BR	Futures	0.15689	0.1571	0.15497	0.15587	128.0
2020-04-17	BTC	Futures	10078.4	10262.8	9943.7	10043.0	1863.0
2020-04-17	BZ	Futures	21.16	21.55	20.51	20.87	44417.0
2020-04-17	C	Futures	1675.0	1735.0	1668.0	1733.0	3741.0
2020-04-17	CB	Futures	149.732	151.294	149.732	151.294	17.0
2020-04-17	CC	Futures	1480.0	1548.0	1475.0	1547.0	15893.0
2020-04-17	CNH	Futures	7.0167	7.0214	7.0061	7.0171	158.0
2020-04-17	CSC	Futures	2.364	2.378	2.36	2.375	72.0
2020-04-17	CT	Futures	51.51	51.76	50.69	50.81	3080.0
2020-04-17	DC	Futures	19.24	19.37	19.04	19.34	170.0
2020-04-17	DX	Futures	96.669	97.041	96.369	96.539	12797.0
2020-04-17	E1	Futures	1.17839	1.18157	1.17337	1.17918	18463.0
2020-04-17	E6	Futures	1.16849	1.17252	1.16365	1.16972	129194.0
2020-04-17	E7	Futures	1.1627	1.1663	1.1576	1.1637	5031.0
2020-04-17	EBM	Futures	219.21	223.13	218.65	222.29	11823.0
2020-04-17	ED	Futures	96.2324	96.2614	96.2276	96.2469	219456.0
2020-04-17	ER	Futures	98.21	98.24	98.21	98.22	99028.0
2020-04-17	ESG	Futures	257.16	259.67	255.63	259.09	2435.0
2020-04-17	EW	Futures	1656.4	1672.7	1633.1	1649.6	13145.0
2020-04-17	FBON	Futures	139.2	139.79	139.03	139.52	228.0
2020-04-17	FBTP	Futures	123.31	123.81	123.04	123.27	72995.0
2020-04-17	FBTS	Futures	106.316	106.556	106.277	106.46	45259.0
2020-04-17	FCE	Futures	4340.7	4378.0	4295.2	4325.7	70167.0
2020-04-17	FDAX	Futures	11103.1	11372.3	11103.1	11196.7	104809.0
2020-04-17	FDIV	Futures	117.74	119.42	117.56	117.56	250.0
2020-04-17	FDXM	Futures	11148.7	11427.2	11142.4	11250.2	68834.0
2020-04-17	FESX	Futures	2601.1	2657.1	2601.1	2609.4	1533359.0
2020-04-17	FGBL	Futures	167.62	168.06	167.36	168.02	299089.0
2020-04-17	FGBM	Futures	134.51	134.67	134.44	134.65	188758.0
2020-04-17	FGBS	Futures	112.835	112.885	112.835	112.885	154036.0
2020-04-17	FGBX	Futures	226.86	228.01	225.57	227.44	22541.0
2020-04-17	FMWO	Futures	6978.6	7004.5	6897.4	6903.3	2390.0
2020-04-17	FOAT	Futures	151.77	152.25	151.65	152.21	69152.0
2020-04-17	FTDX	Futures	2897.1	2899.1	2881.4	2895.6	61.0
2020-04-17	FTI	Futures	476.23	477.35	468.87	470.46	33211.0
2020-04-17	FTUK	Futures	5414.0	5494.7	5398.0	5417.3	128020.0
2020-04-17	FVSA	Futures	312.82	328.12	308.77	327.67	8225.0
2020-04-17	FXXP	Futures	307.1	309.0	304.3	305.5	86202.0
2020-04-17	G	Futures	125.23	125.61	125.22	125.44	103188.0

> showing 50 of 119 rows — these rows as CSV

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