PREVIEW / futures_daily / 2012-03-05

all futures daily files

  file:    by_date/futures_daily/2012/2012-03-05.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-03-05	ES	Futures	1372.13	1374.38	1362.84	1369.37	1535936.0
2012-03-05	NQ	Futures	3018.81	3024.81	2979.64	2991.65	223081.0
2012-03-05	YM	Futures	12533.3	12547.8	12443.4	12534.3	108909.0
2012-03-05	CL	Futures	197.76	199.0	195.45	197.71	237450.0
2012-03-05	GC	Futures	2293.1	2300.6	2269.0	2281.7	158938.0
2012-03-05	ZN	Futures	113.583833	113.718859	113.354289	113.381294	45042.0
2012-03-05	A6	Futures	0.95347	0.95427	0.9468	0.94786	120255.0
2012-03-05	AD	Futures	1.01326	1.01517	1.00744	1.00964	81626.0
2012-03-05	B	Futures	110.12	111.1	109.26	110.45	103431.0
2012-03-05	B6	Futures	1.6547	1.6596	1.65	1.6587	76571.0
2012-03-05	BFX	Futures	2790.0	2793.7	2785.1	2788.8	79.0
2012-03-05	BR	Futures	0.27045	0.27045	0.26997	0.26997	88.0
2012-03-05	BZ	Futures	116.83	118.15	116.83	117.49	652.0
2012-03-05	C	Futures	1487.0	1500.0	1466.0	1468.0	7160.0
2012-03-05	CB	Futures	83.964	83.964	83.426	83.695	13.0
2012-03-05	CC	Futures	1771.0	1781.0	1730.0	1737.0	9810.0
2012-03-05	CSC	Futures	3.669	3.68	3.52	3.536	136.0
2012-03-05	CT	Futures	111.01	115.43	110.66	115.43	9243.0
2012-03-05	DC	Futures	25.3	25.33	24.2	24.35	295.0
2012-03-05	DX	Futures	77.393	77.515	77.169	77.247	18745.0
2012-03-05	E1	Futures	1.43589	1.44166	1.43274	1.43969	31930.0
2012-03-05	E6	Futures	1.5778	1.58306	1.57314	1.58102	220586.0
2012-03-05	E7	Futures	1.5634	1.5685	1.5588	1.5666	3742.0
2012-03-05	EBM	Futures	284.35	286.03	283.67	284.69	7622.0
2012-03-05	ED	Futures	95.1083	95.1083	95.0916	95.0963	110616.0
2012-03-05	ER	Futures	97.553	97.558	97.518	97.518	101180.0
2012-03-05	EW	Futures	982.3	983.6	974.7	982.1	22884.0
2012-03-05	FBTP	Futures	68.63	68.77	68.33	68.66	9565.0
2012-03-05	FBTS	Futures	86.568	86.722	86.535	86.682	1890.0
2012-03-05	FCE	Futures	2465.4	2472.4	2445.6	2462.9	112425.0
2012-03-05	FDAX	Futures	7602.6	7626.4	7525.9	7586.6	138695.0
2012-03-05	FESX	Futures	1696.8	1698.8	1679.4	1692.8	838437.0
2012-03-05	FEU3	Futures	98.083	98.083	98.073	98.073	101.0
2012-03-05	FGBL	Futures	113.34	113.7	113.16	113.25	454070.0
2012-03-05	FGBM	Futures	113.8	113.88	113.61	113.66	427690.0
2012-03-05	FGBS	Futures	109.989	110.004	109.914	109.924	503900.0
2012-03-05	FGBX	Futures	118.46	118.83	117.54	117.69	22864.0
2012-03-05	FTDX	Futures	715.3	719.0	712.0	715.7	404.0
2012-03-05	FTI	Futures	275.17	275.43	272.32	273.62	30590.0
2012-03-05	FTUK	Futures	4255.2	4258.1	4218.4	4227.8	97542.0
2012-03-05	FVSA	Futures	9178.82	9577.9	9178.82	9330.85	7727.0
2012-03-05	FXXP	Futures	188.2	188.5	187.1	187.9	4032.0
2012-03-05	G	Futures	94.43	94.64	94.0	94.13	107595.0
2012-03-05	GF	Futures	335.656	335.656	330.885	331.786	3377.0
2012-03-05	GSCI	Futures	1110.62	1112.98	1104.08	1110.3	402.0
2012-03-05	HE	Futures	109.247	109.278	107.767	108.069	19576.0
2012-03-05	HG	Futures	5.119	5.1557	5.0285	5.06	43244.0
2012-03-05	HO	Futures	2.6402	2.6644	2.6277	2.6523	16976.0
2012-03-05	HRC	Futures	2719.2	2719.2	2719.2	2719.2	0.0
2012-03-05	J1	Futures	0.0153415	0.0154746	0.015339	0.0154181	88300.0

> showing 50 of 99 rows — these rows as CSV

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