PREVIEW / futures_daily / 2017-02-06

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-06.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
2017-02-06	ES	Futures	2485.84	2487.2	2475.54	2478.79	1164914.0
2017-02-06	NQ	Futures	6078.38	6085.74	6058.34	6078.97	145402.0
2017-02-06	YM	Futures	21057.5	21088.1	20994.3	21036.5	108426.0
2017-02-06	CL	Futures	57.58	57.93	56.62	56.73	425085.0
2017-02-06	GC	Futures	1561.0	1580.9	1559.5	1574.0	197324.0
2017-02-06	ZN	Futures	121.690825	122.271542	121.675543	122.195132	1276682.0
2017-02-06	A6	Futures	0.7857	0.786	0.78068	0.78355	63690.0
2017-02-06	AD	Futures	0.7845	0.78547	0.77781	0.78051	58443.0
2017-02-06	ALI	Futures	2472.58	2497.93	2472.58	2497.93	8.0
2017-02-06	B	Futures	41.92	42.13	41.04	41.09	252700.0
2017-02-06	B6	Futures	1.3092	1.3118	1.3044	1.3087	64419.0
2017-02-06	BFX	Futures	4376.6	4385.1	4339.0	4339.0	8.0
2017-02-06	BR	Futures	0.22688	0.22877	0.22614	0.22656	1106.0
2017-02-06	BZ	Futures	41.67	41.9	40.83	40.88	26706.0
2017-02-06	C	Futures	1753.0	1767.0	1735.0	1738.0	16948.0
2017-02-06	CB	Futures	267.917	267.917	267.306	267.917	9.0
2017-02-06	CC	Futures	1586.0	1602.0	1564.0	1570.0	22017.0
2017-02-06	CNH	Futures	7.2129	7.2255	7.2041	7.2041	74.0
2017-02-06	CSC	Futures	3.96	3.965	3.914	3.93	37.0
2017-02-06	CT	Futures	87.83	87.88	86.8	86.88	20544.0
2017-02-06	DC	Futures	32.86	33.01	32.33	32.38	346.0
2017-02-06	DX	Futures	92.829	93.318	92.741	92.983	27445.0
2017-02-06	E1	Futures	1.25165	1.25376	1.24644	1.25276	13014.0
2017-02-06	E6	Futures	1.24725	1.24783	1.23818	1.24309	151778.0
2017-02-06	E7	Futures	1.2408	1.2414	1.2317	1.2367	2738.0
2017-02-06	EBM	Futures	193.13	193.99	191.99	192.56	10534.0
2017-02-06	ED	Futures	95.581	95.5906	95.5762	95.5858	164690.0
2017-02-06	ER	Futures	98.298	98.303	98.288	98.293	105641.0
2017-02-06	EW	Futures	1815.4	1816.8	1803.4	1806.9	11725.0
2017-02-06	FBON	Futures	120.02	120.11	119.02	119.14	1112.0
2017-02-06	FBTP	Futures	103.55	103.7	102.54	102.75	153475.0
2017-02-06	FBTS	Futures	101.503	101.512	101.376	101.403	50228.0
2017-02-06	FCE	Futures	4246.6	4264.6	4195.9	4207.4	108717.0
2017-02-06	FDAX	Futures	12294.8	12328.1	12114.3	12164.4	110611.0
2017-02-06	FDXM	Futures	12244.2	12277.9	12065.5	12115.4	31584.0
2017-02-06	FESX	Futures	2615.9	2624.7	2580.7	2591.1	1203832.0
2017-02-06	FGBL	Futures	146.55	147.43	146.5	147.17	935806.0
2017-02-06	FGBM	Futures	128.76	129.19	128.76	129.11	698784.0
2017-02-06	FGBS	Futures	112.162	112.262	112.157	112.232	329547.0
2017-02-06	FGBX	Futures	164.73	167.0	164.3	165.72	55767.0
2017-02-06	FMWO	Futures	6005.8	6016.7	6005.8	6014.3	289.0
2017-02-06	FOAT	Futures	129.97	130.14	129.26	129.46	194939.0
2017-02-06	FTDX	Futures	1813.6	1816.6	1789.1	1794.5	76.0
2017-02-06	FTI	Futures	442.29	443.25	437.31	438.32	34040.0
2017-02-06	FTUK	Futures	6030.0	6056.7	6017.7	6027.5	78345.0
2017-02-06	FVSA	Futures	781.58	810.0	765.0	800.53	18791.0
2017-02-06	FXXP	Futures	301.1	301.7	298.4	299.3	30249.0
2017-02-06	G	Futures	111.24	111.92	111.18	111.76	150370.0
2017-02-06	GF	Futures	281.718	283.941	280.465	281.604	3943.0
2017-02-06	GSCI	Futures	528.02	529.14	523.93	523.93	257.0

> showing 50 of 109 rows — these rows as CSV

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