PREVIEW / futures_daily / 2012-07-17

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-17.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-17	ES	Futures	1364.39	1377.81	1356.29	1375.78	1970476.0
2012-07-17	NQ	Futures	2951.76	2977.3	2924.5	2969.26	269331.0
2012-07-17	YM	Futures	12272.7	12385.3	12202.9	12357.1	128911.0
2012-07-17	CL	Futures	161.08	162.98	159.33	162.51	149326.0
2012-07-17	GC	Futures	2123.6	2137.3	2100.1	2124.8	141888.0
2012-07-17	ZN	Futures	117.421208	117.543777	117.216926	117.271401	729795.0
2012-07-17	A6	Futures	0.91591	0.92274	0.9151	0.9222	148608.0
2012-07-17	AD	Futures	0.98646	0.98937	0.98436	0.98877	90170.0
2012-07-17	B	Futures	92.82	94.1	92.32	93.43	194857.0
2012-07-17	B6	Futures	1.6335	1.6383	1.6254	1.635	90736.0
2012-07-17	BFX	Futures	2676.6	2682.2	2665.4	2669.6	1157.0
2012-07-17	BR	Futures	0.23391	0.23391	0.23391	0.23391	41.0
2012-07-17	BZ	Futures	99.87	100.77	98.97	100.1	590.0
2012-07-17	C	Futures	1532.0	1545.0	1514.0	1528.0	6370.0
2012-07-17	CB	Futures	87.731	88.539	87.731	88.539	8.0
2012-07-17	CC	Futures	1664.0	1673.0	1627.0	1654.0	10277.0
2012-07-17	CSC	Futures	4.112	4.132	4.105	4.105	9.0
2012-07-17	CT	Futures	94.56	94.61	92.22	92.36	82.0
2012-07-17	DC	Futures	30.6	30.82	30.11	30.28	335.0
2012-07-17	DX	Futures	80.813	81.231	80.59	80.724	19750.0
2012-07-17	E1	Futures	1.32111	1.32576	1.31207	1.32214	41058.0
2012-07-17	E6	Futures	1.44867	1.4541	1.43876	1.45056	264786.0
2012-07-17	E7	Futures	1.4398	1.4451	1.4299	1.4415	4380.0
2012-07-17	ED	Futures	95.1847	95.1943	95.1656	95.1752	187368.0
2012-07-17	ER	Futures	97.734	97.744	97.724	97.729	76950.0
2012-07-17	EW	Futures	947.1	954.3	938.1	953.7	23941.0
2012-07-17	FBTP	Futures	64.58	65.5	64.44	64.91	18054.0
2012-07-17	FBTS	Futures	84.715	85.129	84.6	84.873	2641.0
2012-07-17	FCE	Futures	2373.7	2385.2	2356.9	2364.8	106570.0
2012-07-17	FDAX	Futures	7191.0	7238.5	7142.4	7170.8	116692.0
2012-07-17	FESX	Futures	1527.1	1535.2	1514.2	1517.6	842561.0
2012-07-17	FGBL	Futures	119.63	119.99	119.45	119.87	544260.0
2012-07-17	FGBM	Futures	116.77	116.88	116.64	116.84	318927.0
2012-07-17	FGBS	Futures	110.532	110.547	110.497	110.537	203034.0
2012-07-17	FGBX	Futures	128.33	129.33	128.18	129.18	6042.0
2012-07-17	FOAT	Futures	102.13	102.88	102.13	102.7	14179.0
2012-07-17	FTDX	Futures	707.7	707.7	699.3	701.2	47.0
2012-07-17	FTI	Futures	266.75	268.8	266.33	266.88	21735.0
2012-07-17	FTUK	Futures	4080.3	4103.9	4058.8	4061.7	78297.0
2012-07-17	FVSA	Futures	6928.34	7053.05	6817.49	6983.77	6697.0
2012-07-17	FXXP	Futures	183.6	184.0	182.6	182.7	1344.0
2012-07-17	G	Futures	100.36	100.5	100.13	100.41	104060.0
2012-07-17	GF	Futures	264.511	266.337	262.488	264.856	6674.0
2012-07-17	GSCI	Futures	1008.65	1010.72	997.43	1005.94	452.0
2012-07-17	HE	Futures	96.556	97.171	96.075	96.155	16345.0
2012-07-17	HG	Futures	4.4929	4.5251	4.422	4.4517	45445.0
2012-07-17	HO	Futures	2.3121	2.3353	2.3043	2.3238	29430.0
2012-07-17	HRC	Futures	2450.1	2450.1	2450.1	2450.1	0.0
2012-07-17	J1	Futures	0.0158967	0.0159168	0.0158391	0.0158541	65872.0
2012-07-17	J7	Futures	0.015843	0.015851	0.015777	0.015792	239.0

> showing 50 of 98 rows — these rows as CSV

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