PREVIEW / futures_daily / 2017-11-10

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-10.parquet
  size:    9 KB
  rows:    108

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-11-10	ES	Futures	2808.43	2812.5	2797.01	2805.71	1193217.0
2017-11-10	NQ	Futures	7415.03	7424.72	7377.74	7410.92	266728.0
2017-11-10	YM	Futures	24713.4	24759.9	24644.8	24691.3	113940.0
2017-11-10	CL	Futures	57.5	57.83	57.03	57.22	541296.0
2017-11-10	GC	Futures	1636.3	1638.5	1620.5	1621.3	354580.0
2017-11-10	ZN	Futures	123.362719	123.393529	122.900571	122.946786	1387082.0
2017-11-10	A6	Futures	0.78959	0.79144	0.78722	0.78774	72114.0
2017-11-10	AD	Futures	0.80236	0.80353	0.80165	0.80267	54653.0
2017-11-10	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-11-10	B	Futures	45.13	45.46	44.81	44.93	307965.0
2017-11-10	B6	Futures	1.3717	1.3807	1.3684	1.3772	109444.0
2017-11-10	BR	Futures	0.23155	0.23155	0.22917	0.22974	2009.0
2017-11-10	BZ	Futures	44.75	45.06	44.41	44.53	24446.0
2017-11-10	C	Futures	1598.0	1618.0	1593.0	1607.0	13656.0
2017-11-10	CB	Futures	282.211	285.959	282.211	283.534	14.0
2017-11-10	CC	Futures	1631.0	1661.0	1626.0	1650.0	28262.0
2017-11-10	CNH	Futures	6.8289	6.8503	6.8278	6.8503	116.0
2017-11-10	CSC	Futures	3.418	3.46	3.408	3.41	66.0
2017-11-10	CT	Futures	80.33	81.26	80.28	81.1	20774.0
2017-11-10	DC	Futures	27.96	28.03	27.45	27.59	307.0
2017-11-10	DX	Futures	88.246	88.424	88.05	88.165	14645.0
2017-11-10	E1	Futures	1.23286	1.23457	1.22931	1.23054	24249.0
2017-11-10	E6	Futures	1.3309	1.33501	1.32868	1.33353	185189.0
2017-11-10	E7	Futures	1.3242	1.3279	1.3218	1.3265	3108.0
2017-11-10	EBM	Futures	173.16	173.7	172.62	173.16	18788.0
2017-11-10	ED	Futures	95.4745	95.4794	95.4697	95.4697	112448.0
2017-11-10	ER	Futures	98.347	98.347	98.342	98.342	17560.0
2017-11-10	EW	Futures	1940.7	1944.1	1933.9	1939.6	15182.0
2017-11-10	FBON	Futures	125.59	125.91	125.43	125.45	356.0
2017-11-10	FBTP	Futures	112.42	112.67	112.09	112.2	103896.0
2017-11-10	FBTS	Futures	103.695	103.732	103.658	103.686	44874.0
2017-11-10	FCE	Futures	4841.8	4853.9	4816.3	4822.1	77000.0
2017-11-10	FDAX	Futures	13865.1	13889.8	13775.3	13790.5	88282.0
2017-11-10	FDXM	Futures	13743.9	13773.1	13659.5	13674.1	27630.0
2017-11-10	FESX	Futures	2940.9	2949.1	2923.0	2926.2	1069250.0
2017-11-10	FEU3	Futures	99.011	99.016	99.011	99.016	2.0
2017-11-10	FGBL	Futures	150.29	150.31	149.91	149.97	689589.0
2017-11-10	FGBM	Futures	130.08	130.1	129.98	129.99	469279.0
2017-11-10	FGBS	Futures	112.547	112.557	112.537	112.542	212056.0
2017-11-10	FGBX	Futures	168.01	168.2	167.09	167.2	58375.0
2017-11-10	FMWO	Futures	6787.6	6787.6	6764.0	6768.7	454.0
2017-11-10	FOAT	Futures	138.17	138.2	137.83	137.86	114041.0
2017-11-10	FTDX	Futures	2432.1	2490.5	2432.1	2480.0	514.0
2017-11-10	FTI	Futures	509.0	509.32	506.54	506.95	169.0
2017-11-10	FTUK	Futures	6480.3	6492.0	6422.6	6434.3	95341.0
2017-11-10	FVSA	Futures	345.32	360.67	335.09	356.83	47022.0
2017-11-10	FXXP	Futures	331.2	331.7	329.3	329.8	37615.0
2017-11-10	G	Futures	114.33	114.34	113.76	113.78	155040.0
2017-11-10	GF	Futures	341.542	343.11	338.137	339.813	5661.0
2017-11-10	GSCI	Futures	503.13	503.13	501.38	501.38	2195.0

> showing 50 of 108 rows — these rows as CSV

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