PREVIEW / futures_daily / 2012-03-09

all futures daily files

  file:    by_date/futures_daily/2012/2012-03-09.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-09	ES	Futures	1371.12	1379.4	1368.11	1377.39	1063406.0
2012-03-09	NQ	Futures	3016.24	3033.39	3009.37	3028.82	126691.0
2012-03-09	YM	Futures	12483.0	12538.1	12459.8	12505.2	56879.0
2012-03-09	CL	Futures	198.06	200.45	196.61	198.97	292694.0
2012-03-09	GC	Futures	2277.2	2298.6	2245.7	2291.9	206573.0
2012-03-09	ZN	Futures	113.434738	113.48889	113.096289	113.258745	992109.0
2012-03-09	A6	Futures	0.94644	0.94813	0.93932	0.94003	148971.0
2012-03-09	AD	Futures	1.01326	1.01647	1.00954	1.01356	117403.0
2012-03-09	B	Futures	112.27	113.05	111.62	112.62	113185.0
2012-03-09	B6	Futures	1.6548	1.6549	1.637	1.6378	131520.0
2012-03-09	BFX	Futures	2779.8	2791.2	2779.8	2788.8	7.0
2012-03-09	BR	Futures	0.26534	0.26534	0.26234	0.26289	24.0
2012-03-09	BZ	Futures	119.12	120.22	119.12	119.79	852.0
2012-03-09	C	Futures	1527.0	1558.0	1521.0	1550.0	6640.0
2012-03-09	CB	Futures	82.753	82.753	82.349	82.349	18.0
2012-03-09	CC	Futures	1807.0	1845.0	1797.0	1834.0	9830.0
2012-03-09	CSC	Futures	3.692	3.692	3.68	3.68	2.0
2012-03-09	CT	Futures	112.26	113.21	110.44	111.13	11774.0
2012-03-09	DC	Futures	25.73	25.83	25.53	25.66	50.0
2012-03-09	DX	Futures	77.111	77.958	77.082	77.947	28294.0
2012-03-09	E1	Futures	1.44586	1.44639	1.42552	1.4267	62781.0
2012-03-09	E6	Futures	1.58664	1.587	1.56549	1.56668	308977.0
2012-03-09	E7	Futures	1.5721	1.5721	1.5512	1.5524	3834.0
2012-03-09	EBM	Futures	275.59	281.99	275.59	281.32	15213.0
2012-03-09	ED	Futures	95.0916	95.0916	95.0796	95.0844	90710.0
2012-03-09	ER	Futures	97.503	97.513	97.499	97.503	57513.0
2012-03-09	EW	Futures	981.4	996.0	977.1	992.9	20688.0
2012-03-09	FBTP	Futures	69.44	70.23	69.14	69.37	14994.0
2012-03-09	FBTS	Futures	86.657	86.844	86.47	86.519	1082.0
2012-03-09	FCE	Futures	2463.2	2478.8	2446.3	2463.9	102301.0
2012-03-09	FDAX	Futures	7564.0	7636.3	7544.1	7608.2	133534.0
2012-03-09	FESX	Futures	1685.4	1692.8	1673.4	1684.1	1260924.0
2012-03-09	FEU3	Futures	98.058	98.058	98.058	98.058	100.0
2012-03-09	FGBL	Futures	113.39	113.63	113.27	113.55	492410.0
2012-03-09	FGBM	Futures	113.8	113.96	113.77	113.92	246615.0
2012-03-09	FGBS	Futures	109.999	110.024	109.974	110.009	206240.0
2012-03-09	FGBX	Futures	117.53	118.08	117.34	117.8	2876.0
2012-03-09	FTDX	Futures	706.0	718.1	706.0	715.3	466.0
2012-03-09	FTI	Futures	273.91	275.55	272.11	274.04	30117.0
2012-03-09	FTUK	Futures	4216.9	4252.6	4210.4	4248.0	140015.0
2012-03-09	FVSA	Futures	9558.9	9558.9	9102.81	9121.81	5542.0
2012-03-09	FXXP	Futures	187.5	188.5	186.8	188.2	2460.0
2012-03-09	G	Futures	94.38	94.51	94.18	94.33	78982.0
2012-03-09	GF	Futures	327.916	328.605	326.06	326.431	1225.0
2012-03-09	GSCI	Futures	1105.58	1116.44	1101.56	1110.69	2316.0
2012-03-09	HE	Futures	105.561	106.317	105.169	106.136	25059.0
2012-03-09	HG	Futures	4.9747	5.0836	4.9662	5.0587	53143.0
2012-03-09	HO	Futures	2.7005	2.7055	2.6831	2.6963	21672.0
2012-03-09	HRC	Futures	2719.2	2719.2	2719.2	2719.2	0.0
2012-03-09	J1	Futures	0.015398	0.0154143	0.0151933	0.0152122	148766.0

> showing 50 of 99 rows — these rows as CSV

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