PREVIEW / futures_daily / 2012-06-18

all futures daily files

  file:    by_date/futures_daily/2012/2012-06-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-06-18	ES	Futures	1362.36	1364.64	1344.13	1358.06	2074890.0
2012-06-18	NQ	Futures	2961.52	2977.87	2925.94	2969.84	215740.0
2012-06-18	YM	Futures	12396.9	12421.2	12244.6	12307.6	133894.0
2012-06-18	CL	Futures	155.93	156.64	150.2	152.46	176241.0
2012-06-18	GC	Futures	2179.0	2180.7	2148.1	2175.0	120675.0
2012-06-18	ZN	Futures	116.168279	116.781125	116.113804	116.563224	845967.0
2012-06-18	A6	Futures	0.90314	0.90449	0.89676	0.90278	154418.0
2012-06-18	AD	Futures	0.98015	0.98205	0.97353	0.97664	103961.0
2012-06-18	B	Futures	89.02	90.35	86.61	87.21	233812.0
2012-06-18	B6	Futures	1.643	1.6443	1.6336	1.637	93092.0
2012-06-18	BFX	Futures	2548.1	2548.1	2522.9	2529.2	41.0
2012-06-18	BR	Futures	0.22863	0.22863	0.22863	0.22863	36.0
2012-06-18	BZ	Futures	95.57	95.69	92.13	92.72	2225.0
2012-06-18	C	Futures	1584.0	1584.0	1525.0	1529.0	4266.0
2012-06-18	CB	Futures	83.964	85.04	83.964	83.964	13.0
2012-06-18	CC	Futures	1692.0	1707.0	1639.0	1649.0	14814.0
2012-06-18	CSC	Futures	3.704	3.717	3.704	3.717	2.0
2012-06-18	CT	Futures	97.93	101.51	97.84	101.51	11790.0
2012-06-18	DC	Futures	26.98	27.21	26.8	27.21	67.0
2012-06-18	DX	Futures	79.115	79.945	79.037	79.8	28001.0
2012-06-18	E1	Futures	1.37353	1.37353	1.35275	1.35559	47815.0
2012-06-18	E6	Futures	1.50447	1.50506	1.48241	1.48524	306255.0
2012-06-18	E7	Futures	1.4945	1.4986	1.4733	1.476	3264.0
2012-06-18	ED	Futures	95.1131	95.1226	95.0939	95.1035	270143.0
2012-06-18	ER	Futures	97.572	97.611	97.562	97.602	187015.0
2012-06-18	EW	Futures	934.6	940.4	920.4	938.2	24576.0
2012-06-18	FBTP	Futures	65.66	65.77	63.99	64.59	18602.0
2012-06-18	FBTS	Futures	83.558	83.955	82.88	83.343	3442.0
2012-06-18	FCE	Futures	2308.3	2318.0	2259.1	2269.8	156732.0
2012-06-18	FDAX	Futures	6902.2	6921.3	6796.9	6821.4	179923.0
2012-06-18	FESX	Futures	1486.5	1496.7	1446.6	1452.0	1589726.0
2012-06-18	FEU3	Futures	98.182	98.186	98.182	98.182	202.0
2012-06-18	FGBL	Futures	116.95	118.19	116.58	117.82	834088.0
2012-06-18	FGBM	Futures	115.21	115.79	115.14	115.69	413237.0
2012-06-18	FGBS	Futures	110.208	110.368	110.193	110.338	330126.0
2012-06-18	FGBX	Futures	125.96	129.36	125.87	127.65	8782.0
2012-06-18	FOAT	Futures	98.55	98.71	98.34	98.49	10134.0
2012-06-18	FTDX	Futures	682.6	683.0	677.0	679.8	99.0
2012-06-18	FTI	Futures	256.12	257.31	251.61	252.42	42523.0
2012-06-18	FTUK	Futures	3999.8	4022.4	3940.8	3966.3	123397.0
2012-06-18	FVSA	Futures	9677.27	9858.15	9466.24	9511.46	8257.0
2012-06-18	FXXP	Futures	176.3	176.4	173.7	174.3	2417.0
2012-06-18	G	Futures	98.5	99.41	98.49	98.9	128475.0
2012-06-18	GF	Futures	307.93	311.137	306.203	308.127	3628.0
2012-06-18	GSCI	Futures	915.8	924.84	910.81	920.56	117.0
2012-06-18	HE	Futures	98.661	100.951	98.661	100.477	19885.0
2012-06-18	HG	Futures	4.431	4.4845	4.348	4.3834	22579.0
2012-06-18	HO	Futures	2.183	2.1958	2.1349	2.148	17874.0
2012-06-18	HRC	Futures	2470.4	2470.4	2470.4	2470.4	0.0
2012-06-18	J1	Futures	0.0158905	0.0159118	0.015819	0.0158579	65219.0

> showing 50 of 99 rows — these rows as CSV

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