PREVIEW / futures_daily / 2011-06-09

all futures daily files

  file:    by_date/futures_daily/2011/2011-06-09.parquet
  size:    9 KB
  rows:    93

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
2011-06-09	ES	Futures	1264.98	1281.07	1262.51	1274.64	1725026.0
2011-06-09	NQ	Futures	2563.35	2582.42	2557.37	2565.34	186589.0
2011-06-09	YM	Futures	11315.0	11445.7	11297.2	11388.4	94138.0
2011-06-09	CL	Futures	193.71	196.8	193.53	195.82	345542.0
2011-06-09	GC	Futures	2082.0	2098.9	2076.1	2087.9	108430.0
2011-06-09	ZN	Futures	105.455211	105.601566	104.843183	104.962927	1670912.0
2011-06-09	A6	Futures	0.91102	0.91437	0.90485	0.91265	106909.0
2011-06-09	AD	Futures	1.01654	1.0239	1.01455	1.02251	75341.0
2011-06-09	B	Futures	100.42	102.16	100.1	101.91	145493.0
2011-06-09	B6	Futures	1.7034	1.7108	1.6994	1.7001	110422.0
2011-06-09	BFX	Futures	3086.7	3096.9	3078.3	3096.5	43.0
2011-06-09	BR	Futures	0.27682	0.27693	0.27613	0.27613	45.0
2011-06-09	BZ	Futures	104.96	106.28	104.92	106.27	456.0
2011-06-09	C	Futures	1972.0	2000.0	1972.0	1990.0	4949.0
2011-06-09	CB	Futures	115.066	117.806	115.066	117.806	35.0
2011-06-09	CC	Futures	2322.0	2418.0	2321.0	2354.0	14569.0
2011-06-09	CT	Futures	144.56	149.5	143.87	149.5	10171.0
2011-06-09	DC	Futures	30.65	30.77	30.32	30.64	285.0
2011-06-09	DX	Futures	73.506	73.949	73.327	73.831	38462.0
2011-06-09	E1	Futures	1.5659	1.56721	1.55006	1.5549	49751.0
2011-06-09	E6	Futures	1.72664	1.73635	1.71467	1.71858	357202.0
2011-06-09	E7	Futures	1.7133	1.7228	1.702	1.7058	5104.0
2011-06-09	ED	Futures	94.9716	94.974	94.9692	94.9716	113190.0
2011-06-09	ER	Futures	97.306	97.316	97.286	97.311	249058.0
2011-06-09	EW	Futures	934.8	943.8	932.5	938.6	37365.0
2011-06-09	FBTP	Futures	65.19	65.19	64.87	64.95	5626.0
2011-06-09	FCE	Futures	2651.7	2699.9	2646.1	2685.3	148597.0
2011-06-09	FDAX	Futures	7528.2	7680.4	7512.7	7641.9	154602.0
2011-06-09	FESX	Futures	1757.5	1787.6	1753.6	1776.7	1366566.0
2011-06-09	FEU3	Futures	97.85	97.855	97.85	97.855	299.0
2011-06-09	FGBL	Futures	100.22	100.63	100.04	100.42	1036608.0
2011-06-09	FGBM	Futures	104.68	105.03	104.49	104.86	696503.0
2011-06-09	FGBS	Futures	106.806	106.935	106.667	106.886	893825.0
2011-06-09	FGBX	Futures	95.87	96.41	95.45	96.03	5955.0
2011-06-09	FTDX	Futures	788.6	796.2	787.7	794.4	354.0
2011-06-09	FTI	Futures	274.55	278.32	273.81	277.09	37162.0
2011-06-09	FTUK	Futures	4058.1	4119.6	4055.3	4097.3	99768.0
2011-06-09	FXXP	Futures	180.7	181.9	179.5	181.6	18152.0
2011-06-09	G	Futures	84.17	84.48	84.02	84.27	105566.0
2011-06-09	GF	Futures	291.317	292.595	287.598	291.258	3160.0
2011-06-09	GSCI	Futures	1107.09	1115.7	1104.35	1113.66	2181.0
2011-06-09	HE	Futures	97.997	100.051	97.651	99.198	26618.0
2011-06-09	HG	Futures	5.4597	5.4717	5.374	5.457	37585.0
2011-06-09	HO	Futures	2.5291	2.5697	2.5159	2.5646	16637.0
2011-06-09	HRC	Futures	3118.0	3118.0	3118.0	3118.0	0.0
2011-06-09	J1	Futures	0.0157202	0.0157353	0.0156209	0.0156435	126139.0
2011-06-09	J7	Futures	0.015631	0.015639	0.015524	0.015548	1497.0
2011-06-09	KC	Futures	634.99	644.34	634.03	639.78	10200.0
2011-06-09	KE	Futures	3507.31	3591.24	3441.15	3441.15	14549.0
2011-06-09	L	Futures	98.433	98.453	98.433	98.453	31555.0

> showing 50 of 93 rows — these rows as CSV

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