PREVIEW / etf_daily / 2005-01-19

all etf daily files

  file:    by_date/etf_daily/2005/2005-01-19.parquet
  size:    14 KB
  rows:    249

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-01-19	SPY	ETF	119.43	119.52	118.21	118.22	54378900.0
2005-01-19	QQQ	ETF	38.75	38.75	38.06	38.08	105302893.0
2005-01-19	IWM	ETF	62.145	62.375	61.285	61.285	20194800.0
2005-01-19	DIA	ETF	106.15	106.25	105.23	105.25	6567900.0
2005-01-19	GLD	ETF	42.65	42.65	42.2	42.26	1578900.0
2005-01-19	TLT	ETF	90.8	90.84	90.27	90.73	655800.0
2005-01-19	AAA	ETF	57.73	57.73	57.1	57.23	7900.0
2005-01-19	ADRE	ETF	81.089	81.089	80.442	80.442	2816.0
2005-01-19	AFK	ETF	26.56	26.59	26.51	26.57	7800.0
2005-01-19	AGG	ETF	102.77	102.85	102.59	102.84	88300.0
2005-01-19	AIQ	ETF	67.5	67.5	62.5	63.55	94360.0
2005-01-19	ARB	ETF	38.0	38.1	37.43	37.56	181000.0
2005-01-19	BAB	ETF	47.31	47.31	46.66	46.66	33200.0
2005-01-19	BBH	ETF	49.8667	49.8667	49.2333	49.3767	1830900.0
2005-01-19	BCM	ETF	57.04	57.04	56.22	56.45	42900.0
2005-01-19	BITS	ETF	10.0	10.28	9.4	10.28	25055.0
2005-01-19	BKF	ETF	35.9	36.25	35.15	36.1	146100.0
2005-01-19	BNE	ETF	15.12	15.12	14.94	14.95	297500.0
2005-01-19	BRF	ETF	15.68	15.68	15.59	15.61	6400.0
2005-01-19	BTF	ETF	90.5	90.5	89.60000000000001	90.25	780.0
2005-01-19	CBON	ETF	29.1	29.1	27.78	28.0	27922.0
2005-01-19	CDC	ETF	10.4	10.4	10.4	10.4	200.0
2005-01-19	CDL	ETF	14.23	14.23	13.99	14.05	235700.0
2005-01-19	CEF	ETF	5.32	5.32	5.2	5.23	380600.0
2005-01-19	CHB	ETF	11.35	11.56	11.04	11.18	503800.0
2005-01-19	CHIC	ETF	10.01	10.2	9.78	10.1	712474.0
2005-01-19	CHIR	ETF	35.2101	35.2101	34.1601	34.41	1600061.0
2005-01-19	CID	ETF	9.4	9.44	9.4	9.44	3500.0
2005-01-19	CIL	ETF	26.18	26.18	26.18	26.18	400.0
2005-01-19	CIZ	ETF	20.25	20.25	20.25	20.25	700.0
2005-01-19	CN	ETF	28.19	28.19	28.0	28.05	59700.0
2005-01-19	CNXT	ETF	1.68	1.69	1.589	1.6	5726764.0
2005-01-19	CSB	ETF	36.35	36.66	36.35	36.65	2100.0
2005-01-19	CTEC	ETF	46.5	51.25	46.5	50.25	52804.600000000006
2005-01-19	CURE	ETF	0.6687	0.6775	0.6591	0.6725	1031000.0
2005-01-19	CYA	ETF	209.6	209.6	205.4	205.4	300.0
2005-01-19	CYB	ETF	4.61	4.61	4.35	4.4	8300.0
2005-01-19	CZA	ETF	10.35	10.6	10.35	10.5	6000.0
2005-01-19	DGT	ETF	63.29	63.29	62.92	62.92	1900.0
2005-01-19	DIV	ETF	14.1	14.16	14.1	14.11	12500.0
2005-01-19	DJP	ETF	26.7	26.73	26.7	26.72	2400.0
2005-01-19	DRIV	ETF	34.23	34.98	33.4	33.57	995099.0
2005-01-19	DSI	ETF	5.925	5.95	5.925	5.95	13600.0
2005-01-19	DTH	ETF	25.48	25.48	25.38	25.38	800.0
2005-01-19	DUSA	ETF	15.9	16.3	14.99	15.02	211609.0
2005-01-19	DVY	ETF	59.99	60.03	59.45	59.55	538200.0
2005-01-19	EDEN	ETF	1.26	1.37	1.18	1.19	234878.0
2005-01-19	EDV	ETF	26.35	26.38	26.31	26.38	5800.0
2005-01-19	EEM	ETF	21.8867	21.8867	21.4778	21.4778	2631600.0
2005-01-19	EFA	ETF	52.2333	52.3467	51.6	51.6	2236500.0

> showing 50 of 249 rows — these rows as CSV

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