PREVIEW / futures_daily / 2012-07-18

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-18.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-18	ES	Futures	1375.78	1387.93	1369.7	1384.64	1797575.0
2012-07-18	NQ	Futures	2970.12	3016.9	2957.5	3007.14	244551.0
2012-07-18	YM	Futures	12359.1	12483.2	12307.6	12476.5	107062.0
2012-07-18	CL	Futures	162.42	164.0	161.37	163.65	152538.0
2012-07-18	GC	Futures	2116.1	2119.8	2095.0	2099.8	133067.0
2012-07-18	ZN	Futures	117.257782	117.502921	117.189688	117.448445	574572.0
2012-07-18	A6	Futures	0.92157	0.92751	0.91996	0.92571	121360.0
2012-07-18	AD	Futures	0.98897	0.99138	0.98656	0.99017	76837.0
2012-07-18	B	Futures	93.05	94.86	92.73	94.47	205837.0
2012-07-18	B6	Futures	1.6351	1.6374	1.6281	1.6344	82754.0
2012-07-18	BFX	Futures	2669.8	2711.1	2669.8	2709.9	1188.0
2012-07-18	BR	Futures	0.23377	0.2346	0.23358	0.23382	36.0
2012-07-18	BZ	Futures	100.01	101.48	100.0	101.22	725.0
2012-07-18	C	Futures	1530.0	1534.0	1514.0	1528.0	3197.0
2012-07-18	CB	Futures	87.866	87.879	87.866	87.866	1.0
2012-07-18	CC	Futures	1663.0	1671.0	1634.0	1661.0	6778.0
2012-07-18	CSC	Futures	4.105	4.105	4.049	4.049	30.0
2012-07-18	CT	Futures	92.21	94.71	91.84	93.66	98.0
2012-07-18	DC	Futures	30.2	30.38	29.74	29.84	304.0
2012-07-18	DX	Futures	80.678	81.008	80.605	80.751	14570.0
2012-07-18	E1	Futures	1.32227	1.32447	1.31517	1.31995	32404.0
2012-07-18	E6	Futures	1.45091	1.45292	1.44207	1.44761	214863.0
2012-07-18	E7	Futures	1.4414	1.4437	1.4331	1.4386	2844.0
2012-07-18	ED	Futures	95.1704	95.1847	95.1656	95.1752	120420.0
2012-07-18	ER	Futures	97.729	97.749	97.719	97.739	60695.0
2012-07-18	EW	Futures	953.9	962.9	949.2	959.3	17524.0
2012-07-18	FBTP	Futures	64.78	65.54	64.72	64.89	18456.0
2012-07-18	FBTS	Futures	85.021	85.22	84.806	84.873	2921.0
2012-07-18	FCE	Futures	2371.1	2416.9	2371.1	2408.3	141560.0
2012-07-18	FDAX	Futures	7194.8	7313.3	7183.4	7294.7	119164.0
2012-07-18	FESX	Futures	1525.1	1548.1	1521.7	1541.3	1004257.0
2012-07-18	FEU3	Futures	98.305	98.32	98.305	98.32	300.0
2012-07-18	FGBL	Futures	119.82	120.18	119.63	120.05	491475.0
2012-07-18	FGBM	Futures	116.83	116.99	116.68	116.94	286474.0
2012-07-18	FGBS	Futures	110.542	110.577	110.492	110.557	305445.0
2012-07-18	FGBX	Futures	128.84	130.04	128.69	129.7	5895.0
2012-07-18	FOAT	Futures	102.73	102.88	102.23	102.49	18548.0
2012-07-18	FTDX	Futures	705.4	712.4	691.4	711.0	66.0
2012-07-18	FTI	Futures	268.29	270.89	267.44	270.29	34543.0
2012-07-18	FTUK	Futures	4083.9	4115.9	4062.4	4102.8	83774.0
2012-07-18	FVSA	Futures	6983.77	6983.77	6498.78	6540.35	8449.0
2012-07-18	FXXP	Futures	183.4	185.2	183.1	184.9	1099.0
2012-07-18	G	Futures	100.26	100.78	100.24	100.6	121404.0
2012-07-18	GF	Futures	265.004	270.777	264.166	270.777	5028.0
2012-07-18	GSCI	Futures	1004.67	1018.68	1003.32	1017.48	50.0
2012-07-18	HE	Futures	96.449	99.362	94.766	99.015	23782.0
2012-07-18	HG	Futures	4.4684	4.4877	4.4252	4.4755	32723.0
2012-07-18	HO	Futures	2.3175	2.3592	2.3119	2.3523	30050.0
2012-07-18	HRC	Futures	2450.1	2450.1	2450.1	2450.1	0.0
2012-07-18	J1	Futures	0.0158591	0.0159231	0.0158429	0.0159155	50201.0

> showing 50 of 99 rows — these rows as CSV

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