PREVIEW / futures_daily / 2016-09-27

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-27.parquet
  size:    9 KB
  rows:    110

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
2016-09-27	ES	Futures	2313.8	2329.76	2306.77	2328.41	1659780.0
2016-09-27	NQ	Futures	5673.24	5733.05	5657.92	5728.63	227156.0
2016-09-27	YM	Futures	18912.4	19060.5	18857.8	19046.8	153632.0
2016-09-27	CL	Futures	50.3	50.68	48.73	49.26	630757.0
2016-09-27	GC	Futures	1721.8	1723.7	1703.5	1706.9	187753.0
2016-09-27	ZN	Futures	127.788497	128.092502	127.575693	127.955699	1172225.0
2016-09-27	A6	Futures	0.77775	0.78367	0.7751	0.7805	92316.0
2016-09-27	AD	Futures	0.77478	0.77842	0.77156	0.77545	78446.0
2016-09-27	ALI	Futures	2175.95	2175.95	2175.95	2175.95	0.0
2016-09-27	B	Futures	36.92	37.06	35.73	36.0	317115.0
2016-09-27	B6	Futures	1.368	1.3737	1.3642	1.3732	74285.0
2016-09-27	BFX	Futures	4186.0	4205.7	4186.0	4205.7	1.0
2016-09-27	BR	Futures	0.20825	0.20931	0.20821	0.20835	311.0
2016-09-27	BZ	Futures	36.69	36.84	35.53	35.8	21148.0
2016-09-27	C	Futures	2427.0	2443.0	2417.0	2437.0	11277.0
2016-09-27	CB	Futures	246.903	246.903	243.028	243.028	19.0
2016-09-27	CC	Futures	2104.0	2127.0	2094.0	2121.0	14287.0
2016-09-27	CNH	Futures	7.208	7.208	7.2029	7.2029	15.0
2016-09-27	CSC	Futures	3.758	3.76	3.709	3.723	43.0
2016-09-27	CT	Futures	78.5	79.28	77.7	78.13	12842.0
2016-09-27	DC	Futures	29.55	29.65	29.07	29.21	168.0
2016-09-27	DX	Futures	88.651	88.958	88.553	88.709	13878.0
2016-09-27	E1	Futures	1.29141	1.29577	1.28668	1.29004	17374.0
2016-09-27	E6	Futures	1.30906	1.30993	1.30199	1.30553	170328.0
2016-09-27	E7	Futures	1.3019	1.3027	1.295	1.2984	1974.0
2016-09-27	EBM	Futures	188.58	190.64	188.29	190.06	16282.0
2016-09-27	ED	Futures	95.6731	95.6731	95.6442	95.6586	313291.0
2016-09-27	ER	Futures	98.288	98.288	98.259	98.269	235431.0
2016-09-27	EW	Futures	1640.2	1650.9	1630.9	1638.6	17562.0
2016-09-27	FBON	Futures	125.16	125.52	124.95	125.3	1416.0
2016-09-27	FBTP	Futures	110.15	110.31	109.49	109.83	137590.0
2016-09-27	FBTS	Futures	101.338	101.347	101.284	101.311	23067.0
2016-09-27	FCE	Futures	3932.9	3944.4	3874.6	3907.5	88006.0
2016-09-27	FDAX	Futures	11031.9	11049.3	10834.3	10919.9	107993.0
2016-09-27	FDXM	Futures	11003.3	11024.4	10811.4	10896.3	37330.0
2016-09-27	FESX	Futures	2389.3	2393.3	2350.1	2366.9	1153616.0
2016-09-27	FEU3	Futures	98.942	98.952	98.942	98.952	14.0
2016-09-27	FGBL	Futures	151.11	151.81	151.07	151.55	764442.0
2016-09-27	FGBM	Futures	129.24	129.48	129.23	129.42	437660.0
2016-09-27	FGBS	Futures	111.982	112.037	111.967	112.017	325647.0
2016-09-27	FGBX	Futures	188.3	190.36	188.13	189.4	46346.0
2016-09-27	FMWO	Futures	5717.1	5723.1	5705.0	5720.7	73.0
2016-09-27	FOAT	Futures	138.81	139.25	138.74	139.12	142177.0
2016-09-27	FTDX	Futures	1749.4	1749.4	1729.3	1741.1	239.0
2016-09-27	FTI	Futures	413.2	413.94	407.01	410.59	26878.0
2016-09-27	FTUK	Futures	5719.9	5767.2	5679.8	5707.7	99250.0
2016-09-27	FVSA	Futures	1544.37	1640.89	1505.05	1590.84	22177.0
2016-09-27	FXXP	Futures	281.3	281.6	277.4	279.4	20453.0
2016-09-27	G	Futures	116.66	117.29	116.61	117.03	200098.0
2016-09-27	GF	Futures	268.958	269.732	261.068	261.686	5007.0

> showing 50 of 110 rows — these rows as CSV

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