PREVIEW / futures_daily / 2016-12-09

all futures daily files

  file:    by_date/futures_daily/2016/2016-12-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
2016-12-09	ES	Futures	2430.08	2445.76	2428.18	2444.41	1090581.0
2016-12-09	NQ	Futures	5729.22	5771.94	5718.91	5767.52	133170.0
2016-12-09	YM	Futures	20596.7	20773.1	20592.5	20758.4	71100.0
2016-12-09	CL	Futures	54.94	55.74	54.88	55.57	652040.0
2016-12-09	GC	Futures	1505.7	1507.4	1486.6	1492.1	162823.0
2016-12-09	ZN	Futures	121.629697	121.828363	121.155954	121.308774	1466260.0
2016-12-09	A6	Futures	0.75989	0.76479	0.75846	0.7604	76241.0
2016-12-09	AD	Futures	0.77617	0.77893	0.77535	0.77811	44315.0
2016-12-09	ALI	Futures	2381.32	2381.32	2381.32	2381.32	0.0
2016-12-09	B	Futures	40.21	40.57	40.06	40.48	264797.0
2016-12-09	B6	Futures	1.3246	1.3288	1.3218	1.3234	92043.0
2016-12-09	BR	Futures	0.20736	0.20743	0.20665	0.20665	2.0
2016-12-09	BZ	Futures	39.9	40.26	39.76	40.18	30445.0
2016-12-09	C	Futures	1888.0	1888.0	1811.0	1811.0	1874.0
2016-12-09	CB	Futures	256.077	256.077	255.65	255.65	7.0
2016-12-09	CC	Futures	1707.0	1708.0	1645.0	1652.0	30104.0
2016-12-09	CNH	Futures	7.4334	7.4604	7.4334	7.4423	154.0
2016-12-09	CSC	Futures	4.022	4.022	4.011	4.011	1.0
2016-12-09	CT	Futures	81.85	82.49	80.76	81.33	15796.0
2016-12-09	DC	Futures	32.19	32.57	32.19	32.56	207.0
2016-12-09	DX	Futures	94.142	94.719	94.04	94.58	30121.0
2016-12-09	E1	Futures	1.22637	1.22749	1.22027	1.22463	23018.0
2016-12-09	E6	Futures	1.23076	1.23267	1.22108	1.2238	220016.0
2016-12-09	E7	Futures	1.2242	1.2258	1.2146	1.2172	4182.0
2016-12-09	EBM	Futures	187.44	188.86	187.44	188.58	12567.0
2016-12-09	ED	Futures	95.5886	95.5911	95.5862	95.5862	195726.0
2016-12-09	ER	Futures	98.283	98.288	98.283	98.283	17500.0
2016-12-09	EW	Futures	1804.4	1808.4	1797.6	1800.5	28274.0
2016-12-09	FBON	Futures	121.13	121.32	120.99	121.22	123.0
2016-12-09	FBTP	Futures	105.1	105.41	104.68	105.01	99318.0
2016-12-09	FBTS	Futures	101.322	101.467	101.304	101.421	31331.0
2016-12-09	FCE	Futures	4189.0	4228.3	4181.9	4205.8	87346.0
2016-12-09	FDAX	Futures	11813.4	11876.2	11775.8	11839.8	84268.0
2016-12-09	FDXM	Futures	11790.0	11851.1	11750.9	11814.2	17225.0
2016-12-09	FESX	Futures	2555.1	2574.4	2545.5	2560.7	1490950.0
2016-12-09	FEU3	Futures	98.952	98.952	98.952	98.952	3.0
2016-12-09	FGBL	Futures	145.29	146.36	145.2	145.97	830964.0
2016-12-09	FGBM	Futures	128.22	128.63	128.17	128.51	563277.0
2016-12-09	FGBS	Futures	112.067	112.137	112.067	112.122	401686.0
2016-12-09	FGBX	Futures	164.59	166.53	163.39	164.85	70079.0
2016-12-09	FMWO	Futures	5869.5	5881.6	5864.6	5881.6	365.0
2016-12-09	FOAT	Futures	131.99	132.42	131.68	132.21	135992.0
2016-12-09	FTDX	Futures	1704.3	1721.5	1702.9	1718.5	308.0
2016-12-09	FTI	Futures	425.31	429.64	425.08	428.09	29342.0
2016-12-09	FTUK	Futures	5849.5	5889.6	5847.8	5869.3	181812.0
2016-12-09	FVSA	Futures	1112.24	1131.1	1099.68	1115.39	19395.0
2016-12-09	FXXP	Futures	291.0	294.2	290.6	293.4	200565.0
2016-12-09	G	Futures	110.46	110.71	109.73	110.12	183148.0
2016-12-09	GF	Futures	280.69	281.471	278.571	280.969	3922.0
2016-12-09	GSCI	Futures	529.46	529.46	528.99	529.26	3045.0

> showing 50 of 109 rows — these rows as CSV

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