PREVIEW / futures_daily / 2012-06-21

all futures daily files

  file:    by_date/futures_daily/2012/2012-06-21.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-21	ES	Futures	1367.93	1370.46	1334.26	1335.02	2713717.0
2012-06-21	NQ	Futures	3005.13	3007.71	2925.07	2928.8	289047.0
2012-06-21	YM	Futures	12380.4	12409.5	12119.4	12129.1	172172.0
2012-06-21	CL	Futures	147.87	148.08	142.12	142.61	376969.0
2012-06-21	GC	Futures	2149.2	2149.8	2091.8	2092.8	214302.0
2012-06-21	ZN	Futures	115.991235	116.399799	115.93676	116.236373	1035137.0
2012-06-21	A6	Futures	0.90863	0.91042	0.8946	0.89622	183248.0
2012-06-21	AD	Futures	0.98215	0.98336	0.97193	0.97343	128007.0
2012-06-21	B	Futures	84.04	84.23	80.72	81.02	351702.0
2012-06-21	B6	Futures	1.6415	1.6439	1.6276	1.6294	105767.0
2012-06-21	BFX	Futures	2571.0	2573.4	2571.0	2573.4	1.0
2012-06-21	BR	Futures	0.23222	0.23222	0.22923	0.22997	300.0
2012-06-21	BZ	Futures	88.62	89.24	85.83	86.14	1121.0
2012-06-21	C	Futures	1503.0	1545.0	1498.0	1515.0	2464.0
2012-06-21	CB	Futures	85.04	85.054	85.04	85.04	22.0
2012-06-21	CC	Futures	1638.0	1665.0	1610.0	1618.0	9113.0
2012-06-21	CSC	Futures	3.725	3.725	3.725	3.725	20.0
2012-06-21	CT	Futures	100.93	100.93	95.63	95.63	3706.0
2012-06-21	DC	Futures	27.09	27.23	27.07	27.17	41.0
2012-06-21	DX	Futures	79.29	80.187	79.26	80.064	29677.0
2012-06-21	E1	Futures	1.36785	1.36811	1.35016	1.35236	55392.0
2012-06-21	E6	Futures	1.49916	1.4994	1.47934	1.48194	364723.0
2012-06-21	E7	Futures	1.4896	1.4901	1.4704	1.4727	3428.0
2012-06-21	ED	Futures	95.1178	95.1178	95.0987	95.1083	184109.0
2012-06-21	ER	Futures	97.597	97.626	97.582	97.607	122757.0
2012-06-21	EW	Futures	946.2	948.6	918.5	918.9	30943.0
2012-06-21	FBTP	Futures	65.94	66.76	65.72	66.1	23137.0
2012-06-21	FBTS	Futures	84.161	84.914	84.153	84.748	7894.0
2012-06-21	FCE	Futures	2301.3	2333.5	2278.0	2304.3	118601.0
2012-06-21	FDAX	Futures	6947.0	7021.8	6842.2	6938.8	154226.0
2012-06-21	FESX	Futures	1480.4	1505.5	1462.2	1484.5	1413484.0
2012-06-21	FEU3	Futures	98.167	98.186	98.167	98.186	950.0
2012-06-21	FGBL	Futures	116.1	116.93	115.93	116.89	898926.0
2012-06-21	FGBM	Futures	114.63	115.08	114.55	115.04	483322.0
2012-06-21	FGBS	Futures	110.039	110.198	110.034	110.183	427748.0
2012-06-21	FGBX	Futures	124.05	126.17	123.56	125.96	9938.0
2012-06-21	FOAT	Futures	97.87	98.65	97.87	98.22	22228.0
2012-06-21	FTDX	Futures	690.5	697.9	689.6	694.7	68.0
2012-06-21	FTI	Futures	255.95	259.09	253.78	256.5	39294.0
2012-06-21	FTUK	Futures	4061.3	4061.3	3970.7	4027.5	107837.0
2012-06-21	FVSA	Futures	8923.59	8923.59	8215.13	8350.79	10611.0
2012-06-21	FXXP	Futures	177.3	178.8	176.7	177.6	10437.0
2012-06-21	G	Futures	98.45	98.92	98.1	98.79	180139.0
2012-06-21	GF	Futures	302.108	303.391	300.381	301.269	2950.0
2012-06-21	GSCI	Futures	902.18	906.06	883.32	887.29	186.0
2012-06-21	HE	Futures	99.819	100.846	99.477	100.635	11002.0
2012-06-21	HG	Futures	4.3718	4.3724	4.2539	4.2597	17227.0
2012-06-21	HO	Futures	2.1148	2.122	2.0604	2.0672	19464.0
2012-06-21	HRC	Futures	2429.9	2429.9	2409.6	2429.9	10.0
2012-06-21	J1	Futures	0.0157852	0.0158027	0.0156148	0.015621	106015.0

> showing 50 of 99 rows — these rows as CSV

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