PREVIEW / futures_daily / 2016-07-22

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-22.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-07-22	ES	Futures	2331.05	2342.12	2327.81	2340.23	1133059.0
2016-07-22	NQ	Futures	5467.56	5498.21	5455.78	5489.67	152974.0
2016-07-22	YM	Futures	19260.9	19318.4	19236.9	19300.6	94200.0
2016-07-22	CL	Futures	50.55	50.97	49.58	50.09	428407.0
2016-07-22	GC	Futures	1712.9	1716.2	1697.4	1702.6	232263.0
2016-07-22	ZN	Futures	127.773296	127.984567	127.396028	127.607298	993882.0
2016-07-22	A6	Futures	0.76103	0.76236	0.75574	0.75819	68614.0
2016-07-22	AD	Futures	0.78206	0.7839	0.77618	0.77848	75712.0
2016-07-22	ALI	Futures	2100.6	2103.46	2100.6	2103.46	3.0
2016-07-22	B	Futures	36.89	37.12	36.06	36.48	243489.0
2016-07-22	B6	Futures	1.3942	1.4021	1.3797	1.381	109541.0
2016-07-22	BR	Futures	0.1997	0.20193	0.19934	0.20057	111.0
2016-07-22	BZ	Futures	36.65	36.98	35.94	36.34	25423.0
2016-07-22	C	Futures	2496.0	2583.0	2496.0	2538.0	19437.0
2016-07-22	CB	Futures	276.934	280.157	276.934	277.842	10.0
2016-07-22	CC	Futures	2108.0	2161.0	2089.0	2116.0	32440.0
2016-07-22	CNH	Futures	7.2427	7.2491	7.2427	7.2491	4.0
2016-07-22	CSC	Futures	3.678	3.743	3.678	3.741	52.0
2016-07-22	CT	Futures	82.41	82.41	81.24	82.15	24.0
2016-07-22	DC	Futures	29.45	30.2	29.43	30.0	238.0
2016-07-22	DX	Futures	90.118	90.76	90.085	90.695	19034.0
2016-07-22	E1	Futures	1.27354	1.27567	1.26903	1.27041	12228.0
2016-07-22	E6	Futures	1.28631	1.28829	1.27822	1.27903	124231.0
2016-07-22	E7	Futures	1.2796	1.2813	1.2714	1.2723	2510.0
2016-07-22	EBM	Futures	202.08	210.5	199.68	209.3	30647.0
2016-07-22	ED	Futures	95.6846	95.6894	95.675	95.6846	209369.0
2016-07-22	ER	Futures	98.308	98.313	98.308	98.308	21391.0
2016-07-22	EW	Futures	1628.9	1644.3	1628.9	1642.6	11231.0
2016-07-22	FBON	Futures	123.1	123.19	122.72	122.98	221.0
2016-07-22	FBTP	Futures	109.52	109.59	109.05	109.37	60652.0
2016-07-22	FBTS	Futures	101.284	101.293	101.257	101.275	10442.0
2016-07-22	FCE	Futures	3805.7	3839.8	3790.4	3823.2	64347.0
2016-07-22	FDAX	Futures	10755.2	10826.5	10704.7	10786.6	71486.0
2016-07-22	FDIV	Futures	130.95	130.99	130.9	130.9	6.0
2016-07-22	FDXM	Futures	10480.4	10553.0	10434.7	10514.1	19970.0
2016-07-22	FESX	Futures	2309.5	2332.2	2301.6	2322.0	841888.0
2016-07-22	FGBL	Futures	149.89	149.98	149.38	149.7	480864.0
2016-07-22	FGBM	Futures	128.81	128.81	128.63	128.7	380828.0
2016-07-22	FGBS	Futures	111.882	111.887	111.842	111.857	174198.0
2016-07-22	FGBX	Futures	186.25	187.63	184.79	186.08	27320.0
2016-07-22	FMWO	Futures	5682.0	5691.7	5682.0	5686.9	146.0
2016-07-22	FOAT	Futures	137.89	137.92	137.37	137.66	61350.0
2016-07-22	FTDX	Futures	1596.6	1624.0	1595.1	1610.1	46.0
2016-07-22	FTI	Futures	402.54	405.51	400.97	404.66	21295.0
2016-07-22	FTUK	Futures	5539.4	5576.9	5513.1	5568.1	86526.0
2016-07-22	FVSA	Futures	2259.63	2259.63	2201.07	2210.83	10644.0
2016-07-22	FXXP	Futures	273.8	275.1	272.5	274.1	23021.0
2016-07-22	G	Futures	114.55	114.91	114.41	114.73	154236.0
2016-07-22	GF	Futures	268.374	275.113	268.374	273.965	4501.0
2016-07-22	GSCI	Futures	498.09	501.53	497.59	501.53	460.0

> showing 50 of 109 rows — these rows as CSV

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