PREVIEW / etf_daily / 2005-10-20

all etf daily files

  file:    by_date/etf_daily/2005/2005-10-20.parquet
  size:    15 KB
  rows:    275

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
2005-10-20	SPY	ETF	119.49	119.81	117.3	117.67	131966700.0
2005-10-20	QQQ	ETF	38.66	38.85	38.1	38.306	132676911.0
2005-10-20	IWM	ETF	63.4	63.65	61.88	62.33	47278000.0
2005-10-20	DIA	ETF	104.06	104.38	102.49	102.78	10696000.0
2005-10-20	GLD	ETF	46.33	46.34	45.83	45.98	1680300.0
2005-10-20	TLT	ETF	90.28	90.6	90.13	90.59	810300.0
2005-10-20	AAA	ETF	54.74	55.17	54.67	54.75	2000.0
2005-10-20	ADRE	ETF	100.1	100.5699	97.69	97.863	16436.0
2005-10-20	AFK	ETF	25.64	25.64	25.42	25.58	2700.0
2005-10-20	AGG	ETF	100.74	100.83	100.55	100.82	145000.0
2005-10-20	AIQ	ETF	36.25	36.5495	35.25	36.0	21400.0
2005-10-20	AIS	ETF	1.14	1.14	1.0	1.07	254800.0
2005-10-20	ARB	ETF	39.2	39.4	38.52	38.9	335400.0
2005-10-20	BAB	ETF	52.26	52.26	51.25	51.3	41900.0
2005-10-20	BBC	ETF	7.35	7.42	7.11	7.13	19000.0
2005-10-20	BBH	ETF	62.3667	62.4933	61.5333	61.7	2514000.0
2005-10-20	BCM	ETF	60.14	60.21	59.75	59.87	16900.0
2005-10-20	BIS	ETF	633.6	633.6	633.6	633.6	9.4
2005-10-20	BITS	ETF	10.8	11.2	10.8	11.12	1475.0
2005-10-20	BKF	ETF	17.11	17.75	16.99	17.18	217400.0
2005-10-20	BNE	ETF	13.34	13.58	13.25	13.42	94900.0
2005-10-20	BRF	ETF	15.27	15.37	15.27	15.37	4300.0
2005-10-20	BTF	ETF	84.64999999999999	84.64999999999999	84.0	84.55	820.0
2005-10-20	CBON	ETF	31.05	32.61	31.05	32.49	41482.0
2005-10-20	CDL	ETF	13.76	13.8	13.47	13.57	156800.0
2005-10-20	CEF	ETF	5.65	5.73	5.59	5.6	416000.0
2005-10-20	CHB	ETF	13.67	13.9	13.47	13.81	1120200.0
2005-10-20	CHI	ETF	19.25	19.46	19.181	19.46	78800.0
2005-10-20	CHIC	ETF	17.46	17.9	17.2	17.23	561523.0
2005-10-20	CHIR	ETF	43.2699	43.4499	42.8301	42.9999	1369141.0
2005-10-20	CHY	ETF	15.51	15.65	15.49	15.56	104900.0
2005-10-20	CN	ETF	31.68	31.75	30.96	31.05	16600.0
2005-10-20	CNXT	ETF	1.82	1.94	1.8	1.93	13101468.0
2005-10-20	CPST	ETF	2.4	2.45	2.25	2.27	6901922.0
2005-10-20	CSB	ETF	28.7	29.06	28.36	28.37	6600.0
2005-10-20	CSM	ETF	2.4375	2.4375	2.4375	2.4375	4000.0
2005-10-20	CSQ	ETF	13.43	13.44	13.18	13.24	248500.0
2005-10-20	CTEC	ETF	45.3	47.24999999999999	45.3	46.9	4110.0
2005-10-20	CURE	ETF	0.095	0.1	0.0938	0.0988	955024.0
2005-10-20	CYB	ETF	3.2	3.2	3.1	3.19	4900.0
2005-10-20	DGT	ETF	62.52	62.52	62.01	62.22	5800.0
2005-10-20	DIV	ETF	11.94	12.0499	11.91	11.96	7900.0
2005-10-20	DRIV	ETF	36.36	36.98	36.31	36.43	882489.0
2005-10-20	DSI	ETF	5.77	5.77	5.745	5.745	15200.0
2005-10-20	DUSA	ETF	9.15	9.28	9.1	9.18	159400.0
2005-10-20	DVY	ETF	59.91	60.14	58.95	59.25	927100.0
2005-10-20	EDEN	ETF	0.72	0.72	0.66	0.67	15866.0
2005-10-20	EDV	ETF	25.44	25.53	25.44	25.49	5800.0
2005-10-20	EEM	ETF	26.0667	26.23	24.95	25.05	8560800.0
2005-10-20	EFA	ETF	55.44	55.46	54.55	54.72	2368500.0

> showing 50 of 275 rows — these rows as CSV

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