PREVIEW / futures_daily / 2017-06-08

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-08.parquet
  size:    9 KB
  rows:    109

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
2017-06-08	ES	Futures	2640.71	2648.86	2636.1	2641.8	1445922.0
2017-06-08	NQ	Futures	6922.75	6946.31	6894.19	6931.29	266471.0
2017-06-08	YM	Futures	22333.7	22443.4	22298.9	22346.4	131835.0
2017-06-08	CL	Futures	47.49	47.83	46.82	47.27	927695.0
2017-06-08	GC	Futures	1646.1	1648.7	1625.7	1633.4	257436.0
2017-06-08	ZN	Futures	124.657894	124.657894	124.319317	124.550165	1304371.0
2017-06-08	A6	Futures	0.77506	0.77537	0.77239	0.77465	77594.0
2017-06-08	AD	Futures	0.75529	0.75646	0.75437	0.75544	55193.0
2017-06-08	ALI	Futures	2499.86	2499.86	2499.86	2499.86	0.0
2017-06-08	B	Futures	34.33	34.57	33.83	34.05	445968.0
2017-06-08	B6	Futures	1.3588	1.3609	1.3535	1.3574	92136.0
2017-06-08	BR	Futures	0.22126	0.22323	0.22126	0.22323	2.0
2017-06-08	BZ	Futures	34.16	34.41	33.69	33.9	40901.0
2017-06-08	C	Futures	1548.0	1620.0	1536.0	1554.0	15040.0
2017-06-08	CB	Futures	307.147	311.314	307.147	310.158	45.0
2017-06-08	CC	Futures	1503.0	1569.0	1500.0	1510.0	39688.0
2017-06-08	CNH	Futures	7.0587	7.0711	7.0587	7.0655	60.0
2017-06-08	CSC	Futures	3.602	3.602	3.579	3.594	27.0
2017-06-08	CT	Futures	84.06	85.0	83.74	84.78	16717.0
2017-06-08	DC	Futures	30.07	30.16	29.96	30.0	36.0
2017-06-08	DX	Futures	90.087	90.497	89.966	90.276	33920.0
2017-06-08	E1	Futures	1.2811	1.28246	1.27493	1.27876	24285.0
2017-06-08	E6	Futures	1.2974	1.29861	1.29003	1.29332	234545.0
2017-06-08	E7	Futures	1.2907	1.292	1.2834	1.2867	5915.0
2017-06-08	EBM	Futures	188.17	189.84	188.17	189.57	17067.0
2017-06-08	ED	Futures	95.5905	95.5905	95.5809	95.5833	221040.0
2017-06-08	ER	Futures	98.337	98.337	98.332	98.337	59540.0
2017-06-08	EW	Futures	1844.7	1865.8	1841.3	1860.4	31637.0
2017-06-08	FBON	Futures	123.56	124.67	123.53	124.39	1222.0
2017-06-08	FBTP	Futures	105.94	107.64	105.82	107.19	176068.0
2017-06-08	FBTS	Futures	102.435	102.59	102.426	102.562	74466.0
2017-06-08	FCE	Futures	4737.6	4747.4	4710.6	4723.2	95886.0
2017-06-08	FDAX	Futures	13402.2	13452.4	13377.4	13423.8	81991.0
2017-06-08	FDXM	Futures	13289.7	13334.7	13260.4	13305.9	24188.0
2017-06-08	FESX	Futures	2899.4	2914.9	2892.0	2906.7	1013193.0
2017-06-08	FGBL	Futures	149.72	150.06	149.44	149.87	801473.0
2017-06-08	FGBM	Futures	129.87	129.95	129.68	129.89	536281.0
2017-06-08	FGBS	Futures	112.372	112.412	112.322	112.397	285288.0
2017-06-08	FGBX	Futures	169.21	170.41	168.55	169.86	67362.0
2017-06-08	FMWO	Futures	6490.4	6491.6	6472.3	6480.8	2290.0
2017-06-08	FOAT	Futures	136.07	136.76	136.05	136.6	140902.0
2017-06-08	FTDX	Futures	2266.6	2266.6	2244.0	2248.4	478.0
2017-06-08	FTI	Futures	480.57	482.36	479.56	480.15	26162.0
2017-06-08	FTUK	Futures	6397.7	6410.1	6371.6	6376.8	195868.0
2017-06-08	FVSA	Futures	489.27	492.66	480.81	484.19	23435.0
2017-06-08	FXXP	Futures	328.4	329.4	327.6	328.4	48830.0
2017-06-08	G	Futures	116.53	116.53	115.99	116.14	159452.0
2017-06-08	GF	Futures	340.363	344.315	335.973	337.949	5726.0
2017-06-08	GSCI	Futures	456.66	456.85	451.25	452.29	2423.0
2017-06-08	HE	Futures	85.931	87.576	85.931	87.258	16142.0

> showing 50 of 109 rows — these rows as CSV

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