PREVIEW / futures_daily / 2009-06-17

all futures daily files

  file:    by_date/futures_daily/2009/2009-06-17.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-17	ES	Futures	871.17	877.17	862.78	868.53	2362146.0
2009-06-17	NQ	Futures	1625.9	1654.9	1619.14	1636.88	401376.0
2009-06-17	YM	Futures	7632.1	7676.3	7584.3	7612.3	146883.0
2009-06-17	CL	Futures	186.81	189.42	183.39	188.65	148107.0
2009-06-17	GC	Futures	1295.0	1302.9	1285.3	1295.9	87651.0
2009-06-17	ZN	Futures	90.805767	91.23671	90.461013	90.891955	844828.0
2009-06-17	A6	Futures	0.63261	0.6384	0.62659	0.63487	74846.0
2009-06-17	AD	Futures	0.87067	0.8763	0.86306	0.87403	64480.0
2009-06-17	B	Futures	66.96	68.03	66.02	67.77	107402.0
2009-06-17	B6	Futures	1.7071	1.7163	1.6891	1.7108	113030.0
2009-06-17	BFX	Futures	2266.5	2266.5	2226.5	2238.9	1704.0
2009-06-17	BR	Futures	0.19188	0.19481	0.19188	0.19481	29.0
2009-06-17	BZ	Futures	72.51	73.96	72.42	73.96	35.0
2009-06-17	C	Futures	1791.0	1791.0	1745.0	1747.0	3004.0
2009-06-17	CB	Futures	73.042	73.184	73.042	73.184	1.0
2009-06-17	CC	Futures	2345.0	2345.0	2250.0	2258.0	9465.0
2009-06-17	CT	Futures	48.45	48.85	48.11	48.14	8537.0
2009-06-17	DC	Futures	21.65	21.68	21.09	21.27	202.0
2009-06-17	DX	Futures	83.091	83.27	82.328	82.472	4911.0
2009-06-17	E1	Futures	1.21696	1.23152	1.21286	1.22901	42101.0
2009-06-17	E6	Futures	1.64081	1.65909	1.6376	1.6566	208008.0
2009-06-17	E7	Futures	1.6244	1.6419	1.621	1.6396	2809.0
2009-06-17	ED	Futures	93.73	93.7394	93.6969	93.7158	201678.0
2009-06-17	ER	Futures	96.777	96.806	96.772	96.797	121348.0
2009-06-17	EW	Futures	550.8	557.2	544.3	550.1	38827.0
2009-06-17	FCE	Futures	2080.0	2093.0	2045.1	2060.7	125476.0
2009-06-17	FDAX	Futures	5337.2	5368.5	5228.6	5281.2	59966.0
2009-06-17	FESX	Futures	1433.8	1440.4	1406.4	1419.5	1287433.0
2009-06-17	FEU3	Futures	97.362	97.382	97.362	97.377	1167.0
2009-06-17	FGBL	Futures	90.86	91.21	90.81	91.1	634234.0
2009-06-17	FGBM	Futures	96.95	97.25	96.91	97.18	342635.0
2009-06-17	FGBS	Futures	103.502	103.651	103.483	103.618	658038.0
2009-06-17	FGBX	Futures	81.61	82.13	81.61	81.94	1288.0
2009-06-17	FTDX	Futures	555.0	557.7	535.4	538.0	6058.0
2009-06-17	FTI	Futures	208.1	208.3	202.44	204.23	20652.0
2009-06-17	FTUK	Futures	2834.8	2852.8	2803.0	2815.9	180143.0
2009-06-17	G	Futures	74.64	75.27	74.56	75.14	112326.0
2009-06-17	GF	Futures	265.432	268.877	265.294	268.257	882.0
2009-06-17	GSCI	Futures	956.32	973.32	951.63	973.32	383.0
2009-06-17	HE	Futures	85.901	88.24	85.608	87.655	5817.0
2009-06-17	HG	Futures	3.1487	3.2099	3.1163	3.1789	20518.0
2009-06-17	HO	Futures	1.9201	1.9585	1.8974	1.9566	8591.0
2009-06-17	HRC	Futures	2402.6	2402.6	2328.7	2328.7	17.0
2009-06-17	J1	Futures	0.0130688	0.0131909	0.0130197	0.0131657	84263.0
2009-06-17	J7	Futures	0.012895	0.013007	0.012847	0.012984	55.0
2009-06-17	JB	Futures	114.88	115.09	114.88	115.09	2208.0
2009-06-17	KC	Futures	341.09	341.51	327.79	328.21	7465.0
2009-06-17	KE	Futures	3029.07	3061.98	2988.84	3036.38	8064.0
2009-06-17	L	Futures	97.013	97.043	96.993	97.003	49858.0
2009-06-17	LBS	Futures	970.6	986.2	960.1	965.6	324.0

> showing 50 of 86 rows — these rows as CSV

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