PREVIEW / futures_daily / 2012-04-20

all futures daily files

  file:    by_date/futures_daily/2012/2012-04-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-04-20	ES	Futures	1384.35	1393.92	1381.83	1385.86	1808442.0
2012-04-20	NQ	Futures	3077.12	3102.61	3058.79	3063.94	292572.0
2012-04-20	YM	Futures	12553.9	12668.6	12521.8	12630.7	110589.0
2012-04-20	CL	Futures	189.05	192.02	188.69	190.56	225790.0
2012-04-20	GC	Futures	2196.6	2203.3	2190.5	2196.1	87025.0
2012-04-20	ZN	Futures	114.071024	114.179327	113.89503	114.084562	713355.0
2012-04-20	A6	Futures	0.92393	0.92843	0.92177	0.92717	102372.0
2012-04-20	AD	Futures	1.00953	1.01547	1.00903	1.01185	73208.0
2012-04-20	B	Futures	106.73	108.25	106.6	107.41	178697.0
2012-04-20	B6	Futures	1.6842	1.6947	1.6827	1.6901	114829.0
2012-04-20	BFX	Futures	2662.9	2686.7	2662.9	2676.5	19.0
2012-04-20	BR	Futures	0.2508	0.25394	0.2508	0.25294	1504.0
2012-04-20	BZ	Futures	113.33	114.46	113.26	113.61	662.0
2012-04-20	C	Futures	1436.0	1483.0	1436.0	1478.0	2472.0
2012-04-20	CB	Futures	77.505	77.505	77.276	77.276	3.0
2012-04-20	CC	Futures	1672.0	1718.0	1659.0	1711.0	9416.0
2012-04-20	CSC	Futures	3.517	3.517	3.462	3.476	70.0
2012-04-20	CT	Futures	114.22	114.74	112.26	112.68	3734.0
2012-04-20	DC	Futures	24.25	24.37	23.74	24.04	461.0
2012-04-20	DX	Futures	77.196	77.264	76.76	76.845	23406.0
2012-04-20	E1	Futures	1.43206	1.44254	1.43102	1.4411	47542.0
2012-04-20	E6	Futures	1.56847	1.57957	1.56764	1.57802	243875.0
2012-04-20	E7	Futures	1.5535	1.5644	1.5527	1.5629	3208.0
2012-04-20	EBM	Futures	291.42	294.12	290.75	291.76	7694.0
2012-04-20	ED	Futures	95.0597	95.0645	95.0549	95.0597	86539.0
2012-04-20	ER	Futures	97.513	97.518	97.494	97.508	71188.0
2012-04-20	EW	Futures	982.8	992.9	981.1	985.0	21916.0
2012-04-20	FBTP	Futures	65.82	65.82	64.98	65.45	15860.0
2012-04-20	FBTS	Futures	84.712	84.867	84.509	84.761	2869.0
2012-04-20	FCE	Futures	2248.9	2272.0	2236.6	2261.5	169580.0
2012-04-20	FDAX	Futures	7398.2	7483.9	7358.9	7464.5	150979.0
2012-04-20	FESX	Futures	1535.7	1559.2	1526.0	1553.6	1661010.0
2012-04-20	FGBL	Futures	115.27	115.5	114.97	115.11	675751.0
2012-04-20	FGBM	Futures	114.58	114.67	114.41	114.47	329490.0
2012-04-20	FGBS	Futures	110.103	110.128	110.079	110.099	269005.0
2012-04-20	FGBX	Futures	120.21	120.65	119.56	119.78	5337.0
2012-04-20	FOAT	Futures	93.98	94.13	93.26	93.95	24270.0
2012-04-20	FTDX	Futures	726.5	728.4	719.5	723.7	56.0
2012-04-20	FTI	Futures	261.47	264.33	260.99	263.99	47439.0
2012-04-20	FTUK	Futures	4154.2	4185.9	4143.6	4175.4	112693.0
2012-04-20	FVSA	Futures	9656.19	9656.19	9060.94	9110.55	2217.0
2012-04-20	FXXP	Futures	183.0	184.4	182.7	184.1	2964.0
2012-04-20	G	Futures	94.33	94.57	93.89	94.25	120769.0
2012-04-20	GF	Futures	317.447	318.176	316.249	316.405	2042.0
2012-04-20	GSCI	Futures	1072.51	1079.9	1072.51	1074.9	242.0
2012-04-20	HE	Futures	97.231	97.258	95.69	96.295	544.0
2012-04-20	HG	Futures	4.7584	4.8743	4.7578	4.854	18449.0
2012-04-20	HO	Futures	2.5725	2.5996	2.5679	2.5819	43132.0
2012-04-20	HRC	Futures	2668.7	2668.7	2668.7	2668.7	0.0
2012-04-20	J1	Futures	0.0153764	0.0153965	0.0153388	0.0153764	53800.0

> showing 50 of 99 rows — these rows as CSV

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