PREVIEW / futures_daily / 2018-03-28

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-28.parquet
  size:    10 KB
  rows:    112

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
2018-03-28	ES	Futures	2841.28	2864.12	2819.8	2835.57	2802883.0
2018-03-28	NQ	Futures	7666.63	7704.08	7515.35	7581.19	948120.0
2018-03-28	YM	Futures	25127.8	25360.6	24973.0	25134.1	492033.0
2018-03-28	CL	Futures	64.98	65.41	63.99	64.65	697678.0
2018-03-28	GC	Futures	1724.9	1726.3	1695.0	1698.0	386854.0
2018-03-28	ZN	Futures	120.09846	120.377614	119.88134	120.005408	2317510.0
2018-03-28	A6	Futures	0.7898	0.79216	0.78712	0.78794	107775.0
2018-03-28	AD	Futures	0.78652	0.78768	0.78338	0.78465	81442.0
2018-03-28	B	Futures	50.19	50.49	49.41	49.98	380310.0
2018-03-28	B6	Futures	1.4715	1.4752	1.4616	1.4631	109658.0
2018-03-28	BR	Futures	0.22639	0.2273	0.22639	0.2273	4642.0
2018-03-28	BTC	Futures	11247.7	11489.1	10999.1	11219.3	493.0
2018-03-28	BZ	Futures	49.49	49.84	48.77	49.33	34556.0
2018-03-28	C	Futures	1658.0	1680.0	1608.0	1677.0	18595.0
2018-03-28	CB	Futures	280.444	282.235	279.455	280.444	54.0
2018-03-28	CC	Futures	1886.0	1910.0	1827.0	1905.0	27281.0
2018-03-28	CNH	Futures	6.3767	6.395	6.3767	6.395	12.0
2018-03-28	CSC	Futures	3.335	3.335	3.302	3.314	44.0
2018-03-28	CT	Futures	94.26	94.41	92.73	92.81	17420.0
2018-03-28	DC	Futures	26.47	26.51	26.3	26.37	130.0
2018-03-28	DX	Futures	83.911	84.712	83.84	84.617	32562.0
2018-03-28	E1	Futures	1.28114	1.28138	1.26524	1.26693	29044.0
2018-03-28	E6	Futures	1.40569	1.40721	1.39336	1.39477	228413.0
2018-03-28	E7	Futures	1.3982	1.3996	1.3857	1.3873	3288.0
2018-03-28	EBM	Futures	175.05	175.59	174.79	175.05	10377.0
2018-03-28	ED	Futures	95.0375	95.0473	95.0084	95.023	622469.0
2018-03-28	ER	Futures	98.337	98.337	98.332	98.337	75275.0
2018-03-28	EW	Futures	1960.3	1975.6	1951.0	1965.8	21032.0
2018-03-28	FBON	Futures	129.98	130.24	129.88	130.2	236.0
2018-03-28	FBTP	Futures	114.78	115.12	114.64	115.0	123763.0
2018-03-28	FBTS	Futures	104.139	104.223	104.13	104.204	48468.0
2018-03-28	FCE	Futures	4449.8	4539.8	4432.2	4514.7	106596.0
2018-03-28	FDAX	Futures	12307.5	12487.2	12231.6	12387.0	136095.0
2018-03-28	FDIV	Futures	143.36	143.63	143.36	143.63	30.0
2018-03-28	FDXM	Futures	12203.6	12375.5	12123.2	12276.7	58872.0
2018-03-28	FESX	Futures	2659.8	2717.3	2648.2	2694.8	1559233.0
2018-03-28	FGBL	Futures	149.91	150.28	149.74	149.92	824206.0
2018-03-28	FGBM	Futures	129.72	129.85	129.65	129.74	488937.0
2018-03-28	FGBS	Futures	112.583	112.593	112.553	112.568	241871.0
2018-03-28	FGBX	Futures	171.69	172.27	170.86	171.42	59980.0
2018-03-28	FMWO	Futures	6799.7	6823.0	6764.6	6783.3	2473.0
2018-03-28	FOAT	Futures	139.09	139.43	139.01	139.09	147164.0
2018-03-28	FTDX	Futures	2503.4	2503.4	2447.0	2448.5	544.0
2018-03-28	FTI	Futures	475.65	485.01	473.58	482.21	45884.0
2018-03-28	FTUK	Futures	6049.3	6165.0	6040.4	6135.4	160380.0
2018-03-28	FVSA	Futures	464.92	488.71	444.71	460.17	55131.0
2018-03-28	FXXP	Futures	308.7	314.2	307.1	312.2	106191.0
2018-03-28	G	Futures	113.77	114.22	113.77	114.15	285324.0
2018-03-28	GF	Futures	295.284	301.709	294.957	300.184	3169.0
2018-03-28	GSCI	Futures	515.42	516.16	512.05	514.96	55.0

> showing 50 of 112 rows — these rows as CSV

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