PREVIEW / futures_daily / 2017-09-07

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-07.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
2017-09-07	ES	Futures	2677.93	2683.09	2670.87	2680.65	1534736.0
2017-09-07	NQ	Futures	6996.82	7031.5	6973.6	7017.98	301526.0
2017-09-07	YM	Futures	23045.0	23101.0	22988.9	23049.2	150006.0
2017-09-07	CL	Futures	50.43	50.63	49.91	50.38	702514.0
2017-09-07	GC	Futures	1703.8	1724.8	1701.5	1718.1	363776.0
2017-09-07	ZN	Futures	125.473557	126.027592	125.473557	125.842914	29746.0
2017-09-07	A6	Futures	0.8218	0.82694	0.81893	0.82478	115919.0
2017-09-07	AD	Futures	0.83136	0.83986	0.83091	0.83731	105914.0
2017-09-07	ALI	Futures	2732.58	2732.58	2732.58	2732.58	0.0
2017-09-07	B	Futures	37.96	38.34	37.79	38.21	306718.0
2017-09-07	B6	Futures	1.3635	1.371	1.3624	1.3677	114968.0
2017-09-07	BFX	Futures	4724.8	4730.8	4724.8	4730.8	7.0
2017-09-07	BR	Futures	0.24415	0.24415	0.24151	0.24151	1.0
2017-09-07	BZ	Futures	37.6	38.01	37.47	37.88	34793.0
2017-09-07	C	Futures	1469.0	1472.0	1439.0	1443.0	5394.0
2017-09-07	CB	Futures	309.894	313.075	309.548	310.744	12.0
2017-09-07	CC	Futures	1418.0	1432.0	1408.0	1415.0	15482.0
2017-09-07	CNH	Futures	6.7537	6.7537	6.7059	6.7059	100.0
2017-09-07	CSC	Futures	3.416	3.425	3.394	3.398	15.0
2017-09-07	CT	Futures	87.19	87.65	86.95	87.57	19.0
2017-09-07	DC	Futures	28.26	28.26	27.93	28.01	169.0
2017-09-07	DX	Futures	86.075	86.121	85.323	85.572	58701.0
2017-09-07	E1	Futures	1.28549	1.29434	1.27898	1.29004	43180.0
2017-09-07	E6	Futures	1.36634	1.38232	1.36565	1.37608	382340.0
2017-09-07	E7	Futures	1.3593	1.3751	1.3585	1.3689	12141.0
2017-09-07	EBM	Futures	174.51	175.05	172.62	172.89	17018.0
2017-09-07	ED	Futures	95.6056	95.6128	95.6032	95.608	205005.0
2017-09-07	ER	Futures	98.342	98.342	98.337	98.342	60956.0
2017-09-07	EW	Futures	1822.4	1829.0	1813.4	1819.7	22782.0
2017-09-07	FBON	Futures	124.96	125.91	124.93	125.81	1159.0
2017-09-07	FBTP	Futures	109.5	110.77	109.33	110.66	145283.0
2017-09-07	FBTS	Futures	103.136	103.338	103.109	103.274	66304.0
2017-09-07	FCE	Futures	4576.2	4607.1	4565.1	4575.8	98802.0
2017-09-07	FDAX	Futures	12913.5	13019.3	12908.2	12956.1	111053.0
2017-09-07	FDXM	Futures	12829.3	12939.1	12827.2	12876.4	39427.0
2017-09-07	FESX	Futures	2810.4	2831.6	2806.3	2815.3	1421623.0
2017-09-07	FGBL	Futures	150.07	150.94	149.99	150.88	877978.0
2017-09-07	FGBM	Futures	129.93	130.25	129.87	130.21	514017.0
2017-09-07	FGBS	Futures	112.462	112.547	112.442	112.537	273321.0
2017-09-07	FGBX	Futures	169.97	171.6	169.71	171.42	61013.0
2017-09-07	FMWO	Futures	6536.5	6576.9	6536.5	6563.8	3585.0
2017-09-07	FOAT	Futures	136.88	137.72	136.72	137.64	232338.0
2017-09-07	FTDX	Futures	2333.8	2344.3	2328.3	2338.3	433.0
2017-09-07	FTI	Futures	479.22	481.53	477.64	480.38	32065.0
2017-09-07	FTUK	Futures	6354.1	6406.8	6349.8	6391.3	120099.0
2017-09-07	FVSA	Futures	503.82	508.54	489.65	491.22	27793.0
2017-09-07	FXXP	Futures	319.3	320.4	318.0	319.5	40138.0
2017-09-07	G	Futures	116.66	117.3	116.47	117.27	190649.0
2017-09-07	GF	Futures	315.716	321.197	315.497	319.115	3080.0
2017-09-07	GSCI	Futures	469.58	470.12	469.34	469.7	60.0

> showing 50 of 110 rows — these rows as CSV

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