PREVIEW / futures_daily / 2012-06-22

all futures daily files

  file:    by_date/futures_daily/2012/2012-06-22.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-06-22	ES	Futures	1335.27	1348.69	1335.02	1343.63	1859289.0
2012-06-22	NQ	Futures	2929.38	2963.24	2925.07	2953.77	253677.0
2012-06-22	YM	Futures	12125.3	12230.0	12123.3	12193.2	118558.0
2012-06-22	CL	Futures	142.45	146.57	141.45	145.46	293224.0
2012-06-22	GC	Futures	2093.0	2104.3	2083.5	2094.6	120470.0
2012-06-22	ZN	Futures	116.168279	116.304467	115.841428	115.923141	857121.0
2012-06-22	A6	Futures	0.89667	0.89919	0.89298	0.89883	150980.0
2012-06-22	AD	Futures	0.97283	0.97724	0.97152	0.97644	86258.0
2012-06-22	B	Futures	81.16	83.26	80.35	82.61	248376.0
2012-06-22	B6	Futures	1.6296	1.6335	1.6255	1.6285	83813.0
2012-06-22	BFX	Futures	2545.7	2549.3	2545.7	2548.7	6.0
2012-06-22	BR	Futures	0.22997	0.22997	0.22894	0.22894	181.0
2012-06-22	BZ	Futures	86.56	88.48	86.56	87.83	562.0
2012-06-22	C	Futures	1497.0	1520.0	1497.0	1500.0	2338.0
2012-06-22	CB	Futures	85.054	85.054	83.964	83.964	18.0
2012-06-22	CC	Futures	1613.0	1628.0	1576.0	1584.0	9076.0
2012-06-22	CSC	Futures	3.736	3.743	3.736	3.736	10.0
2012-06-22	CT	Futures	90.74	90.74	90.74	90.74	1510.0
2012-06-22	DC	Futures	27.25	27.33	27.17	27.25	32.0
2012-06-22	DX	Futures	80.066	80.241	79.92	80.019	22108.0
2012-06-22	E1	Futures	1.35158	1.35571	1.34887	1.35352	41461.0
2012-06-22	E6	Futures	1.48123	1.48559	1.47781	1.483	251484.0
2012-06-22	E7	Futures	1.4725	1.4762	1.4685	1.4738	2594.0
2012-06-22	ED	Futures	95.1083	95.1417	95.0987	95.1322	275107.0
2012-06-22	ER	Futures	97.621	97.646	97.607	97.621	83249.0
2012-06-22	EW	Futures	919.8	927.6	918.9	922.6	22783.0
2012-06-22	FBTP	Futures	66.0	66.52	65.47	66.13	20887.0
2012-06-22	FBTS	Futures	84.616	85.195	84.451	84.848	5516.0
2012-06-22	FCE	Futures	2290.2	2304.3	2274.3	2288.0	93596.0
2012-06-22	FDAX	Futures	6883.7	6902.8	6832.9	6835.6	126207.0
2012-06-22	FESX	Futures	1471.0	1489.2	1464.9	1473.7	962000.0
2012-06-22	FEU3	Futures	98.201	98.201	98.186	98.201	402.0
2012-06-22	FGBL	Futures	116.79	117.07	116.07	116.36	734845.0
2012-06-22	FGBM	Futures	115.01	115.2	114.61	114.8	478703.0
2012-06-22	FGBS	Futures	110.183	110.218	110.044	110.113	395848.0
2012-06-22	FGBX	Futures	125.74	126.7	124.21	124.7	7230.0
2012-06-22	FOAT	Futures	98.15	98.77	98.15	98.6	13093.0
2012-06-22	FTDX	Futures	694.7	694.7	684.4	687.2	477.0
2012-06-22	FTI	Futures	255.31	255.4	253.65	254.16	32786.0
2012-06-22	FTUK	Futures	3979.4	4005.6	3971.4	3979.1	79983.0
2012-06-22	FVSA	Futures	8727.63	8727.63	8305.57	8486.45	6475.0
2012-06-22	FXXP	Futures	176.5	177.0	175.7	176.0	3714.0
2012-06-22	G	Futures	98.91	99.04	98.33	98.5	120987.0
2012-06-22	GF	Futures	301.516	302.355	299.394	301.565	2678.0
2012-06-22	GSCI	Futures	886.89	897.98	886.89	893.23	156.0
2012-06-22	HE	Futures	100.161	100.477	99.109	99.925	8941.0
2012-06-22	HG	Futures	4.2571	4.2835	4.2062	4.2707	15525.0
2012-06-22	HO	Futures	2.0751	2.0923	2.0599	2.0761	16877.0
2012-06-22	HRC	Futures	2429.9	2429.9	2429.9	2429.9	0.0
2012-06-22	J1	Futures	0.0156348	0.0156799	0.0155684	0.0155947	66553.0

> showing 50 of 98 rows — these rows as CSV

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