PREVIEW / futures_daily / 2009-06-29

all futures daily files

  file:    by_date/futures_daily/2009/2009-06-29.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-06-29	ES	Futures	875.97	886.52	870.45	883.88	1346711.0
2009-06-29	NQ	Futures	1662.22	1680.8	1651.8	1668.41	210022.0
2009-06-29	YM	Futures	7552.7	7647.5	7506.7	7631.2	96800.0
2009-06-29	CL	Futures	182.21	189.23	179.87	188.1	229882.0
2009-06-29	GC	Futures	1302.4	1305.8	1292.5	1302.4	57109.0
2009-06-29	ZN	Futures	91.643027	91.975468	91.495275	91.766153	521032.0
2009-06-29	A6	Futures	0.64475	0.64716	0.63792	0.64571	50498.0
2009-06-29	AD	Futures	0.85743	0.85872	0.8518	0.85437	44725.0
2009-06-29	B	Futures	65.91	68.57	65.43	68.18	44390.0
2009-06-29	B6	Futures	1.7193	1.7276	1.7108	1.7261	73833.0
2009-06-29	BFX	Futures	2289.8	2329.1	2289.8	2324.0	135.0
2009-06-29	BR	Futures	0.19753	0.19753	0.19753	0.19753	2.0
2009-06-29	BZ	Futures	72.82	72.93	72.75	72.75	4.0
2009-06-29	C	Futures	1750.0	1766.0	1701.0	1719.0	2485.0
2009-06-29	CB	Futures	72.189	72.331	71.905	71.905	18.0
2009-06-29	CC	Futures	2277.0	2304.0	2245.0	2271.0	3298.0
2009-06-29	CT	Futures	48.49	49.18	48.36	48.65	111.0
2009-06-29	DC	Futures	21.25	21.29	20.9	20.9	127.0
2009-06-29	DX	Futures	81.934	82.492	81.914	82.001	3848.0
2009-06-29	E1	Futures	1.22398	1.2261	1.21431	1.2249	30989.0
2009-06-29	E6	Futures	1.66883	1.67393	1.65945	1.67156	150162.0
2009-06-29	E7	Futures	1.652	1.6566	1.6425	1.6544	1929.0
2009-06-29	ED	Futures	93.7914	93.8055	93.7819	93.7961	105954.0
2009-06-29	ER	Futures	96.919	96.924	96.909	96.914	104282.0
2009-06-29	EW	Futures	554.1	561.8	550.7	559.6	20472.0
2009-06-29	FCE	Futures	2029.7	2091.4	2025.8	2080.3	113733.0
2009-06-29	FDAX	Futures	5209.4	5382.2	5201.7	5359.1	131959.0
2009-06-29	FESX	Futures	1415.9	1457.1	1411.7	1451.1	878955.0
2009-06-29	FEU3	Futures	97.495	97.495	97.49	97.49	157.0
2009-06-29	FGBL	Futures	92.02	92.19	91.89	92.08	411058.0
2009-06-29	FGBM	Futures	98.02	98.02	97.84	97.88	214935.0
2009-06-29	FGBS	Futures	104.046	104.056	103.902	103.921	303387.0
2009-06-29	FGBX	Futures	82.52	82.9	82.4	82.78	1051.0
2009-06-29	FTDX	Futures	547.0	558.6	544.3	557.7	519.0
2009-06-29	FTI	Futures	205.9	210.37	205.33	209.72	28045.0
2009-06-29	FTUK	Futures	2785.1	2836.2	2784.7	2825.5	87024.0
2009-06-29	G	Futures	75.73	76.25	75.73	76.18	67921.0
2009-06-29	GF	Futures	272.736	281.074	272.392	280.385	3697.0
2009-06-29	GSCI	Futures	948.19	963.42	946.1	961.75	208.0
2009-06-29	HE	Futures	83.744	85.864	83.196	84.84	6080.0
2009-06-29	HG	Futures	3.2239	3.3095	3.167	3.266	13411.0
2009-06-29	HO	Futures	1.8488	1.9186	1.8407	1.9049	9436.0
2009-06-29	HRC	Futures	2382.2	2382.2	2382.2	2382.2	0.0
2009-06-29	J1	Futures	0.0132224	0.0132413	0.0131015	0.0131242	57638.0
2009-06-29	J7	Futures	0.013025	0.013039	0.012921	0.012943	28.0
2009-06-29	JB	Futures	115.93	116.19	115.88	116.19	2061.0
2009-06-29	KC	Futures	322.9	330.22	321.54	326.29	4690.0
2009-06-29	KE	Futures	2875.41	2898.2	2829.85	2839.44	11123.0
2009-06-29	L	Futures	97.121	97.131	97.092	97.101	26218.0
2009-06-29	LBS	Futures	923.2	925.5	891.2	893.5	600.0

> showing 50 of 86 rows — these rows as CSV

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