PREVIEW / futures_daily / 2012-07-20

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-20.parquet
  size:    9 KB
  rows:    98

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-20	ES	Futures	1388.95	1389.45	1374.26	1375.53	1800661.0
2012-07-20	NQ	Futures	3045.59	3050.18	2998.82	2999.39	237989.0
2012-07-20	YM	Futures	12497.8	12499.7	12370.7	12392.0	119046.0
2012-07-20	CL	Futures	168.05	168.12	165.02	166.67	249172.0
2012-07-20	GC	Futures	2113.5	2121.1	2102.2	2115.9	122585.0
2012-07-20	ZN	Futures	117.230545	117.666346	117.230545	117.584633	634259.0
2012-07-20	A6	Futures	0.93183	0.93272	0.92679	0.92796	123109.0
2012-07-20	AD	Futures	0.99328	0.99438	0.98837	0.98917	86863.0
2012-07-20	B	Futures	96.57	96.75	94.86	95.97	176745.0
2012-07-20	B6	Futures	1.6423	1.6429	1.6313	1.6319	82535.0
2012-07-20	BFX	Futures	2738.7	2738.7	2691.9	2693.2	4.0
2012-07-20	BR	Futures	0.23425	0.23425	0.23394	0.23405	5.0
2012-07-20	BZ	Futures	103.42	103.49	101.79	102.82	358.0
2012-07-20	C	Futures	1556.0	1582.0	1550.0	1570.0	3126.0
2012-07-20	CB	Futures	89.346	89.884	89.346	89.884	8.0
2012-07-20	CC	Futures	1678.0	1701.0	1671.0	1680.0	7679.0
2012-07-20	CSC	Futures	4.062	4.112	4.062	4.095	44.0
2012-07-20	CT	Futures	94.57	95.04	94.24	94.92	51.0
2012-07-20	DC	Futures	29.87	30.49	29.87	30.41	263.0
2012-07-20	DX	Futures	80.576	81.207	80.537	81.117	22200.0
2012-07-20	E1	Futures	1.3215	1.32189	1.30717	1.30885	41948.0
2012-07-20	E6	Futures	1.44926	1.44997	1.43357	1.43534	245281.0
2012-07-20	E7	Futures	1.4401	1.4407	1.4247	1.4264	3187.0
2012-07-20	ED	Futures	95.1895	95.1943	95.1752	95.1847	97859.0
2012-07-20	ER	Futures	97.744	97.759	97.739	97.759	67791.0
2012-07-20	EW	Futures	959.2	959.7	949.3	950.6	22105.0
2012-07-20	FBTP	Futures	65.16	65.45	64.09	64.44	15993.0
2012-07-20	FBTS	Futures	85.005	85.104	84.203	84.343	3143.0
2012-07-20	FCE	Futures	2418.7	2428.0	2374.4	2376.7	132553.0
2012-07-20	FDAX	Futures	7360.8	7403.9	7228.7	7242.3	150971.0
2012-07-20	FESX	Futures	1550.8	1556.2	1508.8	1513.6	1350882.0
2012-07-20	FGBL	Futures	119.93	120.49	119.87	120.4	440035.0
2012-07-20	FGBM	Futures	116.88	117.12	116.82	117.09	227814.0
2012-07-20	FGBS	Futures	110.527	110.582	110.517	110.577	159369.0
2012-07-20	FGBX	Futures	129.44	130.6	129.25	130.3	3501.0
2012-07-20	FOAT	Futures	102.91	103.2	102.73	102.8	16235.0
2012-07-20	FTDX	Futures	719.3	721.2	713.8	715.6	119.0
2012-07-20	FTI	Futures	273.06	273.44	270.38	270.89	40009.0
2012-07-20	FTUK	Futures	4125.8	4126.9	4076.6	4084.3	81612.0
2012-07-20	FVSA	Futures	6540.35	7316.33	6498.78	7288.61	2919.0
2012-07-20	FXXP	Futures	186.7	186.8	184.4	184.4	1801.0
2012-07-20	G	Futures	100.22	100.78	100.18	100.6	84143.0
2012-07-20	GF	Futures	274.774	274.922	268.606	268.606	2577.0
2012-07-20	GSCI	Futures	1031.65	1038.18	1029.5	1036.19	950.0
2012-07-20	HE	Futures	99.202	100.752	99.042	100.164	10534.0
2012-07-20	HG	Futures	4.5438	4.5457	4.4033	4.442	69211.0
2012-07-20	HO	Futures	2.4033	2.4071	2.3715	2.3905	45046.0
2012-07-20	HRC	Futures	2450.1	2450.1	2450.1	2450.1	60.0
2012-07-20	J1	Futures	0.0159456	0.0159857	0.0159118	0.0159807	63130.0
2012-07-20	J7	Futures	0.015883	0.015921	0.015851	0.015918	187.0

> showing 50 of 98 rows — these rows as CSV

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