PREVIEW / futures_daily / 2017-05-09

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-09.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-05-09	ES	Futures	2600.53	2606.5	2594.29	2599.17	1105436.0
2017-05-09	NQ	Futures	6659.52	6698.97	6655.39	6685.43	194000.0
2017-05-09	YM	Futures	22098.4	22144.8	22026.6	22060.4	88501.0
2017-05-09	CL	Futures	48.51	48.81	47.51	47.87	701944.0
2017-05-09	GC	Futures	1568.6	1571.3	1552.9	1555.2	254020.0
2017-05-09	ZN	Futures	122.860387	122.96793	122.660664	122.737481	1094660.0
2017-05-09	A6	Futures	0.75761	0.75884	0.75176	0.75258	109397.0
2017-05-09	AD	Futures	0.74499	0.74636	0.74187	0.74376	77846.0
2017-05-09	ALI	Futures	2503.12	2503.12	2503.12	2503.12	0.0
2017-05-09	B	Futures	35.46	35.66	34.7	34.95	332913.0
2017-05-09	B6	Futures	1.3581	1.3603	1.3543	1.3566	87556.0
2017-05-09	BFX	Futures	4866.6	4866.6	4848.5	4848.5	7.0
2017-05-09	BR	Futures	0.22459	0.22651	0.22415	0.22604	2421.0
2017-05-09	BZ	Futures	35.2	35.4	34.47	34.7	33410.0
2017-05-09	C	Futures	1555.0	1566.0	1539.0	1551.0	4750.0
2017-05-09	CB	Futures	263.645	263.706	263.431	263.706	39.0
2017-05-09	CC	Futures	1505.0	1507.0	1473.0	1499.0	24969.0
2017-05-09	CNH	Futures	7.2322	7.2353	7.2308	7.2321	87.0
2017-05-09	CSC	Futures	3.531	3.558	3.531	3.547	20.0
2017-05-09	CT	Futures	85.49	86.18	85.35	85.75	15523.0
2017-05-09	DC	Futures	29.7	29.72	29.34	29.62	374.0
2017-05-09	DX	Futures	92.253	92.761	92.197	92.742	29649.0
2017-05-09	E1	Futures	1.23996	1.24132	1.22723	1.22773	34396.0
2017-05-09	E6	Futures	1.26072	1.26175	1.25369	1.25427	198036.0
2017-05-09	E7	Futures	1.2542	1.2553	1.2473	1.2479	4145.0
2017-05-09	EBM	Futures	187.62	188.73	187.34	188.45	9233.0
2017-05-09	ED	Futures	95.5446	95.5688	95.5397	95.5591	384955.0
2017-05-09	ER	Futures	98.337	98.337	98.332	98.332	19536.0
2017-05-09	EW	Futures	1837.4	1842.8	1829.6	1834.5	14348.0
2017-05-09	FBON	Futures	122.59	122.59	122.34	122.43	709.0
2017-05-09	FBTP	Futures	105.8	105.84	105.5	105.64	90248.0
2017-05-09	FBTS	Futures	102.208	102.253	102.19	102.244	26136.0
2017-05-09	FCE	Futures	4787.3	4806.5	4778.0	4790.5	87142.0
2017-05-09	FDAX	Futures	13423.8	13505.1	13419.1	13484.0	62827.0
2017-05-09	FDXM	Futures	13308.5	13386.0	13300.2	13365.6	17541.0
2017-05-09	FESX	Futures	2945.1	2957.3	2936.1	2949.1	884551.0
2017-05-09	FEU3	Futures	99.011	99.011	99.011	99.011	6.0
2017-05-09	FGBL	Futures	147.48	147.49	147.15	147.31	681102.0
2017-05-09	FGBM	Futures	128.91	128.95	128.8	128.91	519375.0
2017-05-09	FGBS	Futures	112.172	112.202	112.157	112.192	205985.0
2017-05-09	FGBX	Futures	165.89	165.97	164.69	164.91	52592.0
2017-05-09	FMWO	Futures	6371.1	6379.6	6371.1	6371.1	2018.0
2017-05-09	FOAT	Futures	134.08	134.1	133.66	133.84	130214.0
2017-05-09	FTDX	Futures	2096.5	2111.2	2091.6	2107.3	199.0
2017-05-09	FTI	Futures	487.08	489.92	487.03	488.46	20421.0
2017-05-09	FTUK	Futures	6212.0	6256.5	6203.5	6245.0	93615.0
2017-05-09	FVSA	Futures	517.19	524.34	508.24	520.76	30100.0
2017-05-09	FXXP	Futures	330.9	332.0	330.7	331.7	57514.0
2017-05-09	G	Futures	114.86	114.91	114.3	114.56	200854.0
2017-05-09	GF	Futures	341.168	344.032	329.482	331.144	2286.0

> showing 50 of 112 rows — these rows as CSV

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