PREVIEW / futures_daily / 2012-07-12

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-12.parquet
  size:    9 KB
  rows:    98

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-07-12	ES	Futures	1353.5	1356.54	1336.54	1346.16	1904895.0
2012-07-12	NQ	Futures	2942.29	2949.46	2888.35	2912.74	235274.0
2012-07-12	YM	Futures	12164.1	12189.3	12054.4	12129.1	125958.0
2012-07-12	CL	Futures	157.2	157.51	153.57	156.98	240725.0
2012-07-12	GC	Futures	2107.2	2109.3	2077.9	2092.5	171190.0
2012-07-12	ZN	Futures	117.17607	117.475683	117.162451	117.366733	732433.0
2012-07-12	A6	Futures	0.91618	0.91708	0.90278	0.90593	169104.0
2012-07-12	AD	Futures	0.98195	0.98376	0.97654	0.98295	99549.0
2012-07-12	B	Futures	89.87	90.36	87.93	90.08	238282.0
2012-07-12	B6	Futures	1.6203	1.6214	1.6084	1.6123	95106.0
2012-07-12	BR	Futures	0.23143	0.23224	0.23066	0.23181	38.0
2012-07-12	BZ	Futures	94.74	96.79	94.53	96.52	3764.0
2012-07-12	C	Futures	1583.0	1595.0	1546.0	1547.0	12451.0
2012-07-12	CB	Futures	85.579	85.848	85.579	85.727	6.0
2012-07-12	CC	Futures	1695.0	1695.0	1638.0	1649.0	23335.0
2012-07-12	CSC	Futures	3.895	3.99	3.886	3.986	21.0
2012-07-12	CT	Futures	93.33	93.44	91.03	91.37	115.0
2012-07-12	DC	Futures	28.68	29.42	28.52	29.36	366.0
2012-07-12	DX	Futures	81.143	81.517	81.124	81.346	19111.0
2012-07-12	E1	Futures	1.31827	1.31892	1.31001	1.31311	35665.0
2012-07-12	E6	Futures	1.44513	1.44608	1.43629	1.43983	204599.0
2012-07-12	E7	Futures	1.436	1.437	1.4274	1.4309	2958.0
2012-07-12	ED	Futures	95.1704	95.1943	95.1656	95.18	202495.0
2012-07-12	ER	Futures	97.69	97.734	97.69	97.729	156028.0
2012-07-12	EW	Futures	940.8	942.8	926.2	938.9	21820.0
2012-07-12	FBTP	Futures	65.99	66.48	65.5	65.59	13494.0
2012-07-12	FBTS	Futures	84.798	85.038	84.5	84.542	5272.0
2012-07-12	FCE	Futures	2338.3	2351.4	2323.4	2333.5	27434.0
2012-07-12	FDAX	Futures	7018.0	7056.2	6951.4	7014.7	132787.0
2012-07-12	FESX	Futures	1510.2	1514.9	1494.0	1505.5	930219.0
2012-07-12	FEU3	Futures	98.285	98.31	98.28	98.31	124.0
2012-07-12	FGBL	Futures	119.45	119.77	119.41	119.63	484175.0
2012-07-12	FGBM	Futures	116.56	116.73	116.53	116.69	281089.0
2012-07-12	FGBS	Futures	110.432	110.502	110.432	110.492	282862.0
2012-07-12	FGBX	Futures	127.48	128.74	127.48	128.31	8848.0
2012-07-12	FOAT	Futures	101.02	101.8	101.02	101.49	22273.0
2012-07-12	FTDX	Futures	690.0	692.8	684.9	686.8	51.0
2012-07-12	FTI	Futures	262.33	264.5	262.33	263.82	423.0
2012-07-12	FTUK	Futures	4094.5	4096.6	4035.5	4054.4	84907.0
2012-07-12	FVSA	Futures	7551.89	7704.31	7524.18	7579.6	3659.0
2012-07-12	FXXP	Futures	181.7	181.9	180.0	180.8	1254.0
2012-07-12	G	Futures	100.03	100.37	99.87	100.18	135610.0
2012-07-12	GF	Futures	284.198	284.198	278.721	278.721	3753.0
2012-07-12	GSCI	Futures	969.65	980.88	964.56	977.14	2121.0
2012-07-12	HE	Futures	97.839	99.389	97.705	98.641	26304.0
2012-07-12	HG	Futures	4.4195	4.4304	4.3602	4.3995	42670.0
2012-07-12	HO	Futures	2.2579	2.27	2.2138	2.2656	27536.0
2012-07-12	HRC	Futures	2450.1	2450.1	2450.1	2450.1	5.0
2012-07-12	J1	Futures	0.0157313	0.0158416	0.0156824	0.015814	76339.0
2012-07-12	J7	Futures	0.015681	0.015779	0.015625	0.015752	632.0

> showing 50 of 98 rows — these rows as CSV

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