PREVIEW / futures_daily / 2017-01-09

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-09.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-01-09	ES	Futures	2462.26	2466.6	2453.86	2455.49	1025182.0
2017-01-09	NQ	Futures	5898.34	5927.81	5895.99	5918.97	148112.0
2017-01-09	YM	Futures	20946.9	20983.8	20872.1	20884.8	85834.0
2017-01-09	CL	Futures	57.52	57.61	55.39	55.6	564893.0
2017-01-09	GC	Futures	1506.2	1523.6	1505.3	1521.6	179034.0
2017-01-09	ZN	Futures	121.660261	122.118722	121.50744	122.042312	889369.0
2017-01-09	A6	Futures	0.74586	0.75405	0.74576	0.75252	66640.0
2017-01-09	AD	Futures	0.77173	0.77449	0.76979	0.77265	44429.0
2017-01-09	ALI	Futures	2315.17	2354.25	2315.17	2354.25	30.0
2017-01-09	B	Futures	42.32	42.47	40.78	40.93	266387.0
2017-01-09	B6	Futures	1.2873	1.2889	1.2734	1.2774	131426.0
2017-01-09	BR	Futures	0.21846	0.21967	0.21846	0.21938	27.0
2017-01-09	BZ	Futures	42.05	42.14	40.48	40.63	25860.0
2017-01-09	C	Futures	1888.0	1888.0	1817.0	1847.0	11110.0
2017-01-09	CB	Futures	274.966	279.024	274.966	279.024	13.0
2017-01-09	CC	Futures	1686.0	1687.0	1630.0	1663.0	20116.0
2017-01-09	CNH	Futures	7.3665	7.3909	7.3649	7.3649	100.0
2017-01-09	CSC	Futures	3.981	4.011	3.981	4.008	11.0
2017-01-09	CT	Futures	85.0	85.21	83.64	83.85	17021.0
2017-01-09	DC	Futures	32.79	33.24	32.79	33.09	135.0
2017-01-09	DX	Futures	95.199	95.427	94.827	94.886	31020.0
2017-01-09	E1	Futures	1.22252	1.22636	1.21967	1.22612	18907.0
2017-01-09	E6	Futures	1.21976	1.22576	1.21739	1.22513	150749.0
2017-01-09	E7	Futures	1.2138	1.2193	1.2112	1.2189	2849.0
2017-01-09	EBM	Futures	195.41	195.98	194.56	194.84	18713.0
2017-01-09	ED	Futures	95.5665	95.5713	95.5617	95.5665	99340.0
2017-01-09	ER	Futures	98.298	98.298	98.293	98.298	38500.0
2017-01-09	EW	Futures	1786.8	1790.3	1773.6	1776.1	16346.0
2017-01-09	FBON	Futures	121.41	122.07	121.41	121.76	336.0
2017-01-09	FBTP	Futures	105.94	106.64	105.8	106.33	83117.0
2017-01-09	FBTS	Futures	101.764	101.846	101.764	101.837	32339.0
2017-01-09	FCE	Futures	4327.1	4330.7	4280.1	4297.7	77297.0
2017-01-09	FDAX	Futures	12276.9	12278.4	12159.7	12208.2	65346.0
2017-01-09	FDXM	Futures	12227.4	12235.8	12110.7	12159.1	15469.0
2017-01-09	FESX	Futures	2656.7	2659.1	2629.5	2640.7	664839.0
2017-01-09	FEU3	Futures	98.966	98.966	98.966	98.966	20.0
2017-01-09	FGBL	Futures	146.73	147.3	146.52	146.96	597720.0
2017-01-09	FGBM	Futures	128.85	128.98	128.82	128.91	392217.0
2017-01-09	FGBS	Futures	112.122	112.147	112.122	112.137	144843.0
2017-01-09	FGBX	Futures	167.46	168.78	166.41	167.62	40736.0
2017-01-09	FMWO	Futures	5946.7	5956.4	5943.1	5954.0	229.0
2017-01-09	FOAT	Futures	132.34	132.92	132.05	132.58	80921.0
2017-01-09	FTDX	Futures	1818.0	1819.5	1803.3	1813.1	268.0
2017-01-09	FTI	Futures	443.83	444.33	440.19	441.24	22045.0
2017-01-09	FTUK	Futures	6075.4	6087.7	6055.5	6084.3	87325.0
2017-01-09	FVSA	Futures	926.29	939.99	912.59	915.33	14124.0
2017-01-09	FXXP	Futures	302.3	302.5	299.8	300.5	21016.0
2017-01-09	G	Futures	111.03	111.7	111.02	111.39	127694.0
2017-01-09	GF	Futures	286.49	289.223	283.869	288.387	2431.0
2017-01-09	GSCI	Futures	520.12	520.19	516.15	516.15	2377.0

> showing 50 of 109 rows — these rows as CSV

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