PREVIEW / futures_daily / 2012-07-25

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-25.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-25	ES	Futures	1347.93	1357.05	1338.06	1351.98	1840501.0
2012-07-25	NQ	Futures	2932.53	2939.13	2888.63	2919.34	270731.0
2012-07-25	YM	Futures	12150.5	12297.0	12100.0	12260.1	132355.0
2012-07-25	CL	Futures	160.08	162.18	157.61	161.48	289552.0
2012-07-25	GC	Futures	2112.4	2152.2	2109.3	2149.7	212741.0
2012-07-25	ZN	Futures	118.020435	118.088529	117.652727	117.870628	770992.0
2012-07-25	A6	Futures	0.91483	0.92481	0.91042	0.92409	160222.0
2012-07-25	AD	Futures	0.97995	0.98777	0.97864	0.98717	122423.0
2012-07-25	B	Futures	92.67	94.06	91.72	93.77	224411.0
2012-07-25	B6	Futures	1.6204	1.6252	1.6153	1.6207	141240.0
2012-07-25	BFX	Futures	2608.0	2625.4	2608.0	2610.4	18.0
2012-07-25	BR	Futures	0.23246	0.23317	0.23224	0.23308	9.0
2012-07-25	BZ	Futures	99.81	100.76	98.31	100.47	2082.0
2012-07-25	C	Futures	1578.0	1590.0	1560.0	1581.0	3213.0
2012-07-25	CB	Futures	90.423	90.826	90.423	90.692	4.0
2012-07-25	CC	Futures	1689.0	1699.0	1654.0	1680.0	8559.0
2012-07-25	CSC	Futures	4.086	4.086	4.04	4.077	4.0
2012-07-25	CT	Futures	93.29	93.29	90.83	91.03	69.0
2012-07-25	DC	Futures	30.11	30.31	29.95	30.06	303.0
2012-07-25	DX	Futures	81.663	81.702	81.168	81.183	18754.0
2012-07-25	E1	Futures	1.29813	1.31001	1.29748	1.30859	49180.0
2012-07-25	E6	Futures	1.4239	1.43664	1.42272	1.43523	281130.0
2012-07-25	E7	Futures	1.4147	1.4277	1.4139	1.4263	4158.0
2012-07-25	ED	Futures	95.1895	95.1943	95.18	95.1847	114467.0
2012-07-25	ER	Futures	97.744	97.763	97.734	97.749	90681.0
2012-07-25	EW	Futures	923.0	932.0	917.4	926.0	25370.0
2012-07-25	FBTP	Futures	62.29	63.3	61.95	63.04	21612.0
2012-07-25	FBTS	Futures	82.731	83.425	82.689	83.227	2426.0
2012-07-25	FCE	Futures	2278.4	2317.9	2276.9	2294.8	123870.0
2012-07-25	FDAX	Futures	6927.4	7071.5	6923.5	6990.1	148958.0
2012-07-25	FESX	Futures	1445.3	1473.7	1444.6	1457.4	1066011.0
2012-07-25	FGBL	Futures	119.86	119.93	118.96	119.51	769547.0
2012-07-25	FGBM	Futures	116.78	116.8	116.45	116.63	364588.0
2012-07-25	FGBS	Futures	110.567	110.567	110.517	110.537	242784.0
2012-07-25	FGBX	Futures	128.89	128.95	126.62	128.03	9265.0
2012-07-25	FOAT	Futures	101.4	101.43	100.93	101.2	26555.0
2012-07-25	FTDX	Futures	695.1	704.9	695.1	702.6	48.0
2012-07-25	FTI	Futures	262.92	267.69	262.92	265.31	37251.0
2012-07-25	FTUK	Futures	3945.6	3991.8	3943.4	3967.4	77615.0
2012-07-25	FVSA	Futures	8230.87	8258.58	7829.02	7995.3	2984.0
2012-07-25	FXXP	Futures	178.9	179.8	178.6	178.8	2305.0
2012-07-25	G	Futures	100.75	101.03	100.54	100.89	134589.0
2012-07-25	GF	Futures	270.382	271.024	265.794	265.794	2833.0
2012-07-25	GSCI	Futures	1008.25	1012.87	995.68	1009.92	284.0
2012-07-25	HE	Futures	99.736	101.5	99.576	101.073	9514.0
2012-07-25	HG	Futures	4.3325	4.3853	4.2926	4.3473	55621.0
2012-07-25	HO	Futures	2.2983	2.3339	2.2825	2.3275	56660.0
2012-07-25	HRC	Futures	2450.1	2450.1	2450.1	2450.1	0.0
2012-07-25	J1	Futures	0.0160409	0.0160634	0.0160183	0.0160546	60982.0
2012-07-25	J7	Futures	0.015979	0.015998	0.015958	0.015992	239.0

> showing 50 of 98 rows — these rows as CSV

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