PREVIEW / futures_daily / 2009-07-29

all futures daily files

  file:    by_date/futures_daily/2009/2009-07-29.parquet
  size:    8 KB
  rows:    86

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
2009-07-29	ES	Futures	935.69	936.41	924.9	935.45	1869237.0
2009-07-29	NQ	Futures	1803.27	1806.08	1783.56	1802.7	297487.0
2009-07-29	YM	Futures	8162.7	8168.1	8079.7	8162.7	130774.0
2009-07-29	CL	Futures	171.68	172.53	161.43	163.1	342411.0
2009-07-29	GC	Futures	1299.2	1304.1	1282.3	1285.3	93901.0
2009-07-29	ZN	Futures	91.47065	91.803091	91.002769	91.409087	762678.0
2009-07-29	A6	Futures	0.66211	0.66315	0.6507	0.65086	96400.0
2009-07-29	AD	Futures	0.91442	0.91502	0.90346	0.90494	69164.0
2009-07-29	B	Futures	66.4	66.58	63.05	63.41	81695.0
2009-07-29	B6	Futures	1.7103	1.7152	1.7023	1.7036	123945.0
2009-07-29	BFX	Futures	2388.6	2423.2	2381.5	2423.2	77.0
2009-07-29	BR	Futures	0.20501	0.2056	0.20338	0.20455	64.0
2009-07-29	BZ	Futures	68.51	68.51	66.14	66.14	3.0
2009-07-29	C	Futures	1932.0	1948.0	1875.0	1877.0	4859.0
2009-07-29	CB	Futures	73.895	73.895	73.895	73.895	10.0
2009-07-29	CC	Futures	2546.0	2575.0	2473.0	2493.0	6051.0
2009-07-29	CT	Futures	50.42	50.57	50.06	50.47	92.0
2009-07-29	DC	Futures	21.88	21.97	21.17	21.54	226.0
2009-07-29	DX	Futures	80.952	81.689	80.732	81.663	7247.0
2009-07-29	E1	Futures	1.23218	1.23417	1.21418	1.21551	53137.0
2009-07-29	E6	Futures	1.682	1.68533	1.66277	1.66289	298175.0
2009-07-29	E7	Futures	1.6646	1.6677	1.6457	1.6458	2683.0
2009-07-29	ED	Futures	93.9424	93.9519	93.933	93.9424	118210.0
2009-07-29	ER	Futures	97.086	97.1	97.081	97.1	60687.0
2009-07-29	EW	Futures	600.6	601.2	593.1	598.5	29763.0
2009-07-29	FCE	Futures	2197.6	2229.4	2170.4	2205.8	117201.0
2009-07-29	FDAX	Futures	5726.1	5829.3	5647.7	5783.2	145861.0
2009-07-29	FESX	Futures	1546.6	1562.1	1522.1	1549.6	1059379.0
2009-07-29	FEU3	Futures	97.663	97.677	97.663	97.677	78.0
2009-07-29	FGBL	Futures	91.73	92.01	91.64	91.84	633340.0
2009-07-29	FGBM	Futures	97.81	98.03	97.75	97.94	336226.0
2009-07-29	FGBS	Futures	103.993	104.075	103.969	104.051	388237.0
2009-07-29	FGBX	Futures	83.52	84.1	83.52	83.92	1935.0
2009-07-29	FTDX	Futures	579.1	588.9	578.2	584.4	291.0
2009-07-29	FTI	Futures	225.59	228.09	222.96	226.9	27377.0
2009-07-29	FTUK	Futures	2982.8	3024.7	2978.5	2999.4	100431.0
2009-07-29	G	Futures	74.54	74.64	74.24	74.27	80018.0
2009-07-29	GF	Futures	283.486	284.037	280.592	281.212	1743.0
2009-07-29	GSCI	Futures	913.04	913.45	888.38	889.01	383.0
2009-07-29	HE	Futures	80.681	82.192	80.357	81.688	7711.0
2009-07-29	HG	Futures	3.5538	3.5651	3.4401	3.4787	23420.0
2009-07-29	HO	Futures	1.807	1.8116	1.7033	1.7162	45799.0
2009-07-29	HRC	Futures	2434.4	2434.4	2434.4	2434.4	0.0
2009-07-29	J1	Futures	0.0133244	0.0133961	0.0132035	0.0132564	116285.0
2009-07-29	J7	Futures	0.013146	0.013207	0.013025	0.013074	33.0
2009-07-29	JB	Futures	116.53	116.7	116.48	116.6	2530.0
2009-07-29	KC	Futures	332.12	337.55	329.0	333.34	8069.0
2009-07-29	KE	Futures	2629.6	2645.19	2599.62	2621.21	7926.0
2009-07-29	L	Futures	97.367	97.416	97.367	97.396	21084.0
2009-07-29	LBS	Futures	844.4	846.0	824.1	824.1	358.0

> showing 50 of 86 rows — these rows as CSV

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