PREVIEW / futures_daily / 2009-09-01

all futures daily files

  file:    by_date/futures_daily/2009/2009-09-01.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-09-01	ES	Futures	979.59	986.06	954.88	956.08	3206696.0
2009-09-01	NQ	Futures	1830.01	1857.04	1790.88	1796.79	458728.0
2009-09-01	YM	Futures	8566.0	8620.1	8376.5	8393.6	248173.0
2009-09-01	CL	Futures	173.56	178.07	169.66	169.79	336835.0
2009-09-01	GC	Futures	1316.1	1325.3	1309.9	1322.3	93242.0
2009-09-01	ZN	Futures	93.37911	93.846991	93.083607	93.662301	120794.0
2009-09-01	A6	Futures	0.6777	0.67842	0.66179	0.6638	126707.0
2009-09-01	AD	Futures	0.90277	0.9085	0.8923	0.89398	75639.0
2009-09-01	B	Futures	66.46	67.73	64.55	64.65	65425.0
2009-09-01	B6	Futures	1.6964	1.7055	1.6782	1.6835	135004.0
2009-09-01	BFX	Futures	2698.4	2699.0	2648.9	2648.9	166.0
2009-09-01	BR	Futures	0.20926	0.20926	0.20496	0.20496	36.0
2009-09-01	BZ	Futures	68.88	68.88	67.29	67.29	2.0
2009-09-01	C	Futures	1911.0	1942.0	1910.0	1926.0	1091.0
2009-09-01	CB	Futures	68.045	68.045	67.776	67.776	5.0
2009-09-01	CC	Futures	2460.0	2510.0	2457.0	2476.0	6472.0
2009-09-01	CT	Futures	50.79	50.86	49.15	49.86	253.0
2009-09-01	DC	Futures	22.29	22.36	22.2	22.2	79.0
2009-09-01	DX	Futures	80.01	80.87	79.81	80.66	12261.0
2009-09-01	E1	Futures	1.24953	1.25562	1.23642	1.24172	46944.0
2009-09-01	E6	Futures	1.70123	1.70693	1.68295	1.68734	256408.0
2009-09-01	E7	Futures	1.684	1.6892	1.6657	1.67	2679.0
2009-09-01	ED	Futures	94.1053	94.1266	94.0463	94.0864	236859.0
2009-09-01	ER	Futures	97.174	97.174	97.139	97.164	84052.0
2009-09-01	EW	Futures	631.6	641.0	617.4	619.0	56007.0
2009-09-01	FCE	Futures	2411.7	2414.4	2332.5	2344.0	199489.0
2009-09-01	FDAX	Futures	6038.8	6049.8	5818.3	5855.6	207921.0
2009-09-01	FESX	Futures	1665.3	1668.9	1609.8	1621.2	1706254.0
2009-09-01	FEU3	Futures	97.751	97.751	97.741	97.741	183.0
2009-09-01	FGBL	Futures	93.28	93.44	92.97	93.19	792082.0
2009-09-01	FGBM	Futures	98.64	98.9	98.53	98.66	488571.0
2009-09-01	FGBS	Futures	104.34	104.46	104.301	104.369	643855.0
2009-09-01	FGBX	Futures	86.9	86.93	86.18	86.53	4898.0
2009-09-01	FTDX	Futures	625.0	627.3	601.4	605.4	798.0
2009-09-01	FTI	Futures	246.78	247.03	238.98	240.34	48744.0
2009-09-01	FTUK	Futures	3258.3	3262.9	3177.0	3197.6	150145.0
2009-09-01	G	Futures	76.94	77.15	76.72	76.89	80979.0
2009-09-01	GF	Futures	270.228	270.574	267.81	268.155	597.0
2009-09-01	GSCI	Futures	921.46	935.12	901.9	906.99	378.0
2009-09-01	HE	Futures	72.138	74.649	71.988	74.199	12537.0
2009-09-01	HG	Futures	3.9583	4.051	3.8998	3.9276	26969.0
2009-09-01	HO	Futures	1.8086	1.8456	1.7642	1.7644	9960.0
2009-09-01	HRC	Futures	2687.9	2687.9	2687.9	2687.9	0.0
2009-09-01	J1	Futures	0.0135371	0.0135673	0.0134729	0.0135472	100552.0
2009-09-01	J7	Futures	0.013372	0.01338	0.013287	0.013361	405.0
2009-09-01	JB	Futures	117.18	117.32	117.16	117.32	1616.0
2009-09-01	KC	Futures	323.63	326.0	316.76	317.03	9010.0
2009-09-01	KE	Futures	2418.42	2420.75	2349.79	2374.21	7478.0
2009-09-01	L	Futures	97.671	97.681	97.573	97.642	46408.0
2009-09-01	LBS	Futures	714.5	717.3	678.3	690.1	678.0

> showing 50 of 86 rows — these rows as CSV

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