PREVIEW / futures_daily / 2016-10-19

all futures daily files

  file:    by_date/futures_daily/2016/2016-10-19.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-19	ES	Futures	2305.42	2317.32	2300.01	2312.45	948475.0
2016-10-19	NQ	Futures	5685.02	5704.47	5670.0	5692.68	148339.0
2016-10-19	YM	Futures	18962.8	19078.3	18933.4	19032.1	108311.0
2016-10-19	CL	Futures	55.75	56.98	55.66	56.55	631938.0
2016-10-19	GC	Futures	1621.6	1635.1	1618.0	1629.3	143609.0
2016-10-19	ZN	Futures	126.815681	126.906882	126.587677	126.724479	970174.0
2016-10-19	A6	Futures	0.78173	0.78754	0.7803	0.78612	91885.0
2016-10-19	AD	Futures	0.78175	0.7879	0.7797	0.78047	102210.0
2016-10-19	ALI	Futures	2187.53	2187.53	2183.69	2183.69	5.0
2016-10-19	B	Futures	40.34	41.13	40.31	40.76	292949.0
2016-10-19	B6	Futures	1.2962	1.2998	1.2912	1.2931	95399.0
2016-10-19	BFX	Futures	4250.3	4276.6	4250.3	4271.8	20.0
2016-10-19	BR	Futures	0.21263	0.2139	0.21263	0.21363	15.0
2016-10-19	BZ	Futures	40.11	40.89	40.09	40.53	31624.0
2016-10-19	C	Futures	2369.0	2389.0	2365.0	2387.0	7981.0
2016-10-19	CB	Futures	226.289	227.219	225.669	226.351	25.0
2016-10-19	CC	Futures	1994.0	2017.0	1988.0	2015.0	15977.0
2016-10-19	CNH	Futures	7.2736	7.2736	7.2632	7.2632	185.0
2016-10-19	CSC	Futures	3.776	3.783	3.732	3.737	45.0
2016-10-19	CT	Futures	79.73	79.84	78.67	79.65	13810.0
2016-10-19	DC	Futures	29.7	29.76	29.09	29.23	170.0
2016-10-19	DX	Futures	91.127	91.187	90.89	91.155	17943.0
2016-10-19	E1	Futures	1.26213	1.26549	1.26151	1.263	15494.0
2016-10-19	E6	Futures	1.27573	1.27881	1.27295	1.2744	118489.0
2016-10-19	E7	Futures	1.2687	1.2718	1.2659	1.2675	2446.0
2016-10-19	EBM	Futures	192.11	192.41	190.64	191.53	18745.0
2016-10-19	ED	Futures	95.6635	95.6635	95.6442	95.6538	235414.0
2016-10-19	ER	Futures	98.279	98.283	98.279	98.283	17522.0
2016-10-19	EW	Futures	1620.0	1633.1	1616.4	1629.0	16970.0
2016-10-19	FBON	Futures	124.32	124.57	124.23	124.28	854.0
2016-10-19	FBTP	Futures	108.45	108.65	108.29	108.44	89431.0
2016-10-19	FBTS	Futures	101.23	101.248	101.212	101.221	12513.0
2016-10-19	FCE	Futures	4015.7	4030.8	4001.0	4023.2	176514.0
2016-10-19	FDAX	Futures	11217.9	11273.9	11181.4	11251.7	65602.0
2016-10-19	FDXM	Futures	11194.2	11249.0	11157.3	11227.4	18386.0
2016-10-19	FESX	Futures	2434.2	2447.0	2425.4	2442.2	674768.0
2016-10-19	FGBL	Futures	149.5	149.78	149.47	149.58	599568.0
2016-10-19	FGBM	Futures	128.85	128.94	128.82	128.88	355346.0
2016-10-19	FGBS	Futures	111.947	111.957	111.937	111.942	167903.0
2016-10-19	FGBX	Futures	181.02	181.96	180.84	181.31	42861.0
2016-10-19	FMWO	Futures	5685.6	5706.2	5685.6	5695.3	412.0
2016-10-19	FOAT	Futures	137.27	137.5	137.18	137.33	87717.0
2016-10-19	FTDX	Futures	1756.3	1756.3	1740.6	1748.9	167.0
2016-10-19	FTI	Futures	415.23	417.11	414.17	416.33	32194.0
2016-10-19	FTUK	Futures	5885.0	5906.9	5857.1	5894.7	82251.0
2016-10-19	FVSA	Futures	1437.7	1443.89	1388.23	1400.6	36965.0
2016-10-19	FXXP	Futures	281.9	283.3	280.8	282.8	21057.0
2016-10-19	G	Futures	113.07	113.37	112.92	113.11	222316.0
2016-10-19	GF	Futures	252.762	253.782	246.32	246.588	4131.0
2016-10-19	GSCI	Futures	522.93	526.6	522.93	525.49	45.0

> showing 50 of 109 rows — these rows as CSV

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