PREVIEW / futures_daily / 2016-09-14

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-14.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-14	ES	Futures	2298.39	2308.67	2284.33	2285.68	2546136.0
2016-09-14	NQ	Futures	5572.77	5619.02	5563.04	5572.77	358383.0
2016-09-14	YM	Futures	18926.1	18990.1	18802.1	18816.8	206688.0
2016-09-14	CL	Futures	50.28	50.58	48.52	48.68	350533.0
2016-09-14	GC	Futures	1696.9	1706.1	1689.2	1701.4	139432.0
2016-09-14	ZN	Futures	126.496475	126.937283	126.405274	126.891682	1056684.0
2016-09-14	A6	Futures	0.75959	0.76295	0.75836	0.7605	54574.0
2016-09-14	AD	Futures	0.77857	0.78062	0.77591	0.77637	52956.0
2016-09-14	ALI	Futures	2068.22	2071.36	2068.22	2071.36	5.0
2016-09-14	B	Futures	37.21	37.33	35.93	36.05	332961.0
2016-09-14	B6	Futures	1.3907	1.3962	1.3856	1.3957	87703.0
2016-09-14	BFX	Futures	4159.8	4161.6	4151.5	4151.5	11.0
2016-09-14	BR	Futures	0.20153	0.20153	0.2004	0.20068	59.0
2016-09-14	BZ	Futures	36.97	37.16	35.79	35.9	28376.0
2016-09-14	C	Futures	2379.0	2395.0	2376.0	2385.0	16002.0
2016-09-14	CB	Futures	255.985	256.047	252.018	252.948	7.0
2016-09-14	CC	Futures	2074.0	2089.0	2065.0	2078.0	15597.0
2016-09-14	CNH	Futures	7.2679	7.2679	7.2247	7.2247	58.0
2016-09-14	CSC	Futures	3.87	3.87	3.863	3.87	35.0
2016-09-14	CT	Futures	76.79	77.12	76.79	77.12	1.0
2016-09-14	DC	Futures	30.83	30.85	30.72	30.85	33.0
2016-09-14	DX	Futures	88.856	88.963	88.53	88.653	21068.0
2016-09-14	E1	Futures	1.28107	1.29004	1.27932	1.28643	14963.0
2016-09-14	E6	Futures	1.30541	1.31202	1.30489	1.30918	185974.0
2016-09-14	E7	Futures	1.2981	1.3048	1.2979	1.3021	1142.0
2016-09-14	EBM	Futures	186.52	188.0	185.94	187.41	16183.0
2016-09-14	ED	Futures	95.6345	95.6586	95.6297	95.6538	497795.0
2016-09-14	ER	Futures	98.283	98.293	98.283	98.293	68718.0
2016-09-14	EW	Futures	1616.2	1619.4	1602.2	1605.9	30462.0
2016-09-14	FBON	Futures	123.4	123.8	123.27	123.68	721.0
2016-09-14	FBTP	Futures	108.77	109.2	108.64	109.08	114095.0
2016-09-14	FBTS	Futures	101.158	101.212	101.158	101.203	20493.0
2016-09-14	FCE	Futures	3913.8	3917.8	3862.2	3875.5	120659.0
2016-09-14	FDAX	Futures	11104.3	11123.4	11011.2	11060.1	152412.0
2016-09-14	FDXM	Futures	10990.7	11008.6	10901.0	10949.5	4173.0
2016-09-14	FESX	Futures	2382.9	2386.1	2353.3	2364.5	1445150.0
2016-09-14	FEU3	Futures	98.971	98.971	98.971	98.971	9.0
2016-09-14	FGBL	Futures	148.76	149.47	148.63	149.31	716156.0
2016-09-14	FGBM	Futures	128.52	128.8	128.48	128.73	525334.0
2016-09-14	FGBS	Futures	111.837	111.902	111.827	111.892	290019.0
2016-09-14	FGBX	Futures	180.6	182.55	179.98	182.0	43115.0
2016-09-14	FMWO	Futures	5665.0	5689.3	5665.0	5683.2	1800.0
2016-09-14	FOAT	Futures	136.69	137.34	136.57	137.19	108175.0
2016-09-14	FTDX	Futures	1714.6	1718.1	1711.2	1715.6	1198.0
2016-09-14	FTI	Futures	407.79	407.79	403.39	404.26	25974.0
2016-09-14	FTUK	Futures	5612.3	5639.3	5584.0	5609.8	183955.0
2016-09-14	FVSA	Futures	1708.82	1748.14	1705.24	1715.97	5448.0
2016-09-14	FXXP	Futures	279.3	279.7	277.4	278.3	87018.0
2016-09-14	G	Futures	114.43	114.99	114.36	114.87	213545.0
2016-09-14	GF	Futures	268.236	270.402	265.142	268.443	5779.0

> showing 50 of 110 rows — these rows as CSV

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