PREVIEW / futures_daily / 2009-09-29

all futures daily files

  file:    by_date/futures_daily/2009/2009-09-29.parquet
  size:    8 KB
  rows:    87

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-09-29	ES	Futures	1021.68	1027.95	1015.9	1017.34	1645534.0
2009-09-29	NQ	Futures	1944.43	1953.74	1926.65	1936.53	276654.0
2009-09-29	YM	Futures	8834.4	8874.4	8779.1	8781.8	129533.0
2009-09-29	CL	Futures	166.2	166.74	163.0	165.2	247345.0
2009-09-29	GC	Futures	1372.2	1378.6	1363.2	1374.7	105185.0
2009-09-29	ZN	Futures	94.276788	94.339058	93.890714	94.289242	773701.0
2009-09-29	A6	Futures	0.70073	0.7038	0.69677	0.70049	70262.0
2009-09-29	AD	Futures	0.9088	0.91363	0.90259	0.90979	65153.0
2009-09-29	B	Futures	62.19	62.28	61.03	61.8	50405.0
2009-09-29	B6	Futures	1.6518	1.6636	1.6464	1.6583	139941.0
2009-09-29	BFX	Futures	2835.5	2835.5	2817.5	2832.1	77.0
2009-09-29	BR	Futures	0.21955	0.21955	0.21943	0.21943	4.0
2009-09-29	BZ	Futures	65.14	65.14	64.82	64.82	2.0
2009-09-29	C	Futures	2129.0	2142.0	2094.0	2116.0	13181.0
2009-09-29	CB	Futures	71.273	71.273	70.6	70.6	2.0
2009-09-29	CC	Futures	2690.0	2726.0	2650.0	2682.0	4765.0
2009-09-29	CT	Futures	54.15	54.67	52.79	53.03	8786.0
2009-09-29	DC	Futures	23.88	24.08	23.62	23.99	129.0
2009-09-29	DX	Futures	78.818	79.364	78.639	78.981	7691.0
2009-09-29	E1	Futures	1.27929	1.28154	1.26912	1.27401	48602.0
2009-09-29	E6	Futures	1.73161	1.73576	1.72095	1.72652	245299.0
2009-09-29	E7	Futures	1.7158	1.719	1.7043	1.71	2276.0
2009-09-29	ED	Futures	94.1671	94.1765	94.1529	94.1718	190772.0
2009-09-29	ER	Futures	97.203	97.203	97.174	97.188	117794.0
2009-09-29	EW	Futures	669.7	676.3	667.2	670.6	36070.0
2009-09-29	FCE	Futures	2524.0	2537.9	2506.2	2518.1	117690.0
2009-09-29	FDAX	Futures	6238.6	6265.8	6191.3	6222.8	144003.0
2009-09-29	FESX	Futures	1725.0	1735.8	1711.9	1720.2	1051154.0
2009-09-29	FEU3	Futures	97.771	97.771	97.751	97.761	329.0
2009-09-29	FGBL	Futures	93.69	93.89	93.44	93.81	813287.0
2009-09-29	FGBM	Futures	99.06	99.14	98.87	99.1	437504.0
2009-09-29	FGBS	Futures	104.755	104.769	104.648	104.726	531084.0
2009-09-29	FGBX	Futures	87.37	88.05	87.28	87.89	3173.0
2009-09-29	FTDX	Futures	673.2	674.5	666.1	667.4	751.0
2009-09-29	FTI	Futures	257.33	258.52	255.31	257.0	29524.0
2009-09-29	FTUK	Futures	3408.2	3420.2	3386.7	3404.9	95344.0
2009-09-29	G	Futures	76.61	76.86	76.45	76.78	112296.0
2009-09-29	GF	Futures	265.02	265.088	263.505	263.781	915.0
2009-09-29	GSCI	Futures	880.93	893.74	880.53	888.54	150.0
2009-09-29	HE	Futures	76.03	77.478	75.915	76.487	7975.0
2009-09-29	HG	Futures	3.7764	3.8315	3.7444	3.8029	17195.0
2009-09-29	HO	Futures	1.6961	1.7081	1.6792	1.7006	14020.0
2009-09-29	HRC	Futures	2713.5	2713.5	2713.5	2713.5	0.0
2009-09-29	J1	Futures	0.0140096	0.0140184	0.0139003	0.0139305	94359.0
2009-09-29	J7	Futures	0.013798	0.013832	0.013723	0.013749	78.0
2009-09-29	JB	Futures	117.54	117.63	117.49	117.63	739.0
2009-09-29	KC	Futures	335.64	336.3	330.75	331.28	8226.0
2009-09-29	KE	Futures	2207.87	2229.97	2154.36	2179.95	8618.0
2009-09-29	L	Futures	97.878	97.888	97.77	97.789	286777.0
2009-09-29	LBS	Futures	695.7	699.0	683.5	685.5	1600.0

> showing 50 of 87 rows — these rows as CSV

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