PREVIEW / futures_daily / 2017-01-05

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-05.parquet
  size:    9 KB
  rows:    107

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-01-05	ES	Futures	2454.94	2456.57	2443.56	2454.67	1324035.0
2017-01-05	NQ	Futures	5816.14	5850.91	5799.34	5848.25	169565.0
2017-01-05	YM	Futures	20923.8	20931.1	20784.7	20877.4	108860.0
2017-01-05	CL	Futures	57.14	57.92	56.49	57.53	517362.0
2017-01-05	GC	Futures	1495.6	1522.9	1494.3	1517.0	272124.0
2017-01-05	ZN	Futures	121.476876	122.286824	121.385184	122.088158	1882843.0
2017-01-05	A6	Futures	0.74391	0.75231	0.74371	0.74985	107981.0
2017-01-05	AD	Futures	0.76826	0.77495	0.7678	0.77204	72667.0
2017-01-05	ALI	Futures	2334.55	2334.55	2332.29	2332.29	25.0
2017-01-05	B	Futures	41.98	42.73	41.73	42.38	269612.0
2017-01-05	B6	Futures	1.2946	1.3059	1.2888	1.3035	142945.0
2017-01-05	BR	Futures	0.21832	0.21917	0.21832	0.21906	636.0
2017-01-05	BZ	Futures	41.81	42.4	41.42	42.07	32833.0
2017-01-05	C	Futures	1863.0	1879.0	1851.0	1876.0	8887.0
2017-01-05	CC	Futures	1703.0	1726.0	1682.0	1722.0	17562.0
2017-01-05	CNH	Futures	7.4082	7.4082	7.2984	7.3073	63.0
2017-01-05	CSC	Futures	3.967	3.967	3.935	3.935	63.0
2017-01-05	CT	Futures	85.2	86.58	84.56	84.75	27776.0
2017-01-05	DC	Futures	32.59	32.59	32.25	32.38	427.0
2017-01-05	DX	Futures	95.031	95.436	94.315	94.531	60274.0
2017-01-05	E1	Futures	1.21781	1.23318	1.21719	1.2307	32125.0
2017-01-05	E6	Futures	1.21468	1.22969	1.2141	1.22692	281509.0
2017-01-05	E7	Futures	1.2085	1.2234	1.208	1.2206	5755.0
2017-01-05	EBM	Futures	193.13	193.99	192.85	193.7	21486.0
2017-01-05	ED	Futures	95.581	95.5955	95.5762	95.581	405295.0
2017-01-05	ER	Futures	98.293	98.298	98.288	98.298	38747.0
2017-01-05	EW	Futures	1800.3	1803.3	1783.1	1790.6	14242.0
2017-01-05	FBON	Futures	122.06	122.2	121.35	121.8	649.0
2017-01-05	FBTP	Futures	106.74	106.82	105.67	106.16	126093.0
2017-01-05	FBTS	Futures	101.918	101.927	101.764	101.819	35069.0
2017-01-05	FCE	Futures	4300.8	4314.0	4286.2	4309.6	69383.0
2017-01-05	FDAX	Futures	12190.3	12247.3	12170.8	12214.1	68360.0
2017-01-05	FDXM	Futures	12143.3	12198.0	12122.3	12164.8	18321.0
2017-01-05	FESX	Futures	2638.3	2651.9	2631.9	2643.1	786296.0
2017-01-05	FGBL	Futures	147.46	147.67	146.83	147.49	1019402.0
2017-01-05	FGBM	Futures	129.13	129.19	128.86	128.99	665037.0
2017-01-05	FGBS	Futures	112.217	112.227	112.107	112.127	466092.0
2017-01-05	FGBX	Futures	169.04	170.37	167.22	169.85	64748.0
2017-01-05	FMWO	Futures	5934.7	5955.2	5926.2	5947.9	581.0
2017-01-05	FOAT	Futures	132.93	132.97	132.14	132.79	272832.0
2017-01-05	FTDX	Futures	1800.9	1806.3	1799.9	1803.3	60.0
2017-01-05	FTI	Futures	443.1	444.29	441.83	442.92	23548.0
2017-01-05	FTUK	Futures	6048.7	6061.0	6026.6	6040.6	83721.0
2017-01-05	FVSA	Futures	1011.25	1011.25	961.92	972.88	13102.0
2017-01-05	FXXP	Futures	301.1	302.4	300.3	302.0	18747.0
2017-01-05	G	Futures	111.6	112.07	111.06	111.71	209522.0
2017-01-05	GF	Futures	287.55	289.167	285.765	286.1	1942.0
2017-01-05	GSCI	Futures	527.2	529.99	523.3	527.2	570.0
2017-01-05	HE	Futures	87.783	88.695	86.836	87.715	16295.0
2017-01-05	HG	Futures	3.175	3.2141	3.1421	3.1508	67495.0

> showing 50 of 107 rows — these rows as CSV

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