PREVIEW / futures_daily / 2017-02-21

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-21.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-02-21	ES	Futures	2543.84	2563.9	2543.3	2558.48	1653551.0
2017-02-21	NQ	Futures	6274.32	6309.97	6270.78	6298.19	192758.0
2017-02-21	YM	Futures	21680.0	21840.1	21664.2	21790.6	147852.0
2017-02-21	CL	Futures	57.19	58.39	57.0	57.65	665310.0
2017-02-21	GC	Futures	1579.5	1584.3	1567.2	1582.7	259507.0
2017-02-21	ZN	Futures	121.950619	122.057594	121.660261	121.965901	1534132.0
2017-02-21	A6	Futures	0.78549	0.78734	0.78303	0.78652	74475.0
2017-02-21	AD	Futures	0.78046	0.78128	0.77592	0.77745	58421.0
2017-02-21	ALI	Futures	2553.1	2553.1	2553.1	2553.1	0.0
2017-02-21	B	Futures	41.42	42.26	41.37	41.78	335443.0
2017-02-21	B6	Futures	1.3033	1.3099	1.3013	1.3089	122812.0
2017-02-21	BFX	Futures	4382.0	4395.4	4382.0	4395.4	2.0
2017-02-21	BR	Futures	0.23005	0.23048	0.22856	0.22955	4099.0
2017-02-21	BZ	Futures	41.02	42.04	40.87	41.57	57648.0
2017-02-21	C	Futures	1657.0	1669.0	1641.0	1660.0	3569.0
2017-02-21	CB	Futures	270.663	272.189	268.1	270.358	13.0
2017-02-21	CC	Futures	1525.0	1537.0	1499.0	1524.0	18351.0
2017-02-21	CNH	Futures	7.2484	7.2683	7.2484	7.2578	135.0
2017-02-21	CSC	Futures	3.87	3.87	3.799	3.815	143.0
2017-02-21	CT	Futures	84.41	84.95	84.28	84.46	8061.0
2017-02-21	DC	Futures	32.25	32.27	31.23	31.71	703.0
2017-02-21	DX	Futures	94.114	94.608	94.11	94.37	28827.0
2017-02-21	E1	Futures	1.23801	1.23925	1.2276	1.23021	25271.0
2017-02-21	E6	Futures	1.22761	1.22917	1.2167	1.2193	245054.0
2017-02-21	E7	Futures	1.2214	1.2228	1.2105	1.213	4982.0
2017-02-21	EBM	Futures	194.84	195.7	194.84	194.84	16088.0
2017-02-21	ED	Futures	95.552	95.552	95.5327	95.5351	210269.0
2017-02-21	ER	Futures	98.303	98.308	98.298	98.303	30552.0
2017-02-21	EW	Futures	1845.3	1862.4	1844.1	1861.7	11839.0
2017-02-21	FBON	Futures	120.86	120.89	120.21	120.35	983.0
2017-02-21	FBTP	Futures	104.12	104.23	103.58	103.81	122070.0
2017-02-21	FBTS	Futures	101.629	101.638	101.467	101.494	89526.0
2017-02-21	FCE	Futures	4285.3	4310.8	4265.1	4299.8	75074.0
2017-02-21	FDAX	Futures	12483.2	12663.2	12451.0	12625.2	80963.0
2017-02-21	FDXM	Futures	12438.7	12611.1	12400.9	12574.3	28230.0
2017-02-21	FESX	Futures	2651.9	2675.9	2639.1	2669.5	870287.0
2017-02-21	FGBL	Futures	148.42	148.48	147.98	148.27	692474.0
2017-02-21	FGBM	Futures	129.64	129.74	129.56	129.65	525210.0
2017-02-21	FGBS	Futures	112.397	112.432	112.387	112.412	327692.0
2017-02-21	FGBX	Futures	167.74	167.74	166.12	167.04	54324.0
2017-02-21	FMWO	Futures	6144.5	6169.9	6144.5	6157.8	105.0
2017-02-21	FOAT	Futures	130.59	130.59	129.95	130.19	181290.0
2017-02-21	FTDX	Futures	1868.5	1885.7	1862.7	1883.7	116.0
2017-02-21	FTI	Futures	450.3	454.11	449.16	452.89	24011.0
2017-02-21	FTUK	Futures	6152.5	6157.6	6128.8	6141.5	76261.0
2017-02-21	FVSA	Futures	726.12	732.4	696.82	703.1	14846.0
2017-02-21	FXXP	Futures	307.3	309.6	306.2	309.0	36569.0
2017-02-21	G	Futures	112.88	112.89	112.51	112.72	355581.0
2017-02-21	GF	Futures	284.055	286.392	283.371	283.941	4142.0
2017-02-21	GSCI	Futures	523.53	523.53	520.69	520.69	71.0

> showing 50 of 109 rows — these rows as CSV

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