PREVIEW / futures_daily / 2017-06-19

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-19.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
2017-06-19	ES	Futures	2644.78	2664.35	2643.97	2660.0	1223334.0
2017-06-19	NQ	Futures	6693.83	6797.57	6680.89	6778.17	271968.0
2017-06-19	YM	Futures	22587.2	22706.7	22568.2	22686.6	107501.0
2017-06-19	CL	Futures	46.36	46.76	45.71	45.88	620967.0
2017-06-19	GC	Futures	1603.1	1605.0	1588.4	1591.5	179650.0
2017-06-19	ZN	Futures	124.873352	124.996471	124.503996	124.550165	1005770.0
2017-06-19	A6	Futures	0.78164	0.78277	0.77825	0.77917	65797.0
2017-06-19	AD	Futures	0.7707	0.77217	0.76836	0.76978	61717.0
2017-06-19	ALI	Futures	2491.6	2491.6	2491.6	2491.6	0.0
2017-06-19	B	Futures	33.58	33.98	33.27	33.37	261488.0
2017-06-19	B6	Futures	1.3376	1.343	1.3335	1.3341	88802.0
2017-06-19	BFX	Futures	4739.3	4747.7	4739.3	4747.7	6.0
2017-06-19	BR	Futures	0.22048	0.22226	0.21959	0.22226	11.0
2017-06-19	BZ	Futures	33.51	33.82	33.13	33.23	19703.0
2017-06-19	C	Futures	1627.0	1638.0	1564.0	1568.0	9451.0
2017-06-19	CB	Futures	317.73	319.889	317.73	319.859	30.0
2017-06-19	CC	Futures	1547.0	1553.0	1463.0	1468.0	24210.0
2017-06-19	CNH	Futures	7.0965	7.0982	7.0921	7.0966	21.0
2017-06-19	CSC	Futures	3.577	3.577	3.557	3.565	22.0
2017-06-19	CT	Futures	79.57	81.29	78.8	79.06	7013.0
2017-06-19	DC	Futures	30.07	30.07	29.72	29.86	316.0
2017-06-19	DX	Futures	90.435	90.842	90.342	90.822	18122.0
2017-06-19	E1	Futures	1.26965	1.27419	1.26584	1.26633	20184.0
2017-06-19	E6	Futures	1.28952	1.29095	1.28293	1.28356	138442.0
2017-06-19	E7	Futures	1.2825	1.2842	1.2761	1.2768	3104.0
2017-06-19	EBM	Futures	194.02	197.92	194.02	197.64	31660.0
2017-06-19	ED	Futures	95.5935	95.5935	95.5692	95.5692	345047.0
2017-06-19	ER	Futures	98.337	98.337	98.332	98.332	57298.0
2017-06-19	EW	Futures	1865.3	1876.3	1865.3	1873.9	10221.0
2017-06-19	FBON	Futures	124.63	124.77	124.53	124.66	313.0
2017-06-19	FBTP	Futures	109.1	109.54	109.06	109.45	57817.0
2017-06-19	FBTS	Futures	102.854	102.881	102.836	102.854	15121.0
2017-06-19	FCE	Futures	4755.1	4799.7	4751.9	4781.2	77567.0
2017-06-19	FDAX	Futures	13445.7	13594.2	13445.7	13571.5	72660.0
2017-06-19	FDIV	Futures	153.23	153.49	153.23	153.49	50.0
2017-06-19	FDXM	Futures	13368.2	13510.5	13368.2	13488.0	18319.0
2017-06-19	FESX	Futures	2895.3	2926.3	2895.3	2918.9	675964.0
2017-06-19	FEU3	Futures	99.011	99.011	99.006	99.006	6.0
2017-06-19	FGBL	Futures	149.6	149.73	149.37	149.57	475006.0
2017-06-19	FGBM	Futures	129.61	129.66	129.48	129.55	329364.0
2017-06-19	FGBS	Futures	112.277	112.282	112.237	112.257	143339.0
2017-06-19	FGBX	Futures	169.66	170.22	169.25	170.0	39027.0
2017-06-19	FMWO	Futures	6456.7	6468.6	6447.1	6461.4	268.0
2017-06-19	FOAT	Futures	136.75	136.94	136.6	136.83	92066.0
2017-06-19	FTDX	Futures	2303.2	2333.3	2281.2	2299.2	122.0
2017-06-19	FTI	Futures	480.87	486.36	480.87	484.61	24933.0
2017-06-19	FTUK	Futures	6429.7	6463.4	6422.8	6452.2	60304.0
2017-06-19	FVSA	Futures	467.62	469.19	444.0	450.3	24509.0
2017-06-19	FXXP	Futures	331.4	333.3	331.3	332.4	20919.0
2017-06-19	G	Futures	116.25	116.38	116.03	116.26	111044.0

> showing 50 of 112 rows — these rows as CSV

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