PREVIEW / futures_daily / 2011-03-09

all futures daily files

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

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-03-09	ES	Futures	1299.06	1304.23	1290.94	1294.88	2196273.0
2011-03-09	NQ	Futures	2648.38	2657.18	2620.57	2623.12	374399.0
2011-03-09	YM	Futures	11420.2	11468.9	11373.4	11394.0	143580.0
2011-03-09	CL	Futures	203.93	205.8	201.87	202.81	353948.0
2011-03-09	GC	Futures	1940.3	1949.9	1931.4	1940.1	126006.0
2011-03-09	ZN	Futures	99.736101	100.381344	99.67026	100.223325	1152268.0
2011-03-09	A6	Futures	0.8558	0.8586	0.85258	0.85665	102228.0
2011-03-09	AD	Futures	1.02153	1.02639	1.02133	1.0246	86985.0
2011-03-09	B	Futures	95.99	98.63	95.32	98.35	163818.0
2011-03-09	B6	Futures	1.6764	1.685	1.6738	1.6798	118175.0
2011-03-09	BFX	Futures	3102.6	3105.1	3072.6	3079.5	68.0
2011-03-09	BR	Futures	0.26114	0.26178	0.26063	0.26118	75.0
2011-03-09	BZ	Futures	102.64	103.61	102.64	103.61	2002.0
2011-03-09	C	Futures	2507.0	2514.0	2455.0	2463.0	2893.0
2011-03-09	CB	Futures	123.217	123.217	123.202	123.202	8.0
2011-03-09	CC	Futures	2920.0	2920.0	2819.0	2835.0	9667.0
2011-03-09	CSC	Futures	4.317	4.317	4.317	4.317	13.0
2011-03-09	CT	Futures	183.72	190.83	181.06	182.79	14909.0
2011-03-09	DC	Futures	28.74	29.22	28.48	29.17	148.0
2011-03-09	DX	Futures	76.762	76.836	76.402	76.581	34972.0
2011-03-09	E1	Futures	1.4017	1.41428	1.39881	1.40956	51976.0
2011-03-09	E6	Futures	1.64491	1.64928	1.63899	1.64479	228511.0
2011-03-09	E7	Futures	1.6327	1.637	1.6267	1.6325	3903.0
2011-03-09	EBM	Futures	219.34	224.04	217.47	217.94	10570.0
2011-03-09	ED	Futures	94.867	94.8694	94.8646	94.8646	100233.0
2011-03-09	ER	Futures	97.212	97.232	97.207	97.227	77899.0
2011-03-09	EW	Futures	952.1	955.3	944.0	945.9	27555.0
2011-03-09	FBTP	Futures	63.07	63.08	62.82	62.9	8860.0
2011-03-09	FCE	Futures	2661.5	2681.7	2647.8	2654.5	147066.0
2011-03-09	FDAX	Futures	7657.2	7731.6	7613.3	7633.1	168756.0
2011-03-09	FESX	Futures	1823.4	1841.5	1818.5	1822.2	1302771.0
2011-03-09	FGBL	Futures	97.18	97.43	97.15	97.29	694128.0
2011-03-09	FGBM	Futures	102.62	102.86	102.6	102.77	433007.0
2011-03-09	FGBS	Futures	106.206	106.29	106.201	106.266	428140.0
2011-03-09	FGBX	Futures	93.64	94.16	93.59	93.97	3181.0
2011-03-09	FTDX	Futures	790.3	794.7	783.3	785.0	702.0
2011-03-09	FTI	Futures	295.96	298.22	295.79	296.24	37675.0
2011-03-09	FTUK	Futures	4146.1	4149.9	4110.0	4123.5	99517.0
2011-03-09	FXXP	Futures	182.4	183.6	182.3	182.7	2151.0
2011-03-09	G	Futures	80.54	80.76	80.52	80.67	79729.0
2011-03-09	GF	Futures	324.375	328.075	323.881	326.101	2276.0
2011-03-09	GSCI	Futures	1123.8	1128.04	1115.71	1119.4	2463.0
2011-03-09	HE	Futures	104.314	105.014	103.409	104.722	30309.0
2011-03-09	HG	Futures	5.7875	5.8328	5.5717	5.611	54668.0
2011-03-09	HO	Futures	2.5156	2.576	2.5085	2.5671	17266.0
2011-03-09	HRC	Futures	3081.2	3081.2	3081.2	3081.2	0.0
2011-03-09	J1	Futures	0.01519	0.0152076	0.0151423	0.0151875	121782.0
2011-03-09	J7	Futures	0.015068	0.015098	0.015037	0.01508	142.0
2011-03-09	JB	Futures	120.6	120.66	120.51	120.65	1187.0
2011-03-09	KC	Futures	696.93	718.99	696.45	714.63	13640.0

> showing 50 of 93 rows — these rows as CSV

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