PREVIEW / futures_daily / 2009-09-04

all futures daily files

  file:    by_date/futures_daily/2009/2009-09-04.parquet
  size:    8 KB
  rows:    85

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-04	ES	Futures	960.88	975.03	959.44	972.87	1625973.0
2009-09-04	NQ	Futures	1806.93	1847.47	1802.42	1842.12	280186.0
2009-09-04	YM	Futures	8418.0	8519.0	8404.5	8496.5	129722.0
2009-09-04	CL	Futures	170.14	171.61	167.47	169.71	229782.0
2009-09-04	GC	Futures	1374.6	1380.2	1364.5	1377.9	117550.0
2009-09-04	ZN	Futures	93.699239	93.846991	93.231358	93.292922	26215.0
2009-09-04	A6	Futures	0.6744	0.68565	0.67296	0.68405	93656.0
2009-09-04	AD	Futures	0.89595	0.91265	0.89487	0.90968	85363.0
2009-09-04	B	Futures	64.35	64.56	62.93	63.74	70458.0
2009-09-04	B6	Futures	1.701	1.7094	1.6962	1.7079	91541.0
2009-09-04	BFX	Futures	2669.4	2695.8	2664.0	2681.2	119.0
2009-09-04	BR	Futures	0.21309	0.21309	0.21309	0.21309	30.0
2009-09-04	C	Futures	1985.0	1987.0	1963.0	1964.0	8124.0
2009-09-04	CB	Futures	67.776	68.314	67.776	68.314	6.0
2009-09-04	CC	Futures	2582.0	2597.0	2563.0	2576.0	2588.0
2009-09-04	CT	Futures	50.17	50.94	50.17	50.89	29.0
2009-09-04	DC	Futures	22.78	22.78	22.46	22.46	161.0
2009-09-04	DX	Futures	80.363	80.614	79.872	80.005	5237.0
2009-09-04	E1	Futures	1.24622	1.25164	1.23722	1.24847	60845.0
2009-09-04	E6	Futures	1.69221	1.70111	1.68461	1.69862	218074.0
2009-09-04	E7	Futures	1.675	1.6835	1.6674	1.6812	2209.0
2009-09-04	ED	Futures	94.11	94.1242	94.103	94.1171	93906.0
2009-09-04	ER	Futures	97.169	97.179	97.164	97.179	68121.0
2009-09-04	EW	Futures	622.8	632.3	619.9	630.0	25342.0
2009-09-04	FCE	Futures	2331.9	2374.1	2331.9	2354.8	132736.0
2009-09-04	FDAX	Futures	5840.2	5959.3	5838.0	5890.2	144842.0
2009-09-04	FESX	Futures	1615.8	1651.6	1615.2	1630.7	1099662.0
2009-09-04	FEU3	Futures	97.746	97.756	97.746	97.756	420.0
2009-09-04	FGBL	Futures	93.29	93.52	93.05	93.43	1096328.0
2009-09-04	FGBM	Futures	98.89	98.98	98.74	98.93	676569.0
2009-09-04	FGBS	Futures	104.523	104.648	104.48	104.624	848643.0
2009-09-04	FGBX	Futures	86.16	86.48	85.71	86.32	17996.0
2009-09-04	FTDX	Futures	615.7	629.0	615.2	623.7	1295.0
2009-09-04	FTI	Futures	239.02	243.73	239.02	241.83	30832.0
2009-09-04	FTUK	Futures	3199.9	3245.7	3197.9	3216.8	98100.0
2009-09-04	G	Futures	76.78	76.78	76.07	76.61	84204.0
2009-09-04	GF	Futures	271.127	273.546	271.127	273.546	402.0
2009-09-04	GSCI	Futures	892.73	898.33	884.57	890.69	788.0
2009-09-04	HE	Futures	74.199	76.073	74.199	75.698	8794.0
2009-09-04	HG	Futures	3.9994	4.0377	3.9472	3.9945	17122.0
2009-09-04	HO	Futures	1.752	1.7542	1.7151	1.7331	12427.0
2009-09-04	HRC	Futures	2738.7	2738.7	2738.7	2738.7	0.0
2009-09-04	J1	Futures	0.0135963	0.0136441	0.0134993	0.0135346	95435.0
2009-09-04	J7	Futures	0.013397	0.013451	0.013308	0.013348	39.0
2009-09-04	JB	Futures	117.28	117.35	116.96	116.99	1403.0
2009-09-04	KC	Futures	319.4	329.43	318.35	327.59	6536.0
2009-09-04	KE	Futures	2320.7	2324.19	2279.99	2279.99	9425.0
2009-09-04	L	Futures	97.671	97.691	97.661	97.681	41310.0
2009-09-04	LBS	Futures	700.7	710.4	697.4	706.7	549.0
2009-09-04	LE	Futures	143.849	144.724	143.766	144.266	9799.0

> showing 50 of 85 rows — these rows as CSV

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