PREVIEW / futures_daily / 2016-10-18

all futures daily files

  file:    by_date/futures_daily/2016/2016-10-18.parquet
  size:    9 KB
  rows:    109

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-10-18	ES	Futures	2295.69	2314.35	2293.25	2305.96	1139317.0
2016-10-18	NQ	Futures	5659.68	5723.92	5656.74	5688.85	205551.0
2016-10-18	YM	Futures	18890.4	19051.0	18875.6	18968.1	120223.0
2016-10-18	CL	Futures	55.05	55.76	54.7	55.24	380490.0
2016-10-18	GC	Futures	1611.5	1623.8	1611.3	1620.3	148172.0
2016-10-18	ZN	Futures	126.602877	126.815681	126.450875	126.75488	1116022.0
2016-10-18	A6	Futures	0.77744	0.78346	0.77683	0.78101	87129.0
2016-10-18	AD	Futures	0.78037	0.78907	0.77985	0.78139	65426.0
2016-10-18	ALI	Futures	2217.32	2217.32	2198.1	2198.1	20.0
2016-10-18	B	Futures	40.03	40.36	39.66	40.0	274173.0
2016-10-18	B6	Futures	1.2843	1.2988	1.2838	1.2955	138841.0
2016-10-18	BFX	Futures	4262.9	4264.0	4261.1	4264.0	38.0
2016-10-18	BR	Futures	0.21239	0.21291	0.21239	0.21291	43.0
2016-10-18	BZ	Futures	39.77	40.11	39.45	39.77	28432.0
2016-10-18	C	Futures	2394.0	2409.0	2359.0	2372.0	14160.0
2016-10-18	CB	Futures	226.909	226.909	226.289	226.909	54.0
2016-10-18	CC	Futures	1990.0	2019.0	1980.0	1995.0	17290.0
2016-10-18	CNH	Futures	7.2812	7.2812	7.27	7.2712	149.0
2016-10-18	CSC	Futures	3.737	3.79	3.737	3.776	76.0
2016-10-18	CT	Futures	79.81	80.33	79.17	79.71	17452.0
2016-10-18	DC	Futures	29.23	29.78	29.15	29.63	288.0
2016-10-18	DX	Futures	91.006	91.178	90.838	91.115	16774.0
2016-10-18	E1	Futures	1.2635	1.26674	1.26064	1.26263	16133.0
2016-10-18	E6	Futures	1.27817	1.28141	1.27481	1.27573	131698.0
2016-10-18	E7	Futures	1.2713	1.2745	1.268	1.2688	2081.0
2016-10-18	EBM	Futures	193.0	193.59	192.41	192.7	15217.0
2016-10-18	ED	Futures	95.6538	95.6635	95.6442	95.6538	312131.0
2016-10-18	ER	Futures	98.279	98.283	98.274	98.279	81086.0
2016-10-18	EW	Futures	1613.7	1630.0	1613.7	1622.5	11160.0
2016-10-18	FBON	Futures	124.15	124.35	124.15	124.35	658.0
2016-10-18	FBTP	Futures	108.12	108.47	108.12	108.4	71722.0
2016-10-18	FBTS	Futures	101.221	101.23	101.212	101.221	5804.0
2016-10-18	FCE	Futures	3977.8	4023.2	3968.9	4013.4	153954.0
2016-10-18	FDAX	Futures	11149.2	11256.5	11129.1	11227.9	80467.0
2016-10-18	FDXM	Futures	11123.5	11233.2	11104.6	11203.7	21846.0
2016-10-18	FESX	Futures	2416.6	2440.6	2413.4	2433.4	776137.0
2016-10-18	FEU3	Futures	98.961	98.961	98.956	98.956	15.0
2016-10-18	FGBL	Futures	149.21	149.57	149.1	149.5	597518.0
2016-10-18	FGBM	Futures	128.78	128.88	128.74	128.87	392585.0
2016-10-18	FGBS	Futures	111.922	111.952	111.912	111.947	199846.0
2016-10-18	FGBX	Futures	179.84	181.13	179.29	180.98	34399.0
2016-10-18	FMWO	Futures	5680.8	5686.8	5679.6	5683.2	88.0
2016-10-18	FOAT	Futures	136.94	137.3	136.87	137.22	91873.0
2016-10-18	FTDX	Futures	1735.2	1750.4	1735.2	1748.4	45.0
2016-10-18	FTI	Futures	411.5	417.8	411.5	414.95	23719.0
2016-10-18	FTUK	Futures	5834.3	5906.9	5834.3	5873.1	106006.0
2016-10-18	FVSA	Futures	1453.16	1459.35	1431.52	1437.7	36811.0
2016-10-18	FXXP	Futures	279.5	282.4	279.1	281.7	30573.0
2016-10-18	G	Futures	112.76	113.25	112.55	113.1	252553.0
2016-10-18	GF	Futures	251.742	253.944	249.541	253.46	4543.0

> showing 50 of 109 rows — these rows as CSV

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