PREVIEW / futures_daily / 2012-07-06

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-06.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-07-06	ES	Futures	1378.82	1381.35	1359.32	1368.94	1955639.0
2012-07-06	NQ	Futures	3032.96	3035.55	2973.28	2994.51	253562.0
2012-07-06	YM	Futures	12447.3	12467.7	12263.0	12347.4	142800.0
2012-07-06	CL	Futures	158.17	158.9	153.23	154.01	296204.0
2012-07-06	GC	Futures	2145.8	2153.0	2107.3	2110.7	161742.0
2012-07-06	ZN	Futures	116.72665	117.162451	116.713031	117.107976	805445.0
2012-07-06	A6	Futures	0.91897	0.91915	0.90926	0.91034	127329.0
2012-07-06	AD	Futures	0.98676	0.98727	0.98065	0.98115	89718.0
2012-07-06	B	Futures	89.56	89.66	87.47	87.85	171475.0
2012-07-06	B6	Futures	1.6218	1.6251	1.6155	1.617	89878.0
2012-07-06	BFX	Futures	2678.7	2678.7	2658.0	2659.1	3.0
2012-07-06	BR	Futures	0.23363	0.23363	0.2321	0.23214	101.0
2012-07-06	BZ	Futures	95.76	95.76	93.81	94.12	3098.0
2012-07-06	C	Futures	1624.0	1630.0	1584.0	1603.0	3844.0
2012-07-06	CB	Futures	83.964	83.964	83.964	83.964	4.0
2012-07-06	CC	Futures	1752.0	1752.0	1683.0	1697.0	13062.0
2012-07-06	CSC	Futures	3.867	3.867	3.851	3.86	3.0
2012-07-06	CT	Futures	94.19	94.31	92.28	92.91	44.0
2012-07-06	DC	Futures	28.29	28.39	28.28	28.39	27.0
2012-07-06	DX	Futures	80.474	81.148	80.449	81.106	30583.0
2012-07-06	E1	Futures	1.33389	1.33544	1.32047	1.3215	44737.0
2012-07-06	E6	Futures	1.46365	1.46436	1.44749	1.44891	291598.0
2012-07-06	E7	Futures	1.4547	1.4553	1.4385	1.4399	3098.0
2012-07-06	ED	Futures	95.1322	95.1513	95.1274	95.1417	107111.0
2012-07-06	ER	Futures	97.68	97.685	97.665	97.68	116608.0
2012-07-06	EW	Futures	969.2	970.1	952.8	958.7	27280.0
2012-07-06	FBTP	Futures	65.12	65.41	64.68	64.91	14637.0
2012-07-06	FBTS	Futures	84.633	84.955	84.476	84.6	3059.0
2012-07-06	FCE	Futures	2379.8	2392.0	2345.0	2346.1	115075.0
2012-07-06	FDAX	Futures	7115.1	7137.0	6993.9	7003.2	127009.0
2012-07-06	FESX	Futures	1531.8	1538.6	1505.5	1508.8	1146393.0
2012-07-06	FEU3	Futures	98.251	98.26	98.251	98.26	301.0
2012-07-06	FGBL	Futures	118.28	118.96	118.24	118.89	593553.0
2012-07-06	FGBM	Futures	116.22	116.56	116.21	116.52	397760.0
2012-07-06	FGBS	Futures	110.382	110.437	110.378	110.422	319367.0
2012-07-06	FGBX	Futures	125.34	127.03	124.8	126.98	9888.0
2012-07-06	FOAT	Futures	99.55	100.64	99.48	100.48	21210.0
2012-07-06	FTDX	Futures	711.0	714.7	700.3	702.6	95.0
2012-07-06	FTI	Futures	265.81	266.62	263.3	263.52	29526.0
2012-07-06	FTUK	Futures	4113.8	4114.5	4078.4	4088.6	80372.0
2012-07-06	FVSA	Futures	7612.18	7913.66	7612.18	7898.58	1039.0
2012-07-06	FXXP	Futures	183.0	183.3	181.5	181.6	2896.0
2012-07-06	G	Futures	99.24	99.67	99.07	99.6	98713.0
2012-07-06	GF	Futures	287.947	290.464	287.947	289.181	3085.0
2012-07-06	GSCI	Futures	975.93	980.77	956.37	956.6	575.0
2012-07-06	HE	Futures	99.656	100.805	99.496	99.736	16175.0
2012-07-06	HG	Futures	4.4974	4.5154	4.3866	4.3924	43324.0
2012-07-06	HO	Futures	2.2534	2.255	2.2112	2.2158	18605.0
2012-07-06	HRC	Futures	2450.1	2450.1	2450.1	2450.1	25.0
2012-07-06	J1	Futures	0.015695	0.015819	0.0156749	0.0157476	84990.0

> showing 50 of 99 rows — these rows as CSV

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