PREVIEW / futures_daily / 2011-09-09

all futures daily files

  file:    by_date/futures_daily/2011/2011-09-09.parquet
  size:    9 KB
  rows:    97

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
2011-09-09	ES	Futures	1177.61	1185.8	1138.88	1150.05	1615259.0
2011-09-09	NQ	Futures	2523.49	2536.87	2448.04	2469.97	143421.0
2011-09-09	YM	Futures	10680.2	10750.2	10328.6	10419.3	64302.0
2011-09-09	CL	Futures	169.09	170.48	163.13	166.18	349238.0
2011-09-09	GC	Futures	2527.4	2550.6	2464.7	2510.6	273998.0
2011-09-09	ZN	Futures	111.764124	112.434494	111.603235	112.313828	1147837.0
2011-09-09	A6	Futures	0.91935	0.92422	0.90552	0.90726	138946.0
2011-09-09	AD	Futures	1.00884	1.01103	0.99995	1.00055	102734.0
2011-09-09	B	Futures	96.75	97.73	94.11	95.18	170694.0
2011-09-09	B6	Futures	1.6599	1.6633	1.648	1.6501	120368.0
2011-09-09	BFX	Futures	2612.4	2613.7	2541.0	2552.5	5.0
2011-09-09	BR	Futures	0.26696	0.26696	0.26199	0.26425	1754.0
2011-09-09	BZ	Futures	100.93	100.93	97.58	98.6	1421.0
2011-09-09	C	Futures	1974.0	1981.0	1963.0	1965.0	12305.0
2011-09-09	CB	Futures	98.628	98.628	96.436	96.436	8.0
2011-09-09	CC	Futures	2293.0	2297.0	2241.0	2253.0	10006.0
2011-09-09	CSC	Futures	4.349	4.349	4.349	4.349	9.0
2011-09-09	CT	Futures	146.32	146.32	142.69	143.14	18.0
2011-09-09	DC	Futures	30.21	30.23	30.04	30.13	52.0
2011-09-09	DX	Futures	75.613	76.628	75.4	76.554	56003.0
2011-09-09	E1	Futures	1.49448	1.50233	1.47565	1.47918	26010.0
2011-09-09	E6	Futures	1.64922	1.65504	1.61822	1.62214	472976.0
2011-09-09	E7	Futures	1.6367	1.6428	1.6065	1.6103	6798.0
2011-09-09	ED	Futures	94.9501	94.9501	94.9191	94.9263	299417.0
2011-09-09	ER	Futures	97.504	97.554	97.499	97.529	181090.0
2011-09-09	EW	Futures	839.6	845.7	809.2	819.5	37585.0
2011-09-09	FBTP	Futures	63.59	63.6	62.46	63.07	10195.0
2011-09-09	FBTS	Futures	82.192	82.224	81.799	81.992	980.0
2011-09-09	FCE	Futures	2150.6	2160.4	2064.3	2087.8	126528.0
2011-09-09	FDAX	Futures	5718.7	5772.6	5492.7	5540.8	237919.0
2011-09-09	FESX	Futures	1377.1	1384.8	1313.0	1328.4	1890641.0
2011-09-09	FEU3	Futures	98.054	98.069	98.054	98.069	55.0
2011-09-09	FGBL	Futures	110.6	111.84	110.49	111.47	847945.0
2011-09-09	FGBM	Futures	110.98	111.63	110.97	111.49	470448.0
2011-09-09	FGBS	Futures	109.253	109.402	109.243	109.372	520899.0
2011-09-09	FGBX	Futures	109.91	112.03	109.83	111.48	5713.0
2011-09-09	FTDX	Futures	640.8	641.3	620.7	626.1	239.0
2011-09-09	FTI	Futures	229.24	231.4	223.4	225.28	47356.0
2011-09-09	FTUK	Futures	3733.9	3776.6	3642.9	3681.7	162740.0
2011-09-09	FVSA	Futures	15892.37	17483.54	15892.37	17328.31	1552.0
2011-09-09	FXXP	Futures	155.5	155.5	152.0	152.2	3889.0
2011-09-09	G	Futures	91.42	92.17	91.33	91.94	93730.0
2011-09-09	GF	Futures	308.073	308.874	304.982	305.039	479.0
2011-09-09	GSCI	Futures	1037.85	1037.85	1022.81	1029.31	1680.0
2011-09-09	HE	Futures	105.771	107.054	105.008	106.565	24306.0
2011-09-09	HG	Futures	5.4645	5.481	5.2852	5.2964	36185.0
2011-09-09	HO	Futures	2.4592	2.4745	2.3852	2.4105	16563.0
2011-09-09	HRC	Futures	2910.3	2910.3	2910.3	2910.3	0.0
2011-09-09	J1	Futures	0.0162167	0.0163059	0.0161438	0.0162268	127726.0
2011-09-09	J7	Futures	0.016096	0.016196	0.016037	0.016118	678.0

> showing 50 of 97 rows — these rows as CSV

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