PREVIEW / futures_daily / 2012-09-20

all futures daily files

  file:    by_date/futures_daily/2012/2012-09-20.parquet
  size:    9 KB
  rows:    100

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-20	ES	Futures	1479.35	1480.88	1469.17	1479.6	1744200.0
2012-09-20	NQ	Futures	3284.71	3288.45	3264.57	3282.98	230586.0
2012-09-20	YM	Futures	13180.7	13210.0	13110.4	13197.3	114476.0
2012-09-20	CL	Futures	166.17	168.01	164.17	166.8	244553.0
2012-09-20	GC	Futures	2366.4	2369.7	2346.8	2363.5	144572.0
2012-09-20	ZN	Futures	116.40927	116.793822	116.326866	116.381802	923448.0
2012-09-20	A6	Futures	0.94443	0.94516	0.93508	0.94198	131091.0
2012-09-20	AD	Futures	1.02757	1.02787	1.02045	1.02577	79391.0
2012-09-20	B	Futures	98.64	100.89	97.66	100.33	250449.0
2012-09-20	B6	Futures	1.6935	1.6952	1.6877	1.6932	105941.0
2012-09-20	BFX	Futures	2909.0	2927.9	2909.0	2924.4	65.0
2012-09-20	BR	Futures	0.2374	0.23787	0.2374	0.23787	108.0
2012-09-20	BZ	Futures	102.48	105.63	102.41	105.15	1613.0
2012-09-20	C	Futures	1670.0	1672.0	1652.0	1657.0	5581.0
2012-09-20	CB	Futures	98.75	98.75	98.75	98.75	2.0
2012-09-20	CC	Futures	1924.0	1927.0	1890.0	1900.0	9041.0
2012-09-20	CSC	Futures	4.099	4.099	4.099	4.099	2.0
2012-09-20	CT	Futures	98.06	98.06	97.1	97.14	20.0
2012-09-20	DC	Futures	31.11	31.21	30.8	30.92	154.0
2012-09-20	DX	Futures	76.651	77.252	76.646	76.983	27154.0
2012-09-20	E1	Futures	1.38921	1.3914	1.3775	1.38175	29389.0
2012-09-20	E6	Futures	1.53757	1.5391	1.52261	1.52862	277597.0
2012-09-20	E7	Futures	1.5285	1.5298	1.5135	1.5195	5804.0
2012-09-20	ED	Futures	95.211	95.2157	95.2062	95.2062	119413.0
2012-09-20	ER	Futures	97.862	97.896	97.862	97.891	149047.0
2012-09-20	EW	Futures	1029.1	1030.1	1017.4	1023.7	17129.0
2012-09-20	FBTP	Futures	71.57	71.79	71.03	71.45	22624.0
2012-09-20	FBTS	Futures	89.424	89.474	89.173	89.391	3100.0
2012-09-20	FCE	Futures	2623.4	2625.3	2597.6	2616.7	114473.0
2012-09-20	FDAX	Futures	8062.7	8113.1	8015.6	8092.8	93351.0
2012-09-20	FESX	Futures	1732.8	1734.2	1718.5	1728.0	903489.0
2012-09-20	FEU3	Futures	98.497	98.512	98.497	98.512	153.0
2012-09-20	FGBL	Futures	116.93	117.3	116.82	117.18	743729.0
2012-09-20	FGBM	Futures	115.66	115.96	115.64	115.88	487546.0
2012-09-20	FGBS	Futures	110.288	110.353	110.283	110.328	312244.0
2012-09-20	FGBX	Futures	122.23	123.18	122.21	123.1	7654.0
2012-09-20	FOAT	Futures	102.24	102.51	101.88	102.24	33563.0
2012-09-20	FTDX	Futures	762.7	767.9	762.7	767.9	1768.0
2012-09-20	FTI	Futures	285.49	286.05	283.83	285.19	22819.0
2012-09-20	FTUK	Futures	4285.6	4285.6	4240.9	4263.3	96372.0
2012-09-20	FVSA	Futures	5584.6	5670.14	5474.62	5499.06	5808.0
2012-09-20	FXXP	Futures	197.7	197.7	196.5	197.5	9894.0
2012-09-20	G	Futures	98.65	98.9	98.51	98.83	167961.0
2012-09-20	GF	Futures	286.372	287.345	284.911	285.641	2817.0
2012-09-20	GSCI	Futures	1057.6	1066.15	1054.86	1061.63	190.0
2012-09-20	HE	Futures	92.882	93.441	91.795	92.23	20339.0
2012-09-20	HG	Futures	4.8808	4.8936	4.7979	4.8306	51385.0
2012-09-20	HH	Futures	37.495	37.495	37.495	37.495	294.0
2012-09-20	HO	Futures	2.4626	2.5103	2.4458	2.4991	27874.0
2012-09-20	HRC	Futures	2471.7	2471.7	2471.7	2471.7	0.0

> showing 50 of 100 rows — these rows as CSV

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