PREVIEW / futures_daily / 2012-06-28

all futures daily files

  file:    by_date/futures_daily/2012/2012-06-28.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-06-28	ES	Futures	1342.61	1344.64	1323.37	1339.32	2291307.0
2012-06-28	NQ	Futures	2937.13	2943.73	2873.42	2901.26	264989.0
2012-06-28	YM	Futures	12180.6	12195.1	12006.9	12152.4	175593.0
2012-06-28	CL	Futures	146.77	147.43	140.94	141.68	310148.0
2012-06-28	GC	Futures	2104.9	2111.6	2068.8	2072.6	139961.0
2012-06-28	ZN	Futures	116.38618	116.8356	116.290848	116.72665	1013726.0
2012-06-28	A6	Futures	0.89981	0.90404	0.89235	0.89361	144154.0
2012-06-28	AD	Futures	0.97604	0.97814	0.96571	0.96661	126628.0
2012-06-28	B	Futures	84.19	84.42	81.74	82.15	135409.0
2012-06-28	B6	Futures	1.6268	1.6326	1.618	1.6192	101609.0
2012-06-28	BFX	Futures	2556.5	2570.8	2556.5	2570.8	6.0
2012-06-28	BR	Futures	0.22668	0.22668	0.22668	0.22668	367.0
2012-06-28	BZ	Futures	89.03	89.03	87.83	88.02	2081.0
2012-06-28	C	Futures	1560.0	1590.0	1549.0	1586.0	2852.0
2012-06-28	CC	Futures	1678.0	1695.0	1664.0	1680.0	12626.0
2012-06-28	CSC	Futures	3.851	3.851	3.845	3.845	2.0
2012-06-28	CT	Futures	90.17	91.57	87.86	91.57	130.0
2012-06-28	DC	Futures	28.02	28.26	27.9	28.12	166.0
2012-06-28	DX	Futures	80.323	80.629	79.988	80.568	31155.0
2012-06-28	E1	Futures	1.34293	1.34887	1.33673	1.33867	41376.0
2012-06-28	E6	Futures	1.47203	1.47864	1.46472	1.46696	278698.0
2012-06-28	E7	Futures	1.4629	1.4693	1.4555	1.4578	3128.0
2012-06-28	ED	Futures	95.1322	95.1369	95.1035	95.1083	209572.0
2012-06-28	ER	Futures	97.611	97.631	97.592	97.602	171931.0
2012-06-28	EW	Futures	922.7	926.9	911.0	925.1	32488.0
2012-06-28	FBTP	Futures	64.09	64.29	63.63	64.01	33494.0
2012-06-28	FBTS	Futures	83.186	83.922	83.086	83.665	7963.0
2012-06-28	FCE	Futures	2277.2	2277.2	2233.9	2258.7	120795.0
2012-06-28	FDAX	Futures	6823.6	6823.6	6657.7	6715.5	167347.0
2012-06-28	FESX	Futures	1466.2	1466.2	1437.8	1454.1	1208403.0
2012-06-28	FEU3	Futures	98.182	98.182	98.182	98.182	100.0
2012-06-28	FGBL	Futures	116.69	117.3	116.55	117.05	689929.0
2012-06-28	FGBM	Futures	115.03	115.38	114.96	115.26	401571.0
2012-06-28	FGBS	Futures	110.148	110.228	110.148	110.183	258268.0
2012-06-28	FGBX	Futures	124.21	125.27	123.76	124.12	7811.0
2012-06-28	FOAT	Futures	98.31	98.52	98.08	98.11	15163.0
2012-06-28	FTDX	Futures	676.1	677.5	669.1	673.3	68.0
2012-06-28	FTI	Futures	253.91	254.33	250.29	252.84	38891.0
2012-06-28	FTUK	Futures	3999.5	4004.2	3925.6	3964.5	108380.0
2012-06-28	FVSA	Futures	8576.9	8787.93	8516.6	8622.12	3231.0
2012-06-28	FXXP	Futures	176.2	176.2	173.4	174.5	4457.0
2012-06-28	G	Futures	99.12	99.43	98.99	99.26	123440.0
2012-06-28	GF	Futures	294.46	297.815	291.944	296.927	5242.0
2012-06-28	GSCI	Futures	917.39	917.79	895.84	899.17	233.0
2012-06-28	HE	Futures	100.425	102.161	100.346	101.819	12346.0
2012-06-28	HG	Futures	4.3151	4.3383	4.2719	4.2919	47891.0
2012-06-28	HO	Futures	2.1196	2.1283	2.0739	2.0849	21198.0
2012-06-28	HRC	Futures	2429.9	2429.9	2429.9	2429.9	0.0
2012-06-28	J1	Futures	0.0157413	0.0158366	0.0157301	0.0157977	65699.0
2012-06-28	J7	Futures	0.015676	0.015772	0.01567	0.015736	256.0

> showing 50 of 98 rows — these rows as CSV

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