PREVIEW / futures_daily / 2009-11-09

all futures daily files

  file:    by_date/futures_daily/2009/2009-11-09.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-11-09	ES	Futures	1027.95	1053.27	1027.23	1053.03	1833896.0
2009-11-09	NQ	Futures	1950.64	1995.23	1950.07	1994.1	276685.0
2009-11-09	YM	Futures	9059.6	9256.6	9050.5	9253.0	119644.0
2009-11-09	CL	Futures	190.81	196.49	190.56	194.63	327402.0
2009-11-09	GC	Futures	1517.9	1536.9	1515.2	1522.6	137533.0
2009-11-09	ZN	Futures	94.401328	94.613046	94.226972	94.476052	551117.0
2009-11-09	A6	Futures	0.74154	0.74987	0.74065	0.74922	62926.0
2009-11-09	AD	Futures	0.91847	0.93533	0.91728	0.93523	68680.0
2009-11-09	B	Futures	71.53	73.68	71.53	72.99	84088.0
2009-11-09	B6	Futures	1.7321	1.7521	1.7286	1.7427	103151.0
2009-11-09	BFX	Futures	2780.7	2828.8	2780.7	2818.4	444.0
2009-11-09	BR	Futures	0.23307	0.23307	0.23307	0.23307	10.0
2009-11-09	C	Futures	2184.0	2186.0	2142.0	2145.0	3987.0
2009-11-09	CC	Futures	2805.0	2812.0	2757.0	2761.0	9329.0
2009-11-09	CT	Futures	57.73	58.77	57.61	58.35	9975.0
2009-11-09	DC	Futures	25.02	25.04	24.78	25.02	168.0
2009-11-09	DX	Futures	77.399	77.419	76.597	76.709	16212.0
2009-11-09	E1	Futures	1.30043	1.3139	1.29845	1.31047	41376.0
2009-11-09	E6	Futures	1.76278	1.77997	1.76006	1.77724	194821.0
2009-11-09	E7	Futures	1.7455	1.7629	1.7433	1.7602	2196.0
2009-11-09	ED	Futures	94.2569	94.2569	94.2521	94.2521	58659.0
2009-11-09	ER	Futures	97.174	97.184	97.169	97.174	60209.0
2009-11-09	EW	Futures	658.3	675.4	658.2	673.5	32820.0
2009-11-09	FBTP	Futures	62.39	62.71	62.37	62.7	1590.0
2009-11-09	FCE	Futures	2454.3	2503.2	2453.7	2490.3	98035.0
2009-11-09	FDAX	Futures	6015.0	6155.4	6015.0	6114.6	129725.0
2009-11-09	FESX	Futures	1676.0	1711.9	1674.2	1699.9	978851.0
2009-11-09	FEU3	Futures	97.751	97.751	97.741	97.746	546.0
2009-11-09	FGBL	Futures	93.04	93.54	93.02	93.5	540296.0
2009-11-09	FGBM	Futures	98.92	99.25	98.92	99.23	290183.0
2009-11-09	FGBS	Futures	104.794	104.866	104.774	104.847	365283.0
2009-11-09	FGBX	Futures	85.66	86.55	85.57	86.41	2785.0
2009-11-09	FTDX	Futures	673.2	679.4	672.3	677.2	493.0
2009-11-09	FTI	Futures	252.8	257.83	252.8	256.85	27356.0
2009-11-09	FTUK	Futures	3428.8	3477.6	3425.5	3458.7	81122.0
2009-11-09	G	Futures	75.44	75.86	75.4	75.8	60866.0
2009-11-09	GF	Futures	261.232	261.645	258.618	259.306	883.0
2009-11-09	GSCI	Futures	985.04	1001.17	983.86	997.63	3113.0
2009-11-09	HE	Futures	84.986	85.595	84.566	85.062	18698.0
2009-11-09	HG	Futures	4.1206	4.1834	4.1179	4.1353	28923.0
2009-11-09	HO	Futures	1.9515	2.0125	1.9478	1.9982	45509.0
2009-11-09	HRC	Futures	2586.3	2586.3	2586.3	2586.3	0.0
2009-11-09	J1	Futures	0.0139731	0.014002	0.0139141	0.0139556	64831.0
2009-11-09	J7	Futures	0.01375	0.013808	0.013735	0.013773	35.0
2009-11-09	JB	Futures	115.97	116.14	115.86	115.92	1907.0
2009-11-09	KC	Futures	368.24	375.5	367.18	369.69	11538.0
2009-11-09	KE	Futures	2331.17	2469.6	2327.68	2427.72	13365.0
2009-11-09	L	Futures	97.73	97.75	97.73	97.74	16743.0
2009-11-09	LBS	Futures	751.6	758.1	744.2	754.0	243.0
2009-11-09	LE	Futures	142.461	142.921	142.042	142.21	28028.0

> showing 50 of 87 rows — these rows as CSV

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