PREVIEW / futures_daily / 2012-01-18

all futures daily files

  file:    by_date/futures_daily/2012/2012-01-18.parquet
  size:    9 KB
  rows:    97

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-01-18	ES	Futures	1293.6	1308.9	1291.09	1306.89	2008751.0
2012-01-18	NQ	Futures	2733.48	2770.93	2730.62	2768.08	214767.0
2012-01-18	YM	Futures	12007.2	12116.5	11988.8	12092.3	99402.0
2012-01-18	CL	Futures	189.06	191.08	186.89	188.31	192482.0
2012-01-18	GC	Futures	2229.8	2245.2	2217.1	2241.1	157218.0
2012-01-18	ZN	Futures	113.691854	113.813377	113.381294	113.435305	869777.0
2012-01-18	A6	Futures	0.91672	0.92259	0.91547	0.92081	127540.0
2012-01-18	AD	Futures	0.98686	0.99148	0.98475	0.99007	65125.0
2012-01-18	B	Futures	99.33	99.99	98.33	98.62	206128.0
2012-01-18	B6	Futures	1.6019	1.6136	1.6014	1.6116	88968.0
2012-01-18	BFX	Futures	2593.3	2599.7	2575.2	2589.7	224.0
2012-01-18	BR	Futures	0.26213	0.26274	0.26204	0.26274	187.0
2012-01-18	BZ	Futures	105.31	105.31	104.39	104.66	911.0
2012-01-18	C	Futures	1541.0	1544.0	1519.0	1532.0	4418.0
2012-01-18	CB	Futures	87.866	87.866	87.341	87.341	183.0
2012-01-18	CC	Futures	1768.0	1782.0	1751.0	1756.0	7759.0
2012-01-18	CSC	Futures	3.976	3.976	3.883	3.883	61.0
2012-01-18	CT	Futures	126.42	126.42	123.39	125.61	12444.0
2012-01-18	DC	Futures	28.98	29.0	27.96	27.99	685.0
2012-01-18	DX	Futures	79.111	79.204	78.512	78.665	22173.0
2012-01-18	E1	Futures	1.38377	1.40044	1.38325	1.39611	35037.0
2012-01-18	E6	Futures	1.52293	1.53859	1.52234	1.53477	353752.0
2012-01-18	E7	Futures	1.5093	1.5244	1.5087	1.5207	4542.0
2012-01-18	EBM	Futures	261.42	261.42	257.49	258.8	12092.0
2012-01-18	ED	Futures	95.0725	95.0772	95.039	95.0486	244846.0
2012-01-18	ER	Futures	97.381	97.4	97.376	97.381	104043.0
2012-01-18	EW	Futures	914.0	928.8	911.1	927.0	20655.0
2012-01-18	FBTP	Futures	60.21	60.82	59.82	60.67	11675.0
2012-01-18	FBTS	Futures	82.008	82.169	81.751	82.064	1808.0
2012-01-18	FCE	Futures	2321.0	2352.3	2305.3	2324.6	126339.0
2012-01-18	FDAX	Futures	6979.3	7072.0	6941.2	7021.8	163493.0
2012-01-18	FESX	Futures	1593.2	1618.6	1583.8	1595.2	1236698.0
2012-01-18	FGBL	Futures	113.08	113.3	112.79	113.19	623983.0
2012-01-18	FGBM	Futures	113.49	113.58	113.34	113.49	338344.0
2012-01-18	FGBS	Futures	109.904	109.914	109.849	109.864	379902.0
2012-01-18	FGBX	Futures	118.9	119.23	118.31	118.81	3521.0
2012-01-18	FTDX	Futures	678.1	693.0	677.2	689.3	158.0
2012-01-18	FTI	Futures	262.94	265.07	260.84	263.23	28942.0
2012-01-18	FTUK	Futures	4063.3	4095.4	4043.1	4077.4	105790.0
2012-01-18	FVSA	Futures	11523.78	11677.43	11254.89	11370.13	1792.0
2012-01-18	FXXP	Futures	177.6	179.2	177.1	178.5	2034.0
2012-01-18	G	Futures	95.11	95.51	94.98	95.17	130763.0
2012-01-18	GF	Futures	323.833	324.469	322.72	323.992	1701.0
2012-01-18	GSCI	Futures	1034.1	1035.03	1024.94	1027.45	202.0
2012-01-18	HE	Futures	105.743	106.649	105.622	106.256	10752.0
2012-01-18	HG	Futures	4.9113	4.9759	4.8743	4.9495	45255.0
2012-01-18	HO	Futures	2.4563	2.4787	2.4211	2.4369	66805.0
2012-01-18	HRC	Futures	2876.8	2876.8	2876.8	2876.8	0.0
2012-01-18	J1	Futures	0.0163511	0.0163925	0.0163435	0.0163636	59439.0
2012-01-18	J7	Futures	0.016293	0.016322	0.016278	0.016296	473.0

> showing 50 of 97 rows — these rows as CSV

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