PREVIEW / futures_daily / 2017-12-19

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-19.parquet
  size:    10 KB
  rows:    111

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-12-19	ES	Futures	2929.14	2932.4	2915.55	2917.18	980483.0
2017-12-19	NQ	Futures	7653.66	7666.25	7588.95	7613.55	272966.0
2017-12-19	YM	Futures	26180.6	26252.3	26080.4	26127.9	114531.0
2017-12-19	CL	Futures	57.33	57.79	57.19	57.55	420784.0
2017-12-19	GC	Futures	1604.3	1608.3	1600.3	1602.7	206586.0
2017-12-19	ZN	Futures	122.607664	122.669369	122.05232	122.114025	1383059.0
2017-12-19	A6	Futures	0.78825	0.7902	0.78629	0.78825	63348.0
2017-12-19	AD	Futures	0.79082	0.79158	0.78711	0.7898	57612.0
2017-12-19	B	Futures	45.05	45.4	44.97	45.33	213190.0
2017-12-19	B6	Futures	1.3978	1.3995	1.392	1.3973	80726.0
2017-12-19	BFX	Futures	4776.1	4784.5	4776.1	4784.5	6.0
2017-12-19	BR	Futures	0.22835	0.22839	0.22835	0.22839	2.0
2017-12-19	BZ	Futures	44.73	45.06	44.63	44.98	22157.0
2017-12-19	C	Futures	1298.0	1300.0	1276.0	1290.0	10707.0
2017-12-19	CB	Futures	278.158	278.498	276.768	277.633	38.0
2017-12-19	CC	Futures	1429.0	1438.0	1413.0	1427.0	18510.0
2017-12-19	CNH	Futures	6.7821	6.7821	6.7681	6.7694	14.0
2017-12-19	CSC	Futures	3.293	3.302	3.244	3.257	114.0
2017-12-19	CT	Futures	87.95	88.67	87.52	87.63	15357.0
2017-12-19	DC	Futures	25.96	25.96	25.44	25.5	253.0
2017-12-19	DX	Futures	87.576	87.628	87.35	87.362	14677.0
2017-12-19	E1	Futures	1.24172	1.24402	1.23832	1.24123	23544.0
2017-12-19	E6	Futures	1.34515	1.35196	1.34442	1.35156	204801.0
2017-12-19	E7	Futures	1.3384	1.3451	1.3378	1.3448	4037.0
2017-12-19	EBM	Futures	173.97	174.51	173.7	174.24	12422.0
2017-12-19	ED	Futures	95.3893	95.399	95.3796	95.3844	317156.0
2017-12-19	ER	Futures	98.337	98.342	98.332	98.332	130949.0
2017-12-19	EW	Futures	2024.3	2028.8	2012.4	2016.1	11257.0
2017-12-19	FBON	Futures	126.93	127.25	126.41	126.61	568.0
2017-12-19	FBTP	Futures	113.2	113.3	111.96	112.24	69748.0
2017-12-19	FBTS	Futures	103.778	103.805	103.586	103.604	59234.0
2017-12-19	FCE	Futures	4842.3	4850.8	4809.6	4815.9	52514.0
2017-12-19	FDAX	Futures	13808.8	13836.3	13692.1	13713.8	56489.0
2017-12-19	FDIV	Futures	153.19	153.19	151.65	151.65	15.0
2017-12-19	FDXM	Futures	13836.4	13859.2	13716.8	13737.1	17638.0
2017-12-19	FESX	Futures	2936.8	2943.4	2914.0	2918.0	657083.0
2017-12-19	FGBL	Futures	151.34	151.41	150.28	150.49	617316.0
2017-12-19	FGBM	Futures	130.05	130.09	129.67	129.77	430140.0
2017-12-19	FGBS	Futures	112.497	112.502	112.427	112.447	299531.0
2017-12-19	FGBX	Futures	172.55	172.71	169.92	170.39	61984.0
2017-12-19	FMWO	Futures	6956.2	6957.3	6932.8	6935.2	700.0
2017-12-19	FOAT	Futures	140.01	140.11	138.98	139.2	101669.0
2017-12-19	FTDX	Futures	2551.3	2559.8	2542.9	2551.3	80.0
2017-12-19	FTI	Futures	512.93	513.85	510.24	510.94	15841.0
2017-12-19	FTUK	Futures	6540.5	6556.3	6524.4	6537.5	82100.0
2017-12-19	FVSA	Futures	272.86	277.07	266.54	273.91	31497.0
2017-12-19	FXXP	Futures	333.6	334.0	331.5	331.8	14893.0
2017-12-19	G	Futures	115.74	115.79	115.07	115.24	150072.0
2017-12-19	GF	Futures	319.436	320.517	312.842	313.923	6216.0
2017-12-19	GSCI	Futures	492.45	492.45	491.87	491.93	4.0

> showing 50 of 111 rows — these rows as CSV

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