PREVIEW / futures_daily / 2012-06-07

all futures daily files

  file:    by_date/futures_daily/2012/2012-06-07.parquet
  size:    9 KB
  rows:    100

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-07	ES	Futures	1325.4	1339.76	1322.12	1326.91	2584043.0
2012-06-07	NQ	Futures	2922.73	2945.07	2900.96	2905.83	274330.0
2012-06-07	YM	Futures	12079.3	12202.8	12067.6	12135.7	151818.0
2012-06-07	CL	Futures	156.69	159.5	152.9	155.45	339002.0
2012-06-07	GC	Futures	2167.5	2179.9	2111.3	2122.8	254777.0
2012-06-07	ZN	Futures	116.223562	116.480784	116.155873	116.358942	24208.0
2012-06-07	A6	Futures	0.89163	0.89919	0.88767	0.89415	212468.0
2012-06-07	AD	Futures	0.97885	0.98509	0.97694	0.98156	125074.0
2012-06-07	B	Futures	91.16	92.57	89.56	90.33	165665.0
2012-06-07	B6	Futures	1.6258	1.6408	1.6194	1.6324	130722.0
2012-06-07	BFX	Futures	2564.9	2573.1	2563.4	2568.1	3.0
2012-06-07	BR	Futures	0.23191	0.23191	0.2315	0.2315	2.0
2012-06-07	BZ	Futures	96.67	98.4	95.72	96.03	3322.0
2012-06-07	C	Futures	1529.0	1535.0	1519.0	1520.0	5072.0
2012-06-07	CB	Futures	80.734	80.734	80.734	80.734	1.0
2012-06-07	CC	Futures	1647.0	1680.0	1642.0	1664.0	15946.0
2012-06-07	CSC	Futures	3.628	3.658	3.628	3.638	47.0
2012-06-07	CT	Futures	86.44	90.39	86.16	90.39	21428.0
2012-06-07	DC	Futures	26.04	26.29	25.96	26.25	110.0
2012-06-07	DX	Futures	79.691	79.89	79.41	79.551	27250.0
2012-06-07	E1	Futures	1.37158	1.37629	1.36699	1.37393	52040.0
2012-06-07	E6	Futures	1.50126	1.50735	1.49697	1.50449	336903.0
2012-06-07	E7	Futures	1.4867	1.4928	1.4828	1.4901	3973.0
2012-06-07	ED	Futures	95.0717	95.074	95.0693	95.0693	103778.0
2012-06-07	ER	Futures	97.538	97.543	97.528	97.528	54958.0
2012-06-07	EW	Futures	932.6	945.7	926.9	930.7	55117.0
2012-06-07	FBTP	Futures	66.33	67.12	65.77	66.34	26650.0
2012-06-07	FBTS	Futures	84.327	85.228	84.327	84.748	4424.0
2012-06-07	FCE	Futures	2265.3	2281.1	2242.4	2255.0	168317.0
2012-06-07	FDAX	Futures	6794.1	6889.7	6742.1	6785.8	194636.0
2012-06-07	FESX	Futures	1483.2	1497.0	1468.7	1474.3	1766383.0
2012-06-07	FEU3	Futures	98.108	98.108	98.103	98.103	2.0
2012-06-07	FGBL	Futures	118.53	118.68	117.74	118.16	1125471.0
2012-06-07	FGBM	Futures	115.77	115.84	115.43	115.64	596971.0
2012-06-07	FGBS	Futures	110.288	110.308	110.228	110.258	477962.0
2012-06-07	FGBX	Futures	131.32	131.41	128.88	129.36	9104.0
2012-06-07	FOAT	Futures	99.87	99.96	98.36	98.82	37652.0
2012-06-07	FTDX	Futures	690.9	701.2	685.3	700.3	150.0
2012-06-07	FTI	Futures	254.1	256.14	252.28	253.88	37903.0
2012-06-07	FTUK	Futures	3950.7	4010.1	3933.9	3969.6	149265.0
2012-06-07	FVSA	Futures	9929.58	10132.86	9820.12	10117.22	3514.0
2012-06-07	FXXP	Futures	174.5	177.0	174.5	175.8	5700.0
2012-06-07	G	Futures	99.02	99.31	98.02	98.36	176626.0
2012-06-07	GF	Futures	312.667	314.492	311.187	313.999	2589.0
2012-06-07	GSCI	Futures	944.18	956.64	935.53	941.96	1614.0
2012-06-07	HE	Futures	97.267	98.53	97.135	98.24	23597.0
2012-06-07	HG	Futures	4.418	4.4926	4.361	4.414	89121.0
2012-06-07	HO	Futures	2.2069	2.2337	2.1775	2.1932	26001.0
2012-06-07	HRC	Futures	2502.2	2502.2	2502.2	2502.2	0.0
2012-06-07	J1	Futures	0.0158216	0.0158303	0.0157137	0.0157363	102131.0

> showing 50 of 100 rows — these rows as CSV

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