PREVIEW / futures_daily / 2012-09-24

all futures daily files

  file:    by_date/futures_daily/2012/2012-09-24.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-09-24	ES	Futures	1476.04	1480.37	1470.44	1477.31	1261245.0
2012-09-24	NQ	Futures	3281.54	3287.59	3251.92	3265.72	204718.0
2012-09-24	YM	Futures	13172.9	13211.9	13122.1	13171.9	93917.0
2012-09-24	CL	Futures	168.17	168.17	164.35	165.92	188315.0
2012-09-24	GC	Futures	2369.5	2370.3	2347.0	2356.0	159194.0
2012-09-24	ZN	Futures	116.642748	116.944896	116.587812	116.835024	531172.0
2012-09-24	A6	Futures	0.94298	0.94307	0.93698	0.94098	89116.0
2012-09-24	AD	Futures	1.02607	1.02607	1.02035	1.02386	52111.0
2012-09-24	B	Futures	101.67	101.72	99.19	100.13	187245.0
2012-09-24	B6	Futures	1.6964	1.6965	1.6894	1.6945	77930.0
2012-09-24	BFX	Futures	2936.5	2936.5	2929.2	2931.5	96.0
2012-09-24	BR	Futures	0.23828	0.23828	0.23765	0.23818	86.0
2012-09-24	BZ	Futures	105.81	105.81	103.99	104.94	1278.0
2012-09-24	C	Futures	1645.0	1646.0	1598.0	1605.0	8028.0
2012-09-24	CB	Futures	98.75	99.419	98.75	99.285	13.0
2012-09-24	CC	Futures	1905.0	1908.0	1841.0	1845.0	17143.0
2012-09-24	CSC	Futures	4.019	4.019	3.998	3.998	15.0
2012-09-24	CT	Futures	94.85	95.06	93.46	93.55	16466.0
2012-09-24	DC	Futures	30.48	30.5	30.1	30.16	111.0
2012-09-24	DX	Futures	76.927	77.319	76.927	77.079	18006.0
2012-09-24	E1	Futures	1.38123	1.38226	1.37222	1.3775	28632.0
2012-09-24	E6	Futures	1.52944	1.5298	1.51932	1.52461	210912.0
2012-09-24	E7	Futures	1.5206	1.5206	1.5101	1.5155	4260.0
2012-09-24	ED	Futures	95.2253	95.2253	95.2062	95.211	119514.0
2012-09-24	ER	Futures	97.901	97.906	97.886	97.891	87131.0
2012-09-24	EW	Futures	1021.9	1024.4	1017.1	1021.7	16705.0
2012-09-24	FBTP	Futures	71.0	71.25	70.58	71.07	13489.0
2012-09-24	FBTS	Futures	89.223	89.332	89.165	89.248	2261.0
2012-09-24	FCE	Futures	2618.6	2624.2	2600.6	2611.8	72178.0
2012-09-24	FDAX	Futures	8131.2	8156.9	8096.1	8127.3	85163.0
2012-09-24	FESX	Futures	1734.2	1743.0	1726.7	1736.2	644380.0
2012-09-24	FEU3	Futures	98.517	98.522	98.512	98.512	106.0
2012-09-24	FGBL	Futures	117.16	117.42	116.96	117.34	489218.0
2012-09-24	FGBM	Futures	115.87	115.95	115.74	115.94	270116.0
2012-09-24	FGBS	Futures	110.343	110.353	110.303	110.333	207141.0
2012-09-24	FGBX	Futures	122.86	123.1	122.1	122.86	4809.0
2012-09-24	FOAT	Futures	102.3	102.4	102.04	102.38	15687.0
2012-09-24	FTDX	Futures	770.2	770.2	765.5	767.4	8.0
2012-09-24	FTI	Futures	283.83	284.34	282.38	283.1	21704.0
2012-09-24	FTUK	Futures	4254.5	4264.0	4223.7	4253.8	61740.0
2012-09-24	FVSA	Futures	5560.16	5560.16	5279.1	5279.1	3411.0
2012-09-24	FXXP	Futures	197.6	197.9	196.9	197.6	955.0
2012-09-24	G	Futures	98.6	98.7	98.36	98.66	82306.0
2012-09-24	GF	Futures	287.199	288.026	286.274	286.956	1869.0
2012-09-24	GSCI	Futures	1059.7	1061.15	1055.02	1059.62	146.0
2012-09-24	HE	Futures	92.882	94.001	92.602	93.659	20062.0
2012-09-24	HG	Futures	4.8576	4.8576	4.7747	4.7953	42090.0
2012-09-24	HH	Futures	38.674	38.674	38.674	38.674	507.0
2012-09-24	HO	Futures	2.5201	2.5201	2.4815	2.4989	23437.0
2012-09-24	HRC	Futures	2475.7	2475.7	2475.7	2475.7	25.0

> showing 50 of 99 rows — these rows as CSV

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