PREVIEW / futures_daily / 2012-06-20

all futures daily files

  file:    by_date/futures_daily/2012/2012-06-20.parquet
  size:    9 KB
  rows:    99

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
2012-06-20	ES	Futures	1367.17	1372.74	1355.78	1367.93	2364882.0
2012-06-20	NQ	Futures	2997.96	3016.61	2981.31	3003.98	257546.0
2012-06-20	YM	Futures	12377.5	12426.0	12293.1	12382.3	169232.0
2012-06-20	CL	Futures	153.85	154.5	147.46	148.54	413790.0
2012-06-20	GC	Futures	2164.7	2170.4	2126.2	2160.0	210736.0
2012-06-20	ZN	Futures	116.304467	116.440655	115.786953	116.100185	1298928.0
2012-06-20	A6	Futures	0.90926	0.91195	0.90368	0.90782	172021.0
2012-06-20	AD	Futures	0.98285	0.98496	0.97784	0.98135	103814.0
2012-06-20	B	Futures	86.91	87.2	83.88	84.16	328770.0
2012-06-20	B6	Futures	1.6429	1.6485	1.635	1.6402	109572.0
2012-06-20	BFX	Futures	2566.7	2582.0	2566.7	2582.0	3.0
2012-06-20	BR	Futures	0.23257	0.23353	0.2321	0.23222	176.0
2012-06-20	BZ	Futures	92.1	92.18	89.21	89.48	718.0
2012-06-20	C	Futures	1534.0	1541.0	1504.0	1507.0	1854.0
2012-06-20	CB	Futures	85.04	85.04	85.04	85.04	2.0
2012-06-20	CC	Futures	1679.0	1689.0	1616.0	1634.0	10695.0
2012-06-20	CSC	Futures	3.736	3.736	3.736	3.736	8.0
2012-06-20	CT	Futures	109.34	109.46	101.51	101.75	15115.0
2012-06-20	DC	Futures	27.17	27.39	26.99	27.21	94.0
2012-06-20	DX	Futures	79.251	79.552	79.013	79.332	42484.0
2012-06-20	E1	Futures	1.36682	1.37276	1.36152	1.36449	60835.0
2012-06-20	E6	Futures	1.49763	1.50435	1.49173	1.49527	307192.0
2012-06-20	E7	Futures	1.4888	1.495	1.4826	1.486	3263.0
2012-06-20	ED	Futures	95.1131	95.1417	95.1083	95.1226	337081.0
2012-06-20	ER	Futures	97.587	97.616	97.572	97.577	117450.0
2012-06-20	EW	Futures	945.6	952.2	940.0	946.2	28833.0
2012-06-20	FBTP	Futures	65.06	66.23	65.06	66.0	20363.0
2012-06-20	FBTS	Futures	84.318	84.343	83.963	84.261	5271.0
2012-06-20	FCE	Futures	2296.5	2324.6	2292.8	2313.2	92528.0
2012-06-20	FDAX	Futures	6905.5	7013.6	6901.1	6980.8	135650.0
2012-06-20	FESX	Futures	1472.3	1494.0	1472.3	1487.2	1076245.0
2012-06-20	FEU3	Futures	98.177	98.177	98.157	98.157	844.0
2012-06-20	FGBL	Futures	116.81	116.84	115.78	116.04	996565.0
2012-06-20	FGBM	Futures	115.09	115.14	114.49	114.67	573126.0
2012-06-20	FGBS	Futures	110.198	110.228	109.994	110.069	517931.0
2012-06-20	FGBX	Futures	125.19	125.19	123.29	123.86	6880.0
2012-06-20	FOAT	Futures	98.19	98.26	97.89	98.02	15029.0
2012-06-20	FTDX	Futures	686.8	694.2	686.3	693.3	261.0
2012-06-20	FTI	Futures	255.74	258.63	255.35	257.65	24713.0
2012-06-20	FTUK	Futures	4037.7	4079.9	4018.7	4060.2	105829.0
2012-06-20	FVSA	Futures	8908.52	8938.66	8727.63	8742.71	3731.0
2012-06-20	FXXP	Futures	176.8	178.3	176.6	178.3	6165.0
2012-06-20	G	Futures	98.27	98.84	98.06	98.24	165742.0
2012-06-20	GF	Futures	303.44	305.118	301.22	301.467	4809.0
2012-06-20	GSCI	Futures	924.2	924.99	906.85	911.45	167.0
2012-06-20	HE	Futures	100.161	100.635	99.556	99.74	11803.0
2012-06-20	HG	Futures	4.4207	4.4317	4.3351	4.375	13303.0
2012-06-20	HO	Futures	2.1619	2.1664	2.116	2.1188	18966.0
2012-06-20	HRC	Futures	2470.4	2470.4	2470.4	2470.4	0.0
2012-06-20	J1	Futures	0.0158867	0.0159218	0.0157376	0.0157814	94677.0

> showing 50 of 99 rows — these rows as CSV

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