PREVIEW / futures_daily / 2016-11-23

all futures daily files

  file:    by_date/futures_daily/2016/2016-11-23.parquet
  size:    9 KB
  rows:    110

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-11-23	ES	Futures	2380.86	2383.3	2370.86	2380.32	1101994.0
2016-11-23	NQ	Futures	5748.08	5754.26	5692.68	5715.37	159650.0
2016-11-23	YM	Futures	19950.9	20013.9	19924.6	20007.6	120477.0
2016-11-23	CL	Futures	51.73	52.26	51.15	51.75	556861.0
2016-11-23	GC	Futures	1555.8	1558.5	1515.5	1525.9	367807.0
2016-11-23	ZN	Futures	122.301207	122.49881	121.465193	121.951601	3075104.0
2016-11-23	A6	Futures	0.75469	0.75907	0.75173	0.75326	92949.0
2016-11-23	AD	Futures	0.76249	0.76311	0.75783	0.75937	61469.0
2016-11-23	ALI	Futures	2431.37	2431.37	2431.37	2431.37	0.0
2016-11-23	B	Futures	37.37	37.6	36.89	37.18	275288.0
2016-11-23	B6	Futures	1.3083	1.3132	1.3018	1.3101	107630.0
2016-11-23	BFX	Futures	4138.4	4138.4	4124.1	4124.1	2.0
2016-11-23	BR	Futures	0.20513	0.20513	0.19996	0.20153	716.0
2016-11-23	BZ	Futures	37.14	37.42	36.72	37.0	46018.0
2016-11-23	C	Futures	2195.0	2201.0	2172.0	2197.0	3883.0
2016-11-23	CB	Futures	255.406	255.406	255.406	255.406	103.0
2016-11-23	CC	Futures	1854.0	1867.0	1833.0	1857.0	11209.0
2016-11-23	CNH	Futures	7.4357	7.4757	7.4357	7.4752	55.0
2016-11-23	CSC	Futures	3.859	3.866	3.845	3.857	50.0
2016-11-23	CT	Futures	82.12	82.4	80.66	81.87	411.0
2016-11-23	DC	Futures	31.01	31.04	30.91	30.95	176.0
2016-11-23	DX	Futures	94.101	94.896	93.966	94.709	43009.0
2016-11-23	E1	Futures	1.23322	1.23609	1.22513	1.22637	25933.0
2016-11-23	E6	Futures	1.23284	1.23505	1.22142	1.22392	239846.0
2016-11-23	E7	Futures	1.2264	1.2283	1.2147	1.2173	4277.0
2016-11-23	EBM	Futures	198.29	198.88	197.41	198.59	13144.0
2016-11-23	ED	Futures	95.5935	95.5983	95.5814	95.5814	352065.0
2016-11-23	ER	Futures	98.279	98.279	98.274	98.279	26781.0
2016-11-23	EW	Futures	1730.6	1739.6	1726.1	1739.1	11323.0
2016-11-23	FBON	Futures	120.11	120.11	119.27	119.69	211.0
2016-11-23	FBTP	Futures	103.65	103.66	102.48	102.71	119020.0
2016-11-23	FBTS	Futures	100.763	100.772	100.628	100.655	38916.0
2016-11-23	FCE	Futures	4026.1	4028.3	3975.8	3994.3	90344.0
2016-11-23	FDAX	Futures	11353.1	11355.3	11201.0	11272.8	99375.0
2016-11-23	FDXM	Futures	11326.0	11336.5	11178.4	11248.5	24001.0
2016-11-23	FESX	Futures	2445.4	2446.2	2412.6	2429.4	1107195.0
2016-11-23	FEU3	Futures	98.956	98.956	98.956	98.956	454.0
2016-11-23	FGBL	Futures	147.28	147.66	146.37	146.78	1256115.0
2016-11-23	FGBM	Futures	128.47	128.63	128.13	128.28	846078.0
2016-11-23	FGBS	Futures	112.067	112.102	111.947	112.022	689967.0
2016-11-23	FGBX	Futures	173.93	175.09	171.32	172.87	80961.0
2016-11-23	FMWO	Futures	5736.4	5736.4	5701.3	5715.9	899.0
2016-11-23	FOAT	Futures	132.67	132.97	131.57	131.96	183127.0
2016-11-23	FTDX	Futures	1706.8	1707.3	1680.8	1683.8	142.0
2016-11-23	FTI	Futures	417.61	418.39	414.28	415.88	30766.0
2016-11-23	FTUK	Futures	5778.2	5802.2	5714.4	5747.4	104294.0
2016-11-23	FVSA	Futures	1297.62	1325.9	1288.19	1297.62	30594.0
2016-11-23	FXXP	Futures	281.7	282.0	279.6	281.3	23829.0
2016-11-23	G	Futures	110.77	111.05	109.86	110.04	528454.0
2016-11-23	GF	Futures	276.675	279.129	275.727	278.627	2533.0

> showing 50 of 110 rows — these rows as CSV

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