PREVIEW / futures_daily / 2009-01-23

all futures daily files

  file:    by_date/futures_daily/2009/2009-01-23.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-01-23	ES	Futures	778.33	789.43	754.96	777.62	2596504.0
2009-01-23	NQ	Futures	1307.49	1331.52	1276.18	1301.62	347363.0
2009-01-23	YM	Futures	7197.0	7219.3	6991.4	7099.1	237731.0
2009-01-23	CL	Futures	143.71	156.14	137.53	154.38	269756.0
2009-01-23	GC	Futures	1195.1	1260.1	1188.0	1248.9	197174.0
2009-01-23	ZN	Futures	95.049001	95.443445	94.343784	94.786039	598290.0
2009-01-23	A6	Futures	0.51758	0.52043	0.50679	0.51797	33493.0
2009-01-23	AD	Futures	0.78405	0.80055	0.77629	0.79574	32222.0
2009-01-23	B	Futures	46.84	50.41	45.71	50.19	54964.0
2009-01-23	B6	Futures	1.4422	1.4425	1.4019	1.429	70983.0
2009-01-23	BFX	Futures	1994.5	2024.2	1979.2	2023.2	404.0
2009-01-23	BZ	Futures	47.02	51.59	47.02	51.59	39.0
2009-01-23	C	Futures	1982.0	2017.0	1978.0	2015.0	9534.0
2009-01-23	CB	Futures	76.342	76.342	76.342	76.342	2.0
2009-01-23	CC	Futures	2282.0	2364.0	2269.0	2348.0	6881.0
2009-01-23	CT	Futures	47.6	50.18	47.59	49.29	6676.0
2009-01-23	DC	Futures	26.73	27.13	26.62	26.92	193.0
2009-01-23	DX	Futures	89.456	90.633	89.015	89.373	4910.0
2009-01-23	E1	Futures	1.15437	1.15437	1.13523	1.14985	35973.0
2009-01-23	E6	Futures	1.53978	1.54203	1.51007	1.53517	195359.0
2009-01-23	E7	Futures	1.5217	1.5245	1.4928	1.5176	2802.0
2009-01-23	EBM	Futures	227.79	233.92	226.64	233.16	1332.0
2009-01-23	ED	Futures	93.1519	93.1708	93.0672	93.0907	209294.0
2009-01-23	ER	Futures	96.307	96.366	96.277	96.292	118232.0
2009-01-23	EW	Futures	485.2	494.5	468.1	483.9	35162.0
2009-01-23	FCE	Futures	1786.8	1790.5	1712.0	1761.5	174913.0
2009-01-23	FDAX	Futures	4623.8	4634.7	4449.1	4576.9	199537.0
2009-01-23	FESX	Futures	1246.7	1254.8	1197.3	1234.1	1559992.0
2009-01-23	FEU3	Futures	96.899	96.904	96.859	96.859	164.0
2009-01-23	FGBL	Futures	92.88	93.03	91.82	92.09	804416.0
2009-01-23	FGBM	Futures	97.75	97.99	97.15	97.39	427388.0
2009-01-23	FGBS	Futures	103.608	103.771	103.498	103.575	490396.0
2009-01-23	FGBX	Futures	83.76	83.76	80.96	81.02	3044.0
2009-01-23	FTDX	Futures	403.6	407.2	392.0	401.8	454.0
2009-01-23	FTI	Futures	190.07	190.07	182.81	188.38	42607.0
2009-01-23	FTUK	Futures	2626.3	2674.5	2567.9	2621.3	142810.0
2009-01-23	G	Futures	74.68	74.71	73.42	73.51	64460.0
2009-01-23	GF	Futures	258.662	260.626	255.296	260.205	481.0
2009-01-23	GSCI	Futures	780.05	828.13	770.91	820.16	127.0
2009-01-23	HE	Futures	126.521	126.521	123.766	124.491	4424.0
2009-01-23	HG	Futures	1.955	2.0816	1.9325	2.0718	12424.0
2009-01-23	HO	Futures	1.5051	1.6183	1.4656	1.6093	37955.0
2009-01-23	HRC	Futures	3189.6	3189.6	3189.6	3189.6	0.0
2009-01-23	J1	Futures	0.0142241	0.0143706	0.0141054	0.014238	79959.0
2009-01-23	J7	Futures	0.014014	0.014195	0.013921	0.014067	82.0
2009-01-23	JB	Futures	117.02	117.06	116.72	117.0	1.0
2009-01-23	KC	Futures	340.11	344.68	337.25	341.96	6759.0
2009-01-23	KE	Futures	2979.17	3121.57	2937.94	3050.37	6324.0
2009-01-23	L	Futures	96.994	97.014	96.94	96.95	34867.0
2009-01-23	LBS	Futures	868.3	877.3	845.9	847.0	43.0

> showing 50 of 86 rows — these rows as CSV

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