PREVIEW / futures_daily / 2016-03-09

all futures daily files

  file:    by_date/futures_daily/2016/2016-03-09.parquet
  size:    10 KB
  rows:    112

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-03-09	ES	Futures	2116.78	2129.86	2112.77	2124.52	1744984.0
2016-03-09	NQ	Futures	5006.93	5039.75	4990.22	5034.48	238221.0
2016-03-09	YM	Futures	17575.1	17672.3	17529.5	17599.9	140140.0
2016-03-09	CL	Futures	45.68	48.39	45.53	48.11	740632.0
2016-03-09	GC	Futures	1621.8	1626.3	1597.9	1615.7	223144.0
2016-03-09	ZN	Futures	125.057291	125.117639	124.559415	124.619764	1064437.0
2016-03-09	A6	Futures	0.74388	0.7542	0.74248	0.7528	155070.0
2016-03-09	AD	Futures	0.76214	0.77298	0.7604	0.77175	118589.0
2016-03-09	ALI	Futures	2142.64	2142.64	2142.64	2142.64	0.0
2016-03-09	B	Futures	33.02	34.3	32.8	34.2	333486.0
2016-03-09	B6	Futures	1.4952	1.4984	1.4918	1.4969	120569.0
2016-03-09	BFX	Futures	3974.5	3974.5	3963.5	3963.5	1.0
2016-03-09	BR	Futures	0.17156	0.17313	0.17104	0.17195	34.0
2016-03-09	BZ	Futures	32.58	34.0	32.5	33.86	29231.0
2016-03-09	C	Futures	2313.0	2349.0	2305.0	2341.0	5720.0
2016-03-09	CB	Futures	246.36	248.159	245.72	246.818	27.0
2016-03-09	CC	Futures	2182.0	2224.0	2170.0	2213.0	19836.0
2016-03-09	CNH	Futures	7.1469	7.1535	7.1407	7.1407	36.0
2016-03-09	CSC	Futures	3.572	3.572	3.549	3.549	98.0
2016-03-09	CT	Futures	65.28	65.35	64.32	64.99	15244.0
2016-03-09	DC	Futures	28.07	28.13	27.85	27.85	126.0
2016-03-09	DX	Futures	90.855	91.154	90.552	90.761	27937.0
2016-03-09	E1	Futures	1.26741	1.27056	1.25718	1.26589	31865.0
2016-03-09	E6	Futures	1.28718	1.29051	1.27999	1.28671	312900.0
2016-03-09	E7	Futures	1.2801	1.2831	1.2729	1.2795	4807.0
2016-03-09	EBM	Futures	197.52	199.45	196.56	199.13	18310.0
2016-03-09	ED	Futures	95.6361	95.641	95.6361	95.6385	132856.0
2016-03-09	ER	Futures	98.298	98.298	98.288	98.288	105516.0
2016-03-09	EW	Futures	1460.2	1467.0	1452.8	1463.5	27560.0
2016-03-09	FBON	Futures	117.03	117.28	117.0	117.16	202.0
2016-03-09	FBTP	Futures	106.17	106.5	106.09	106.32	87344.0
2016-03-09	FBTS	Futures	101.069	101.096	101.042	101.042	23787.0
2016-03-09	FCE	Futures	3677.2	3713.4	3661.4	3685.1	95540.0
2016-03-09	FDAX	Futures	10532.5	10670.2	10494.5	10547.1	102609.0
2016-03-09	FDIV	Futures	128.91	128.91	127.75	127.75	12.0
2016-03-09	FDXM	Futures	10072.7	10201.2	10033.3	10085.1	20634.0
2016-03-09	FESX	Futures	2287.9	2317.5	2281.0	2294.7	1603091.0
2016-03-09	FEU3	Futures	98.956	98.956	98.952	98.952	1185.0
2016-03-09	FGBL	Futures	145.57	145.63	144.84	145.08	638887.0
2016-03-09	FGBM	Futures	127.69	127.69	127.44	127.5	483133.0
2016-03-09	FGBS	Futures	111.812	111.817	111.753	111.763	284587.0
2016-03-09	FGBX	Futures	168.94	169.47	167.78	168.44	32841.0
2016-03-09	FMWO	Futures	5408.7	5423.6	5393.7	5417.4	622.0
2016-03-09	FOAT	Futures	132.53	132.56	132.08	132.15	87653.0
2016-03-09	FTDX	Futures	1536.2	1547.2	1531.8	1535.2	165.0
2016-03-09	FTI	Futures	384.09	388.03	383.33	385.68	29983.0
2016-03-09	FTUK	Futures	4984.5	5028.1	4979.2	5010.6	112079.0
2016-03-09	FVSA	Futures	3121.5	3121.5	2987.05	3057.2	7143.0
2016-03-09	FXXP	Futures	266.8	269.0	265.7	266.9	36201.0
2016-03-09	G	Futures	108.32	108.48	107.92	108.1	203071.0

> showing 50 of 112 rows — these rows as CSV

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