PREVIEW / futures_daily / 2017-01-13

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-13.parquet
  size:    9 KB
  rows:    108

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-13	ES	Futures	2454.94	2464.7	2453.05	2463.62	1192660.0
2017-01-13	NQ	Futures	5934.59	5967.59	5934.59	5965.23	136613.0
2017-01-13	YM	Futures	20862.7	20937.4	20825.8	20889.0	99768.0
2017-01-13	CL	Futures	56.77	56.9	55.94	56.04	477986.0
2017-01-13	GC	Futures	1534.4	1543.4	1525.0	1536.2	288619.0
2017-01-13	ZN	Futures	122.134004	122.561901	121.614415	122.042312	1584205.0
2017-01-13	A6	Futures	0.76532	0.76798	0.76184	0.76726	96814.0
2017-01-13	AD	Futures	0.7774	0.77985	0.77612	0.77893	58044.0
2017-01-13	ALI	Futures	2439.84	2444.66	2432.46	2444.66	38.0
2017-01-13	B	Futures	41.72	41.88	41.18	41.31	247086.0
2017-01-13	B6	Futures	1.277	1.2848	1.2729	1.2797	108994.0
2017-01-13	BR	Futures	0.2186	0.21924	0.21839	0.21885	49.0
2017-01-13	BZ	Futures	41.46	41.56	40.9	41.01	25417.0
2017-01-13	C	Futures	1882.0	1882.0	1854.0	1863.0	7283.0
2017-01-13	CB	Futures	272.372	272.372	272.372	272.372	5.0
2017-01-13	CC	Futures	1689.0	1698.0	1667.0	1685.0	13270.0
2017-01-13	CNH	Futures	7.3073	7.3274	7.2972	7.2972	49.0
2017-01-13	CSC	Futures	4.061	4.061	4.031	4.041	60.0
2017-01-13	CT	Futures	83.1	83.57	82.71	83.02	11966.0
2017-01-13	DC	Futures	33.78	33.78	33.32	33.36	187.0
2017-01-13	DX	Futures	94.524	94.673	93.882	94.215	38032.0
2017-01-13	E1	Futures	1.23021	1.23814	1.22822	1.23194	20187.0
2017-01-13	E6	Futures	1.22854	1.2361	1.2268	1.23223	185293.0
2017-01-13	E7	Futures	1.2227	1.2296	1.2205	1.2259	3874.0
2017-01-13	EBM	Futures	193.7	194.27	192.85	193.42	13010.0
2017-01-13	ED	Futures	95.5713	95.5762	95.552	95.5665	247403.0
2017-01-13	ER	Futures	98.308	98.308	98.303	98.308	18041.0
2017-01-13	EW	Futures	1785.3	1802.4	1785.2	1794.8	17503.0
2017-01-13	FBON	Futures	122.54	122.65	122.09	122.39	576.0
2017-01-13	FBTP	Futures	106.51	106.72	106.23	106.5	87632.0
2017-01-13	FBTS	Futures	101.791	101.837	101.782	101.809	29361.0
2017-01-13	FCE	Futures	4306.0	4334.7	4302.1	4333.4	693.0
2017-01-13	FDAX	Futures	12217.7	12282.1	12195.6	12265.2	63758.0
2017-01-13	FDXM	Futures	12169.6	12232.6	12145.4	12215.8	18441.0
2017-01-13	FESX	Futures	2638.3	2655.9	2629.5	2651.1	808072.0
2017-01-13	FGBL	Futures	147.47	147.94	147.13	147.37	745054.0
2017-01-13	FGBM	Futures	128.94	129.08	128.83	128.93	594605.0
2017-01-13	FGBS	Futures	112.107	112.132	112.082	112.107	275901.0
2017-01-13	FGBX	Futures	167.76	169.22	166.33	167.24	51408.0
2017-01-13	FMWO	Futures	5961.2	5980.5	5958.8	5980.5	1106.0
2017-01-13	FOAT	Futures	132.87	133.24	132.5	132.75	89528.0
2017-01-13	FTDX	Futures	1803.8	1808.2	1800.4	1804.3	279.0
2017-01-13	FTI	Futures	441.83	443.79	440.83	443.79	108.0
2017-01-13	FTUK	Futures	6158.9	6168.7	6140.2	6160.6	96945.0
2017-01-13	FVSA	Futures	897.63	904.74	871.58	876.32	13797.0
2017-01-13	FXXP	Futures	300.5	302.5	300.3	302.3	34706.0
2017-01-13	G	Futures	111.68	111.95	111.1	111.28	180509.0
2017-01-13	GF	Futures	291.008	295.112	289.014	294.77	4856.0
2017-01-13	GSCI	Futures	527.96	529.14	527.3	527.56	2821.0
2017-01-13	HE	Futures	89.371	89.507	87.512	88.695	22091.0

> showing 50 of 108 rows — these rows as CSV

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