PREVIEW / futures_daily / 2009-09-23

all futures daily files

  file:    by_date/futures_daily/2009/2009-09-23.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-23	ES	Futures	1029.4	1037.6	1017.82	1021.44	2129823.0
2009-09-23	NQ	Futures	1956.85	1979.14	1942.45	1947.82	311914.0
2009-09-23	YM	Futures	8868.0	8948.8	8787.2	8821.7	151358.0
2009-09-23	CL	Futures	177.39	177.83	168.5	170.8	307578.0
2009-09-23	GC	Futures	1404.7	1410.6	1392.4	1402.3	114888.0
2009-09-23	ZN	Futures	93.330284	93.666542	92.969117	93.604272	853440.0
2009-09-23	A6	Futures	0.7013	0.70582	0.69758	0.70299	63251.0
2009-09-23	AD	Futures	0.92221	0.92487	0.91501	0.92211	55216.0
2009-09-23	B	Futures	66.45	66.54	63.54	64.19	155922.0
2009-09-23	B6	Futures	1.7014	1.7134	1.6989	1.7081	117524.0
2009-09-23	BFX	Futures	2804.9	2824.3	2804.9	2822.7	38.0
2009-09-23	BR	Futures	0.21923	0.22043	0.21923	0.22043	540.0
2009-09-23	BZ	Futures	68.01	68.01	66.81	66.81	9.0
2009-09-23	C	Futures	2121.0	2144.0	2105.0	2107.0	4446.0
2009-09-23	CB	Futures	70.735	70.735	70.197	70.735	20.0
2009-09-23	CC	Futures	2781.0	2825.0	2752.0	2769.0	6315.0
2009-09-23	CT	Futures	54.83	55.67	54.7	55.66	167.0
2009-09-23	DC	Futures	24.13	24.49	24.1	24.18	115.0
2009-09-23	DX	Futures	77.822	78.363	77.639	77.894	7529.0
2009-09-23	E1	Futures	1.29131	1.31033	1.28643	1.29224	33810.0
2009-09-23	E6	Futures	1.75224	1.75923	1.74524	1.75366	229402.0
2009-09-23	E7	Futures	1.7358	1.7426	1.7285	1.7369	2557.0
2009-09-23	ED	Futures	94.1151	94.1671	94.1056	94.1623	224306.0
2009-09-23	ER	Futures	97.179	97.218	97.169	97.198	102030.0
2009-09-23	EW	Futures	679.9	683.8	670.5	672.1	43724.0
2009-09-23	FCE	Futures	2522.0	2542.8	2506.8	2522.7	89433.0
2009-09-23	FDAX	Futures	6214.7	6263.1	6170.6	6197.2	130925.0
2009-09-23	FESX	Futures	1714.3	1731.0	1706.5	1715.5	879355.0
2009-09-23	FEU3	Futures	97.751	97.771	97.751	97.771	51.0
2009-09-23	FGBL	Futures	92.59	93.1	92.45	92.84	715742.0
2009-09-23	FGBM	Futures	98.51	98.89	98.41	98.68	498686.0
2009-09-23	FGBS	Futures	104.619	104.745	104.581	104.682	398274.0
2009-09-23	FGBX	Futures	85.02	85.77	85.02	85.57	3135.0
2009-09-23	FTDX	Futures	681.2	684.8	672.7	677.2	310.0
2009-09-23	FTI	Futures	257.7	260.0	256.26	257.9	20272.0
2009-09-23	FTUK	Futures	3398.0	3414.2	3367.1	3387.7	103287.0
2009-09-23	G	Futures	75.77	75.91	75.61	75.87	72623.0
2009-09-23	GF	Futures	266.259	269.563	265.777	269.494	1592.0
2009-09-23	GSCI	Futures	928.56	928.96	904.55	914.55	355.0
2009-09-23	HE	Futures	74.01	76.944	73.4	76.297	13842.0
2009-09-23	HG	Futures	4.0022	4.0092	3.8447	3.913	20198.0
2009-09-23	HO	Futures	1.8161	1.8223	1.7508	1.7651	16323.0
2009-09-23	HRC	Futures	2738.7	2738.7	2738.7	2738.7	0.0
2009-09-23	J1	Futures	0.0137861	0.0138853	0.0137245	0.0137798	75322.0
2009-09-23	J7	Futures	0.013684	0.013703	0.013548	0.0136	73.0
2009-09-23	KC	Futures	362.96	364.94	356.49	360.05	7125.0
2009-09-23	KE	Futures	2177.62	2236.95	2159.01	2184.6	9625.0
2009-09-23	L	Futures	97.878	97.878	97.829	97.858	118971.0
2009-09-23	LBS	Futures	715.3	721.0	709.6	712.0	110.0
2009-09-23	LE	Futures	141.205	143.549	140.954	143.549	20792.0

> showing 50 of 87 rows — these rows as CSV

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