PREVIEW / futures_daily / 2016-09-21

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-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
2016-09-21	ES	Futures	2303.8	2333.54	2299.74	2332.19	1826950.0
2016-09-21	NQ	Futures	5657.03	5721.26	5643.48	5715.96	291231.0
2016-09-21	YM	Futures	18939.7	19137.1	18912.4	19129.8	189572.0
2016-09-21	CL	Futures	49.07	50.34	49.07	50.0	585987.0
2016-09-21	GC	Futures	1691.0	1720.9	1681.9	1708.2	268971.0
2016-09-21	ZN	Futures	126.937283	127.180487	126.526876	127.043684	1115107.0
2016-09-21	A6	Futures	0.76918	0.77693	0.76714	0.77407	116303.0
2016-09-21	AD	Futures	0.77694	0.78236	0.77402	0.77919	71072.0
2016-09-21	ALI	Futures	2087.58	2087.58	2087.58	2087.58	0.0
2016-09-21	B	Futures	36.52	37.06	36.47	36.82	249080.0
2016-09-21	B6	Futures	1.3687	1.3757	1.3649	1.3707	104903.0
2016-09-21	BFX	Futures	4228.9	4228.9	4227.7	4227.7	1.0
2016-09-21	BR	Futures	0.20797	0.209	0.20725	0.209	40.0
2016-09-21	BZ	Futures	36.21	36.91	36.21	36.66	25248.0
2016-09-21	C	Futures	2453.0	2471.0	2448.0	2462.0	6710.0
2016-09-21	CB	Futures	246.128	247.678	245.508	247.678	27.0
2016-09-21	CC	Futures	2110.0	2136.0	2109.0	2128.0	11529.0
2016-09-21	CNH	Futures	7.2337	7.2337	7.2157	7.2157	3.0
2016-09-21	CSC	Futures	3.903	3.909	3.875	3.875	9.0
2016-09-21	CT	Futures	79.85	81.35	79.7	81.35	10.0
2016-09-21	DC	Futures	30.97	31.01	30.51	30.53	52.0
2016-09-21	DX	Futures	89.298	89.633	88.716	89.037	29366.0
2016-09-21	E1	Futures	1.27845	1.28792	1.27559	1.28381	36491.0
2016-09-21	E6	Futures	1.29759	1.30274	1.29417	1.30037	183371.0
2016-09-21	E7	Futures	1.2906	1.2958	1.2873	1.2934	3004.0
2016-09-21	EBM	Futures	189.76	190.35	187.7	190.06	18371.0
2016-09-21	ED	Futures	95.6297	95.6442	95.5911	95.6297	524616.0
2016-09-21	ER	Futures	98.288	98.288	98.283	98.288	44569.0
2016-09-21	EW	Futures	1618.8	1641.2	1614.5	1640.1	21407.0
2016-09-21	FBON	Futures	124.42	124.86	124.35	124.37	606.0
2016-09-21	FBTP	Futures	109.29	109.6	109.1	109.13	71044.0
2016-09-21	FBTS	Futures	101.23	101.266	101.23	101.248	19769.0
2016-09-21	FCE	Futures	3909.8	3949.3	3898.2	3911.1	84923.0
2016-09-21	FDAX	Futures	11028.7	11124.9	10983.8	11027.7	103188.0
2016-09-21	FDXM	Futures	11003.3	11100.3	10960.1	11003.9	35424.0
2016-09-21	FESX	Futures	2374.9	2399.7	2369.3	2378.9	1031491.0
2016-09-21	FGBL	Futures	149.7	150.08	149.56	149.59	583275.0
2016-09-21	FGBM	Futures	128.87	128.93	128.8	128.82	425935.0
2016-09-21	FGBS	Futures	111.922	111.932	111.902	111.907	190077.0
2016-09-21	FGBX	Futures	183.2	185.16	182.47	183.12	39126.0
2016-09-21	FMWO	Futures	5715.9	5717.1	5708.6	5711.0	248.0
2016-09-21	FOAT	Futures	137.58	137.88	137.4	137.44	92239.0
2016-09-21	FTDX	Futures	1748.9	1749.9	1740.6	1741.6	530.0
2016-09-21	FTI	Futures	408.89	413.16	408.89	410.22	23289.0
2016-09-21	FTUK	Futures	5721.6	5773.9	5721.2	5743.1	85834.0
2016-09-21	FVSA	Futures	1594.42	1608.72	1533.65	1583.7	22176.0
2016-09-21	FXXP	Futures	282.5	283.4	280.6	281.5	23445.0
2016-09-21	G	Futures	115.62	115.91	115.41	115.66	159526.0
2016-09-21	GF	Futures	271.331	275.715	270.712	272.775	4154.0
2016-09-21	GSCI	Futures	502.14	504.91	501.86	504.42	216.0

> showing 50 of 109 rows — these rows as CSV

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