PREVIEW / futures_daily / 2012-07-09

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-09.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-07-09	ES	Futures	1366.41	1367.43	1358.06	1366.41	1473739.0
2012-07-09	NQ	Futures	2987.05	3001.97	2974.43	2991.07	163428.0
2012-07-09	YM	Futures	12329.0	12340.6	12245.6	12306.7	99347.0
2012-07-09	CL	Futures	153.56	157.71	153.19	156.82	256901.0
2012-07-09	GC	Futures	2115.3	2129.7	2106.8	2124.3	98066.0
2012-07-09	ZN	Futures	117.107976	117.339495	117.080738	117.271401	577944.0
2012-07-09	A6	Futures	0.9098	0.9124	0.90719	0.91105	101179.0
2012-07-09	AD	Futures	0.98125	0.98315	0.97924	0.98165	64764.0
2012-07-09	B	Futures	87.82	90.21	87.65	89.59	196855.0
2012-07-09	B6	Futures	1.6176	1.6237	1.6166	1.6216	61557.0
2012-07-09	BFX	Futures	2663.0	2663.0	2630.8	2630.8	13.0
2012-07-09	BR	Futures	0.23214	0.23257	0.23214	0.23257	3.0
2012-07-09	BZ	Futures	94.83	96.61	93.99	95.99	3426.0
2012-07-09	C	Futures	1597.0	1638.0	1583.0	1633.0	3688.0
2012-07-09	CB	Futures	84.112	85.444	84.112	85.444	3.0
2012-07-09	CC	Futures	1699.0	1763.0	1697.0	1747.0	9272.0
2012-07-09	CSC	Futures	3.867	3.888	3.854	3.856	42.0
2012-07-09	CT	Futures	93.2	94.58	92.7	92.7	68.0
2012-07-09	DC	Futures	28.39	28.68	28.39	28.44	167.0
2012-07-09	DX	Futures	81.105	81.173	80.818	80.902	23705.0
2012-07-09	E1	Futures	1.32047	1.32705	1.31969	1.3255	30936.0
2012-07-09	E6	Futures	1.44856	1.45516	1.4469	1.45339	218836.0
2012-07-09	E7	Futures	1.4397	1.4462	1.4379	1.4444	1791.0
2012-07-09	ED	Futures	95.1465	95.1513	95.1322	95.1417	144641.0
2012-07-09	ER	Futures	97.68	97.7	97.656	97.656	84301.0
2012-07-09	EW	Futures	955.6	958.2	949.8	956.8	19037.0
2012-07-09	FBTP	Futures	64.93	64.95	64.2	64.52	14184.0
2012-07-09	FBTS	Futures	84.633	84.633	83.855	84.112	3243.0
2012-07-09	FCE	Futures	2350.2	2352.4	2324.3	2338.7	99018.0
2012-07-09	FDAX	Futures	6993.9	7014.7	6963.4	6986.9	108549.0
2012-07-09	FESX	Futures	1508.8	1512.9	1493.3	1505.5	903325.0
2012-07-09	FEU3	Futures	98.246	98.246	98.236	98.236	200.0
2012-07-09	FGBL	Futures	118.89	119.17	118.82	118.93	460411.0
2012-07-09	FGBM	Futures	116.52	116.64	116.44	116.49	297288.0
2012-07-09	FGBS	Futures	110.437	110.437	110.387	110.407	276060.0
2012-07-09	FGBX	Futures	126.88	127.32	126.62	126.75	3899.0
2012-07-09	FOAT	Futures	100.45	100.71	100.02	100.14	14887.0
2012-07-09	FTDX	Futures	698.9	702.1	696.1	699.8	32.0
2012-07-09	FTI	Futures	264.24	264.24	261.69	262.33	26288.0
2012-07-09	FTUK	Futures	4098.5	4104.7	4051.9	4065.0	70435.0
2012-07-09	FVSA	Futures	8094.54	8184.98	7657.4	7868.44	4913.0
2012-07-09	FXXP	Futures	181.6	181.7	180.6	181.1	534.0
2012-07-09	G	Futures	99.7	99.93	99.55	99.72	79532.0
2012-07-09	GF	Futures	286.369	286.517	283.408	284.74	4551.0
2012-07-09	GSCI	Futures	968.09	980.37	964.45	974.43	1598.0
2012-07-09	HE	Futures	99.576	101.26	99.149	100.431	29891.0
2012-07-09	HG	Futures	4.3963	4.4317	4.3757	4.4207	31769.0
2012-07-09	HO	Futures	2.2169	2.261	2.2106	2.2465	18390.0
2012-07-09	HRC	Futures	2450.1	2450.1	2450.1	2450.1	0.0
2012-07-09	J1	Futures	0.0157413	0.0157927	0.0157238	0.0157601	46238.0

> showing 50 of 99 rows — these rows as CSV

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