PREVIEW / futures_daily / 2016-06-23

all futures daily files

  file:    by_date/futures_daily/2016/2016-06-23.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-06-23	ES	Futures	2249.0	2281.66	2249.0	2273.56	1314510.0
2016-06-23	NQ	Futures	5197.93	5279.85	5195.87	5260.11	194791.0
2016-06-23	YM	Futures	18526.6	18768.9	18526.6	18712.5	145954.0
2016-06-23	CL	Futures	57.01	58.35	57.01	58.21	401885.0
2016-06-23	GC	Futures	1631.4	1640.2	1617.0	1625.0	152586.0
2016-06-23	ZN	Futures	126.792398	126.792398	126.264222	126.339676	1096165.0
2016-06-23	A6	Futures	0.76287	0.77273	0.76164	0.7708	92572.0
2016-06-23	AD	Futures	0.79843	0.80734	0.79833	0.79966	63616.0
2016-06-23	ALI	Futures	2163.97	2163.97	2163.97	2163.97	0.0
2016-06-23	B	Futures	40.64	41.48	40.44	41.27	246953.0
2016-06-23	B6	Futures	1.5602	1.5765	1.5536	1.5616	179340.0
2016-06-23	BR	Futures	0.19524	0.19524	0.19471	0.19498	57.0
2016-06-23	BZ	Futures	40.37	41.23	40.34	41.16	31356.0
2016-06-23	C	Futures	2384.0	2393.0	2364.0	2391.0	6002.0
2016-06-23	CB	Futures	280.157	281.329	280.157	280.362	7.0
2016-06-23	CC	Futures	2325.0	2339.0	2319.0	2334.0	14748.0
2016-06-23	CNH	Futures	7.1445	7.146	7.1405	7.1405	3.0
2016-06-23	CSC	Futures	3.661	3.733	3.659	3.728	123.0
2016-06-23	CT	Futures	71.59	74.45	71.57	73.8	3448.0
2016-06-23	DC	Futures	29.59	30.25	29.43	30.07	400.0
2016-06-23	DX	Futures	87.072	87.123	86.519	86.985	29250.0
2016-06-23	E1	Futures	1.31123	1.32125	1.31023	1.31361	26113.0
2016-06-23	E6	Futures	1.32391	1.33387	1.32164	1.32607	159404.0
2016-06-23	E7	Futures	1.3157	1.3267	1.3146	1.319	4270.0
2016-06-23	EBM	Futures	193.96	193.96	190.66	191.26	14477.0
2016-06-23	ED	Futures	95.7666	95.7666	95.7425	95.7522	135196.0
2016-06-23	ER	Futures	98.274	98.274	98.264	98.269	54529.0
2016-06-23	EW	Futures	1583.3	1610.7	1581.5	1605.1	17851.0
2016-06-23	FBON	Futures	119.59	119.9	119.53	119.69	679.0
2016-06-23	FBTP	Futures	107.43	107.98	107.32	107.72	84238.0
2016-06-23	FBTS	Futures	101.024	101.096	101.024	101.087	23449.0
2016-06-23	FCE	Futures	3837.8	3926.2	3822.6	3888.3	130234.0
2016-06-23	FDAX	Futures	10779.7	11003.2	10737.2	10893.1	107191.0
2016-06-23	FDXM	Futures	10510.5	10725.2	10465.9	10617.8	29397.0
2016-06-23	FESX	Futures	2344.7	2394.8	2330.6	2370.6	1775654.0
2016-06-23	FEU3	Futures	98.927	98.927	98.927	98.927	16.0
2016-06-23	FGBL	Futures	147.89	148.13	147.14	147.52	737535.0
2016-06-23	FGBM	Futures	128.23	128.31	127.98	128.13	498268.0
2016-06-23	FGBS	Futures	111.793	111.808	111.728	111.758	216269.0
2016-06-23	FGBX	Futures	180.38	181.34	177.15	178.32	44899.0
2016-06-23	FMWO	Futures	5600.5	5661.3	5588.4	5634.6	691.0
2016-06-23	FOAT	Futures	135.24	135.46	134.66	134.94	117807.0
2016-06-23	FTDX	Futures	1571.5	1589.8	1570.1	1581.1	248.0
2016-06-23	FTI	Futures	398.5	407.81	397.91	404.21	36753.0
2016-06-23	FTUK	Futures	5226.1	5284.1	5189.4	5243.6	124854.0
2016-06-23	FVSA	Futures	2654.7	2664.81	2326.02	2452.44	53419.0
2016-06-23	FXXP	Futures	276.5	280.7	275.1	278.4	48010.0
2016-06-23	G	Futures	109.87	109.98	109.14	109.46	105557.0
2016-06-23	GF	Futures	279.856	284.798	279.207	284.299	3598.0
2016-06-23	GSCI	Futures	550.3	552.11	549.21	552.11	32.0

> showing 50 of 109 rows — these rows as CSV

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