PREVIEW / futures_daily / 2011-10-18

all futures daily files

  file:    by_date/futures_daily/2011/2011-10-18.parquet
  size:    9 KB
  rows:    96

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-10-18	ES	Futures	1191.91	1227.59	1183.42	1220.86	2978540.0
2011-10-18	NQ	Futures	2649.32	2706.96	2630.77	2698.12	381902.0
2011-10-18	YM	Futures	10850.6	11134.0	10777.6	11072.6	155436.0
2011-10-18	CL	Futures	161.9	167.4	160.87	166.08	253423.0
2011-10-18	GC	Futures	2258.1	2265.8	2198.3	2231.5	195659.0
2011-10-18	ZN	Futures	110.450198	110.946272	110.155236	110.54405	1273365.0
2011-10-18	A6	Futures	0.88747	0.90137	0.88307	0.89398	161413.0
2011-10-18	AD	Futures	0.97654	0.98805	0.97324	0.98224	104645.0
2011-10-18	B	Futures	96.31	97.82	94.82	97.18	256921.0
2011-10-18	B6	Futures	1.6417	1.6503	1.6304	1.6392	121880.0
2011-10-18	BFX	Futures	2570.1	2570.1	2551.4	2566.0	43.0
2011-10-18	BR	Futures	0.25178	0.25372	0.25178	0.25372	160.0
2011-10-18	BZ	Futures	101.2	103.33	100.21	102.7	1582.0
2011-10-18	C	Futures	1771.0	1786.0	1749.0	1782.0	7831.0
2011-10-18	CB	Futures	95.888	95.888	95.341	95.888	26.0
2011-10-18	CC	Futures	2031.0	2044.0	1978.0	2016.0	18018.0
2011-10-18	CSC	Futures	4.069	4.069	4.069	4.069	3.0
2011-10-18	CT	Futures	129.98	129.98	128.42	129.15	5946.0
2011-10-18	DC	Futures	28.61	29.0	28.46	29.0	366.0
2011-10-18	DX	Futures	76.044	76.431	75.636	75.997	35163.0
2011-10-18	E1	Futures	1.46081	1.46855	1.45149	1.46002	26287.0
2011-10-18	E6	Futures	1.64079	1.65071	1.63087	1.6415	338900.0
2011-10-18	E7	Futures	1.6278	1.6367	1.6169	1.6275	6671.0
2011-10-18	ED	Futures	94.9602	94.9698	94.9459	94.9602	167590.0
2011-10-18	ER	Futures	97.204	97.238	97.174	97.209	114788.0
2011-10-18	EW	Futures	831.7	858.5	822.1	854.7	34174.0
2011-10-18	FBTP	Futures	61.76	61.76	61.32	61.48	4279.0
2011-10-18	FBTS	Futures	81.96	81.96	81.671	81.791	611.0
2011-10-18	FCE	Futures	2251.0	2287.9	2215.1	2252.8	95800.0
2011-10-18	FDAX	Futures	6310.8	6512.7	6250.0	6377.0	197847.0
2011-10-18	FESX	Futures	1519.2	1559.1	1503.9	1526.5	1491807.0
2011-10-18	FEU3	Futures	97.776	97.776	97.766	97.766	9.0
2011-10-18	FGBL	Futures	109.06	109.91	109.06	109.69	971324.0
2011-10-18	FGBM	Futures	110.35	110.7	110.27	110.55	451089.0
2011-10-18	FGBS	Futures	109.009	109.074	108.9	108.979	639153.0
2011-10-18	FGBX	Futures	109.63	111.24	109.56	110.93	7837.0
2011-10-18	FTDX	Futures	609.0	630.2	609.0	620.5	414.0
2011-10-18	FTI	Futures	244.2	250.45	242.88	246.27	17897.0
2011-10-18	FTUK	Futures	3851.8	3940.1	3820.6	3857.6	118443.0
2011-10-18	FVSA	Futures	15418.05	16334.8	15418.05	16272.3	7094.0
2011-10-18	FXXP	Futures	162.5	164.1	161.8	163.4	4959.0
2011-10-18	G	Futures	90.83	91.23	90.5	90.98	134436.0
2011-10-18	GF	Futures	319.508	320.67	316.465	317.35	3180.0
2011-10-18	GSCI	Futures	980.94	1003.43	980.08	997.4	181.0
2011-10-18	HE	Futures	116.488	117.581	116.071	116.906	17296.0
2011-10-18	HG	Futures	4.4118	4.5263	4.3106	4.4462	64713.0
2011-10-18	HO	Futures	2.4132	2.4426	2.3847	2.4315	54536.0
2011-10-18	HRC	Futures	2706.8	2706.8	2706.8	2706.8	0.0
2011-10-18	J1	Futures	0.0163612	0.0164115	0.0163486	0.0163826	81072.0
2011-10-18	J7	Futures	0.016263	0.016312	0.016252	0.016283	424.0

> showing 50 of 96 rows — these rows as CSV

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