PREVIEW / futures_daily / 2012-08-23

all futures daily files

  file:    by_date/futures_daily/2012/2012-08-23.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-23	ES	Futures	1430.21	1436.04	1415.78	1417.81	1592212.0
2012-08-23	NQ	Futures	3193.08	3205.13	3160.94	3168.97	213607.0
2012-08-23	YM	Futures	12761.7	12820.9	12635.6	12650.1	113820.0
2012-08-23	CL	Futures	176.03	177.82	173.22	174.16	225156.0
2012-08-23	GC	Futures	2209.0	2239.7	2209.0	2233.4	157054.0
2012-08-23	ZN	Futures	116.345323	116.617699	116.195517	116.522368	966704.0
2012-08-23	A6	Futures	0.9428	0.94621	0.93632	0.93713	151755.0
2012-08-23	AD	Futures	1.01143	1.01373	1.00722	1.00872	82765.0
2012-08-23	B	Futures	104.26	105.66	103.8	104.42	196031.0
2012-08-23	B6	Futures	1.6593	1.663	1.6572	1.6579	97613.0
2012-08-23	BFX	Futures	2845.8	2845.8	2808.2	2812.7	9.0
2012-08-23	BR	Futures	0.23549	0.23563	0.23549	0.23563	27.0
2012-08-23	BZ	Futures	111.05	111.35	109.44	110.04	2201.0
2012-08-23	C	Futures	1607.0	1618.0	1588.0	1598.0	1968.0
2012-08-23	CB	Futures	97.252	97.519	97.252	97.252	4.0
2012-08-23	CC	Futures	1795.0	1831.0	1787.0	1799.0	11926.0
2012-08-23	CSC	Futures	4.105	4.123	4.105	4.123	18.0
2012-08-23	CT	Futures	98.8	100.02	98.78	99.98	16.0
2012-08-23	DC	Futures	30.26	30.57	30.12	30.5	218.0
2012-08-23	DX	Futures	79.086	79.139	78.833	78.968	22209.0
2012-08-23	E1	Futures	1.34758	1.35417	1.34681	1.35132	38516.0
2012-08-23	E6	Futures	1.47816	1.48548	1.47769	1.48253	229424.0
2012-08-23	E7	Futures	1.4691	1.4762	1.4685	1.4733	4143.0
2012-08-23	ED	Futures	95.1752	95.1847	95.1704	95.18	161151.0
2012-08-23	ER	Futures	97.852	97.866	97.852	97.866	59016.0
2012-08-23	EW	Futures	986.1	991.7	976.4	979.8	17617.0
2012-08-23	FBTP	Futures	67.26	67.51	66.82	67.15	16385.0
2012-08-23	FBTS	Futures	87.419	87.428	86.948	87.089	2095.0
2012-08-23	FCE	Futures	2597.0	2601.5	2540.4	2553.8	103227.0
2012-08-23	FDAX	Futures	7729.3	7733.1	7558.9	7602.1	122091.0
2012-08-23	FESX	Futures	1673.2	1675.9	1631.3	1643.4	965523.0
2012-08-23	FGBL	Futures	117.9	118.71	117.87	118.53	776526.0
2012-08-23	FGBM	Futures	116.23	116.52	116.18	116.43	373502.0
2012-08-23	FGBS	Futures	110.457	110.492	110.417	110.482	368429.0
2012-08-23	FGBX	Futures	126.43	127.92	126.17	127.48	10844.0
2012-08-23	FOAT	Futures	102.59	103.24	102.52	103.17	22341.0
2012-08-23	FTDX	Futures	736.1	736.1	730.5	731.0	30.0
2012-08-23	FTI	Futures	284.09	284.26	279.88	280.86	25686.0
2012-08-23	FTUK	Futures	4211.7	4228.8	4184.4	4206.2	74623.0
2012-08-23	FVSA	Futures	6737.73	7147.63	6737.73	6981.11	5538.0
2012-08-23	FXXP	Futures	194.1	194.1	191.3	192.1	785.0
2012-08-23	G	Futures	99.76	100.09	99.57	100.01	142613.0
2012-08-23	GF	Futures	277.876	283.835	277.482	282.653	1153.0
2012-08-23	GSCI	Futures	1096.37	1097.49	1080.83	1084.7	155.0
2012-08-23	HE	Futures	90.402	91.391	89.074	89.692	20544.0
2012-08-23	HG	Futures	4.4721	4.5197	4.4567	4.4959	23159.0
2012-08-23	HO	Futures	2.5563	2.5764	2.5417	2.5533	13722.0
2012-08-23	HRC	Futures	2548.9	2548.9	2548.9	2548.9	0.0
2012-08-23	J1	Futures	0.0159581	0.0159957	0.0159256	0.0159769	84181.0
2012-08-23	J7	Futures	0.015891	0.015933	0.015864	0.015914	279.0

> showing 50 of 99 rows — these rows as CSV

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