PREVIEW / futures_daily / 2009-05-18

all futures daily files

  file:    by_date/futures_daily/2009/2009-05-18.parquet
  size:    8 KB
  rows:    83

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-05-18	ES	Futures	840.87	866.12	834.19	864.46	1928363.0
2009-05-18	NQ	Futures	1519.27	1564.49	1508.31	1559.99	271860.0
2009-05-18	YM	Futures	7413.6	7614.5	7333.8	7597.5	139451.0
2009-05-18	CL	Futures	152.33	159.52	151.11	158.64	222291.0
2009-05-18	GC	Futures	1288.4	1293.4	1267.2	1276.2	97047.0
2009-05-18	ZN	Futures	94.342309	94.572915	93.662627	93.856822	556584.0
2009-05-18	A6	Futures	0.59662	0.61034	0.59303	0.6081	40923.0
2009-05-18	AD	Futures	0.8354	0.8484	0.83333	0.84623	42006.0
2009-05-18	B	Futures	54.1	56.69	53.85	56.32	105221.0
2009-05-18	B6	Futures	1.5793	1.5971	1.5725	1.5936	66836.0
2009-05-18	BFX	Futures	2281.4	2334.5	2276.4	2323.4	351.0
2009-05-18	BZ	Futures	60.47	61.29	60.39	61.03	52.0
2009-05-18	C	Futures	1744.0	1744.0	1696.0	1708.0	4299.0
2009-05-18	CC	Futures	2071.0	2077.0	2022.0	2027.0	4499.0
2009-05-18	CT	Futures	51.9	53.39	51.37	53.25	6941.0
2009-05-18	DC	Futures	24.58	24.91	24.55	24.72	166.0
2009-05-18	DX	Futures	85.47	85.815	85.017	85.218	4055.0
2009-05-18	E1	Futures	1.18313	1.19082	1.1769	1.18857	30568.0
2009-05-18	E6	Futures	1.59817	1.60789	1.59094	1.60433	149212.0
2009-05-18	E7	Futures	1.5793	1.5892	1.5727	1.5857	1375.0
2009-05-18	ED	Futures	93.5606	93.6219	93.5606	93.5983	215919.0
2009-05-18	ER	Futures	96.836	96.865	96.826	96.86	174705.0
2009-05-18	EW	Futures	525.8	547.4	521.4	545.4	26210.0
2009-05-18	FCE	Futures	2007.7	2092.3	1991.7	2078.6	117738.0
2009-05-18	FDAX	Futures	5091.6	5327.4	5074.2	5278.4	163985.0
2009-05-18	FESX	Futures	1384.3	1455.1	1379.5	1440.1	1168437.0
2009-05-18	FEU3	Futures	97.411	97.441	97.411	97.441	2544.0
2009-05-18	FGBL	Futures	91.55	91.74	91.3	91.57	449577.0
2009-05-18	FGBM	Futures	97.77	97.9	97.66	97.82	330729.0
2009-05-18	FGBS	Futures	103.949	104.007	103.925	103.992	305207.0
2009-05-18	FGBX	Futures	81.28	81.41	80.81	81.14	739.0
2009-05-18	FTDX	Futures	531.5	562.1	531.5	548.6	1006.0
2009-05-18	FTI	Futures	204.73	213.88	204.65	213.38	31860.0
2009-05-18	FTUK	Futures	2859.2	2963.1	2849.5	2938.1	99934.0
2009-05-18	G	Futures	76.51	76.81	76.5	76.72	67356.0
2009-05-18	GF	Futures	280.316	281.556	279.971	280.661	559.0
2009-05-18	GSCI	Futures	868.25	882.33	865.05	881.05	371.0
2009-05-18	HE	Futures	99.778	101.201	98.654	100.04	8025.0
2009-05-18	HG	Futures	2.8399	2.9186	2.7843	2.9151	15123.0
2009-05-18	HO	Futures	1.5479	1.6099	1.5479	1.5967	2710.0
2009-05-18	HRC	Futures	2495.0	2495.0	2495.0	2495.0	0.0
2009-05-18	J1	Futures	0.013258	0.0133336	0.0130689	0.0130752	72842.0
2009-05-18	J7	Futures	0.013072	0.013153	0.012894	0.012898	102.0
2009-05-18	JB	Futures	114.73	115.14	114.69	114.97	2563.0
2009-05-18	KC	Futures	353.42	360.07	352.04	358.55	4960.0
2009-05-18	KE	Futures	3075.39	3183.87	3022.97	3139.99	9686.0
2009-05-18	L	Futures	97.121	97.131	97.092	97.121	27912.0
2009-05-18	LBS	Futures	819.1	835.6	816.4	826.9	83.0
2009-05-18	LE	Futures	146.492	146.933	145.567	146.492	4575.0
2009-05-18	MP	Futures	0.03884	0.03958	0.03862	0.03933	8166.0

> showing 50 of 83 rows — these rows as CSV

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