PREVIEW / futures_daily / 2014-09-22

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-22.parquet
  size:    9 KB
  rows:    106

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
2014-09-22	ES	Futures	2091.26	2092.31	2070.89	2074.81	1578996.0
2014-09-22	NQ	Futures	4742.24	4742.53	4677.34	4697.04	295630.0
2014-09-22	YM	Futures	17449.8	17460.0	17316.9	17347.3	147834.0
2014-09-22	CL	Futures	172.72	173.15	170.31	171.17	229232.0
2014-09-22	GC	Futures	1595.5	1601.5	1585.5	1597.5	138051.0
2014-09-22	ZN	Futures	116.240351	116.577152	116.240351	116.474647	1020022.0
2014-09-22	A6	Futures	0.86266	0.86461	0.85518	0.85703	117802.0
2014-09-22	AD	Futures	0.92474	0.92779	0.91804	0.91895	52806.0
2014-09-22	ALI	Futures	2967.47	2967.47	2967.47	2967.47	0.0
2014-09-22	B	Futures	102.9	102.9	100.68	101.3	171138.0
2014-09-22	B6	Futures	1.7114	1.7192	1.711	1.7181	86010.0
2014-09-22	BFX	Futures	3893.1	3893.1	3885.8	3888.0	12.0
2014-09-22	BR	Futures	0.22217	0.22228	0.22106	0.22114	1795.0
2014-09-22	BZ	Futures	103.31	103.31	101.4	102.01	12582.0
2014-09-22	C	Futures	2241.0	2279.0	2231.0	2274.0	12511.0
2014-09-22	CB	Futures	163.982	165.716	161.612	161.862	39.0
2014-09-22	CC	Futures	2418.0	2468.0	2415.0	2457.0	19530.0
2014-09-22	CNH	Futures	7.0865	7.1001	7.0857	7.1001	20.0
2014-09-22	CSC	Futures	5.421	5.421	5.321	5.381	8.0
2014-09-22	CT	Futures	82.0	82.0	79.79	81.82	29.0
2014-09-22	DC	Futures	43.95	44.36	42.68	43.38	298.0
2014-09-22	DX	Futures	80.622	80.664	80.351	80.558	18199.0
2014-09-22	E1	Futures	1.35934	1.36445	1.35819	1.35998	33279.0
2014-09-22	E6	Futures	1.5107	1.51553	1.50952	1.51176	184821.0
2014-09-22	E7	Futures	1.5013	1.5061	1.5001	1.5023	1908.0
2014-09-22	ED	Futures	95.4278	95.4278	95.423	95.423	74227.0
2014-09-22	ER	Futures	98.009	98.014	98.009	98.014	17451.0
2014-09-22	EW	Futures	1473.4	1473.9	1451.0	1454.4	23170.0
2014-09-22	FBTP	Futures	95.15	95.37	95.02	95.07	44570.0
2014-09-22	FBTS	Futures	98.774	98.783	98.73	98.757	8658.0
2014-09-22	FCE	Futures	3538.8	3550.7	3521.3	3532.0	71362.0
2014-09-22	FDAX	Futures	10694.3	10754.0	10651.6	10684.5	83214.0
2014-09-22	FDIV	Futures	140.06	140.16	139.88	139.88	105.0
2014-09-22	FESX	Futures	2352.8	2363.6	2340.4	2349.9	623103.0
2014-09-22	FGBL	Futures	131.06	131.24	130.88	131.05	523128.0
2014-09-22	FGBM	Futures	122.75	122.77	122.62	122.68	299970.0
2014-09-22	FGBS	Futures	110.948	110.948	110.918	110.928	135478.0
2014-09-22	FGBX	Futures	139.62	140.29	139.3	139.75	24858.0
2014-09-22	FMWO	Futures	5746.3	5756.4	5737.5	5737.5	11.0
2014-09-22	FOAT	Futures	120.9	121.08	120.82	120.95	50826.0
2014-09-22	FTDX	Futures	1184.7	1189.4	1181.4	1182.8	126.0
2014-09-22	FTI	Futures	365.71	366.14	363.5	364.58	22428.0
2014-09-22	FTUK	Futures	5272.4	5273.2	5205.9	5217.1	80584.0
2014-09-22	FVSA	Futures	1368.07	1372.13	1339.65	1364.01	10345.0
2014-09-22	FXXP	Futures	262.6	263.3	261.7	262.3	7939.0
2014-09-22	G	Futures	96.11	96.4	96.05	96.27	117774.0
2014-09-22	GF	Futures	354.983	357.278	351.794	356.695	3011.0
2014-09-22	GSCI	Futures	977.3	977.3	968.46	971.24	235.0
2014-09-22	HE	Futures	127.592	129.308	127.221	128.803	10520.0
2014-09-22	HG	Futures	3.9118	3.9143	3.8439	3.8541	57997.0

> showing 50 of 106 rows — these rows as CSV

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