PREVIEW / futures_daily / 2012-08-20

all futures daily files

  file:    by_date/futures_daily/2012/2012-08-20.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-08-20	ES	Futures	1433.0	1436.04	1427.43	1432.75	1110701.0
2012-08-20	NQ	Futures	3184.76	3195.66	3175.86	3190.78	187197.0
2012-08-20	YM	Futures	12853.9	12872.3	12810.2	12834.4	68977.0
2012-08-20	CL	Futures	174.83	175.18	172.44	174.14	203176.0
2012-08-20	GC	Futures	2160.9	2169.2	2152.0	2166.9	69468.0
2012-08-20	ZN	Futures	115.500958	115.650765	115.201345	115.500958	674677.0
2012-08-20	A6	Futures	0.93578	0.93893	0.93443	0.93749	94955.0
2012-08-20	AD	Futures	1.01353	1.01464	1.01193	1.01393	53384.0
2012-08-20	B	Futures	103.35	104.14	102.47	103.23	162566.0
2012-08-20	B6	Futures	1.6404	1.6426	1.6383	1.6417	61311.0
2012-08-20	BFX	Futures	2862.1	2873.4	2846.2	2850.3	25.0
2012-08-20	BR	Futures	0.23601	0.23601	0.23601	0.23601	15.0
2012-08-20	BZ	Futures	109.32	109.66	108.02	108.79	3024.0
2012-08-20	C	Futures	1673.0	1673.0	1628.0	1634.0	1438.0
2012-08-20	CB	Futures	98.496	98.496	98.483	98.483	2.0
2012-08-20	CC	Futures	1842.0	1857.0	1797.0	1816.0	10135.0
2012-08-20	CSC	Futures	4.188	4.188	4.105	4.105	12.0
2012-08-20	CT	Futures	95.87	98.4	95.85	97.7	39.0
2012-08-20	DC	Futures	30.9	31.06	30.23	30.26	427.0
2012-08-20	DX	Futures	80.134	80.333	80.013	80.076	11077.0
2012-08-20	E1	Futures	1.32666	1.33028	1.3224	1.32783	26707.0
2012-08-20	E6	Futures	1.45587	1.45941	1.45068	1.45693	183922.0
2012-08-20	E7	Futures	1.4466	1.4503	1.4417	1.4479	2643.0
2012-08-20	ED	Futures	95.1728	95.1728	95.168	95.1704	49071.0
2012-08-20	ER	Futures	97.837	97.852	97.832	97.847	60118.0
2012-08-20	EW	Futures	989.0	991.0	982.3	986.5	12080.0
2012-08-20	FBTP	Futures	66.69	67.06	66.46	66.65	11580.0
2012-08-20	FBTS	Futures	87.097	87.403	86.923	87.188	2672.0
2012-08-20	FCE	Futures	2600.4	2609.0	2573.2	2590.0	79172.0
2012-08-20	FDAX	Futures	7693.8	7737.5	7653.4	7680.7	98075.0
2012-08-20	FESX	Futures	1673.2	1686.0	1656.3	1667.1	891026.0
2012-08-20	FGBL	Futures	117.16	117.43	116.58	117.29	573858.0
2012-08-20	FGBM	Futures	115.98	116.04	115.68	115.99	320397.0
2012-08-20	FGBS	Futures	110.492	110.497	110.437	110.467	287208.0
2012-08-20	FGBX	Futures	124.4	125.0	122.99	124.65	6652.0
2012-08-20	FOAT	Futures	102.62	102.64	102.27	102.55	16766.0
2012-08-20	FTDX	Futures	743.1	743.1	735.6	737.5	70.0
2012-08-20	FTI	Futures	285.84	286.39	283.54	284.13	21370.0
2012-08-20	FTUK	Futures	4255.4	4260.1	4218.6	4235.3	59569.0
2012-08-20	FVSA	Futures	6494.35	6558.4	6327.83	6430.3	9415.0
2012-08-20	FXXP	Futures	195.4	196.0	193.9	194.5	2052.0
2012-08-20	G	Futures	98.81	99.29	98.64	99.22	88967.0
2012-08-20	GF	Futures	280.733	281.619	279.551	281.324	725.0
2012-08-20	GSCI	Futures	1076.48	1078.66	1068.84	1078.01	266.0
2012-08-20	HE	Futures	94.481	94.481	93.585	93.801	8076.0
2012-08-20	HG	Futures	4.4053	4.4091	4.3205	4.3423	9038.0
2012-08-20	HO	Futures	2.5285	2.5403	2.5103	2.5246	7594.0
2012-08-20	HRC	Futures	2548.9	2548.9	2548.9	2548.9	0.0
2012-08-20	J1	Futures	0.0157514	0.0158015	0.0157351	0.0157865	59661.0
2012-08-20	J7	Futures	0.015697	0.01574	0.015675	0.015725	147.0

> showing 50 of 99 rows — these rows as CSV

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