PREVIEW / futures_daily / 2011-07-19

all futures daily files

  file:    by_date/futures_daily/2011/2011-07-19.parquet
  size:    9 KB
  rows:    95

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-07-19	ES	Futures	1292.56	1315.16	1291.32	1312.18	2098625.0
2011-07-19	NQ	Futures	2666.69	2732.73	2663.55	2720.49	275586.0
2011-07-19	YM	Futures	11679.5	11866.7	11660.6	11824.2	115653.0
2011-07-19	CL	Futures	184.84	189.69	184.46	187.54	294707.0
2011-07-19	GC	Futures	2173.7	2180.0	2142.1	2167.0	194070.0
2011-07-19	ZN	Futures	106.25351	106.519609	105.9608	106.373254	1105143.0
2011-07-19	A6	Futures	0.91561	0.92718	0.91517	0.9257	116843.0
2011-07-19	AD	Futures	1.03858	1.05096	1.03788	1.04866	89559.0
2011-07-19	B	Futures	99.32	100.99	98.98	99.8	181899.0
2011-07-19	B6	Futures	1.6687	1.6819	1.6682	1.6756	107391.0
2011-07-19	BFX	Futures	2872.0	2901.0	2872.0	2893.6	106.0
2011-07-19	BR	Futures	0.28129	0.28183	0.28129	0.28183	144.0
2011-07-19	BZ	Futures	102.91	104.81	102.91	103.65	484.0
2011-07-19	C	Futures	2156.0	2175.0	2134.0	2158.0	3996.0
2011-07-19	CB	Futures	111.231	111.779	111.231	111.779	10.0
2011-07-19	CC	Futures	2513.0	2537.0	2484.0	2508.0	7195.0
2011-07-19	CT	Futures	127.89	132.3	127.89	132.3	63.0
2011-07-19	DC	Futures	33.53	33.56	33.23	33.31	565.0
2011-07-19	DX	Futures	74.9	75.088	74.455	74.784	26039.0
2011-07-19	E1	Futures	1.59989	1.60513	1.58041	1.58799	46208.0
2011-07-19	E6	Futures	1.67202	1.68568	1.66787	1.67559	372547.0
2011-07-19	E7	Futures	1.6595	1.6731	1.6558	1.6633	6034.0
2011-07-19	ED	Futures	94.8906	94.9096	94.881	94.8953	206296.0
2011-07-19	ER	Futures	97.366	97.375	97.356	97.361	115490.0
2011-07-19	EW	Futures	954.0	971.9	953.3	968.8	17013.0
2011-07-19	FBTP	Futures	59.87	60.75	59.61	60.6	12392.0
2011-07-19	FCE	Futures	2583.3	2621.4	2578.0	2608.4	144143.0
2011-07-19	FDAX	Futures	7644.1	7753.6	7640.9	7701.8	146117.0
2011-07-19	FESX	Futures	1690.1	1716.4	1685.6	1704.9	1430091.0
2011-07-19	FEU3	Futures	97.905	97.905	97.9	97.9	14.0
2011-07-19	FGBL	Futures	103.81	103.91	103.18	103.52	900331.0
2011-07-19	FGBM	Futures	107.07	107.14	106.7	106.9	490347.0
2011-07-19	FGBS	Futures	107.811	107.84	107.651	107.711	641969.0
2011-07-19	FGBX	Futures	100.92	100.92	99.37	99.88	4619.0
2011-07-19	FTDX	Futures	727.4	754.2	727.4	749.3	754.0
2011-07-19	FTI	Futures	267.4	270.79	267.15	269.1	35604.0
2011-07-19	FTUK	Futures	4045.0	4076.1	4038.3	4056.3	102561.0
2011-07-19	FXXP	Futures	177.4	179.0	177.4	178.5	856.0
2011-07-19	G	Futures	86.17	86.28	85.92	86.14	120909.0
2011-07-19	GF	Futures	313.162	319.728	313.162	315.08	2928.0
2011-07-19	GSCI	Futures	1110.31	1122.56	1109.98	1109.98	93.0
2011-07-19	HE	Futures	108.732	110.523	108.677	109.779	12229.0
2011-07-19	HG	Futures	5.8324	5.9435	5.8225	5.9065	32411.0
2011-07-19	HO	Futures	2.5092	2.545	2.5049	2.5185	22797.0
2011-07-19	HRC	Futures	2989.2	2989.2	2989.2	2989.2	0.0
2011-07-19	J1	Futures	0.0159075	0.015954	0.015861	0.0158786	100662.0
2011-07-19	J7	Futures	0.015806	0.015845	0.015756	0.015772	279.0
2011-07-19	JB	Futures	123.46	123.55	123.35	123.35	1446.0
2011-07-19	KC	Futures	591.2	598.3	575.0	576.89	12135.0
2011-07-19	KE	Futures	2937.41	3060.32	2934.53	2988.3	12605.0

> showing 50 of 95 rows — these rows as CSV

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