PREVIEW / futures_daily / 2012-09-17

all futures daily files

  file:    by_date/futures_daily/2012/2012-09-17.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-09-17	ES	Futures	1484.69	1484.95	1476.3	1479.86	1573731.0
2012-09-17	NQ	Futures	3281.83	3282.12	3267.74	3274.93	230849.0
2012-09-17	YM	Futures	13192.4	13201.2	13138.7	13153.3	95250.0
2012-09-17	CL	Futures	179.58	180.14	171.42	174.98	171494.0
2012-09-17	GC	Futures	2367.9	2375.1	2344.8	2364.0	118555.0
2012-09-17	ZN	Futures	115.873645	116.203261	115.791241	116.052187	741795.0
2012-09-17	A6	Futures	0.9517	0.9518	0.94225	0.9428	98034.0
2012-09-17	AD	Futures	1.03189	1.03319	1.02617	1.02657	82609.0
2012-09-17	B	Futures	106.38	106.7	101.67	103.76	212968.0
2012-09-17	B6	Futures	1.6943	1.699	1.6924	1.6954	96044.0
2012-09-17	BFX	Futures	2946.0	2947.2	2944.3	2944.3	589.0
2012-09-17	BR	Futures	0.2383	0.2383	0.23631	0.2368	139.0
2012-09-17	BZ	Futures	111.16	111.42	106.6	108.74	336.0
2012-09-17	C	Futures	1709.0	1723.0	1662.0	1686.0	6825.0
2012-09-17	CB	Futures	98.349	98.349	98.349	98.349	1.0
2012-09-17	CC	Futures	1992.0	1998.0	1924.0	1949.0	16070.0
2012-09-17	CSC	Futures	4.065	4.065	4.061	4.065	2.0
2012-09-17	CT	Futures	98.4	100.04	97.99	98.18	65.0
2012-09-17	DC	Futures	30.86	30.86	30.56	30.68	41.0
2012-09-17	DX	Futures	76.482	76.69	76.36	76.632	15728.0
2012-09-17	E1	Futures	1.39127	1.39385	1.38625	1.38895	31250.0
2012-09-17	E6	Futures	1.54675	1.55241	1.54181	1.54452	235533.0
2012-09-17	E7	Futures	1.5367	1.543	1.5327	1.5353	3936.0
2012-09-17	ED	Futures	95.2253	95.2349	95.2205	95.2253	139565.0
2012-09-17	ER	Futures	97.837	97.852	97.832	97.847	120087.0
2012-09-17	EW	Futures	1044.4	1044.4	1032.0	1032.9	39534.0
2012-09-17	FBTP	Futures	71.11	71.34	70.62	70.76	15431.0
2012-09-17	FBTS	Futures	89.165	89.165	88.947	89.022	2037.0
2012-09-17	FCE	Futures	2660.5	2663.8	2641.0	2649.2	56234.0
2012-09-17	FDAX	Futures	8090.6	8128.4	8077.5	8109.8	27795.0
2012-09-17	FESX	Futures	1747.1	1755.3	1745.7	1749.8	604098.0
2012-09-17	FEU3	Futures	98.468	98.473	98.468	98.468	230.0
2012-09-17	FGBL	Futures	116.02	116.3	115.68	116.17	624069.0
2012-09-17	FGBM	Futures	115.24	115.42	115.11	115.34	341808.0
2012-09-17	FGBS	Futures	110.208	110.258	110.188	110.243	219379.0
2012-09-17	FGBX	Futures	120.35	121.51	119.46	121.11	6646.0
2012-09-17	FOAT	Futures	102.19	102.25	101.92	102.07	26149.0
2012-09-17	FTDX	Futures	763.2	766.9	762.7	766.9	419.0
2012-09-17	FTI	Futures	287.15	288.35	286.81	287.58	22064.0
2012-09-17	FTUK	Futures	4285.2	4304.6	4271.7	4286.7	70962.0
2012-09-17	FVSA	Futures	5938.99	5963.43	5694.58	5719.03	2747.0
2012-09-17	FXXP	Futures	197.5	197.7	197.5	197.7	1158.0
2012-09-17	G	Futures	97.41	97.81	97.22	97.74	112803.0
2012-09-17	GF	Futures	286.469	288.27	285.544	286.177	2443.0
2012-09-17	GSCI	Futures	1117.41	1117.41	1080.9	1091.14	546.0
2012-09-17	HE	Futures	91.484	91.795	90.427	91.173	17639.0
2012-09-17	HG	Futures	4.9129	4.9219	4.7895	4.8731	53033.0
2012-09-17	HH	Futures	38.406	38.406	38.406	38.406	202.0
2012-09-17	HO	Futures	2.6238	2.6285	2.5081	2.5639	24526.0
2012-09-17	HRC	Futures	2471.7	2471.7	2471.7	2471.7	0.0

> showing 50 of 98 rows — these rows as CSV

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