PREVIEW / etf_daily / 2005-12-28

all etf daily files

  file:    by_date/etf_daily/2005/2005-12-28.parquet
  size:    16 KB
  rows:    297

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-12-28	SPY	ETF	125.74	125.99	125.5	125.75	30764300.0
2005-12-28	QQQ	ETF	41.06	41.23	40.87	40.99	50315397.0
2005-12-28	IWM	ETF	67.34	67.69	66.96	67.51	20488800.0
2005-12-28	DIA	ETF	107.99	108.15	107.69	107.85	4159700.0
2005-12-28	GLD	ETF	51.51	51.61	51.18	51.47	5060900.0
2005-12-28	TLT	ETF	92.03	92.25	91.75	91.91	1295700.0
2005-12-28	AAA	ETF	54.99	55.0	54.8	54.8	1300.0
2005-12-28	ADRE	ETF	116.0	116.0	114.8	115.2	9608.0
2005-12-28	AFK	ETF	25.21	25.24	25.15	25.21	5000.0
2005-12-28	AGG	ETF	100.68	100.68	100.28	100.4	1387300.0
2005-12-28	AIQ	ETF	28.75	29.0	28.5	28.85	11040.0
2005-12-28	AIS	ETF	1.41	1.44	1.38	1.44	180000.0
2005-12-28	AOM	ETF	4.05	4.11	4.05	4.11	2800.0
2005-12-28	ARB	ETF	38.65	38.77	38.37	38.57	50500.0
2005-12-28	BAB	ETF	58.1	58.29	57.53	57.97	15300.0
2005-12-28	BBC	ETF	15.15	15.94	14.7501	15.3	265900.0
2005-12-28	BBH	ETF	67.6	67.9833	67.2933	67.42	731100.0
2005-12-28	BCM	ETF	66.0	66.4	65.64	66.0	18000.0
2005-12-28	BITS	ETF	14.336	15.0	14.336	15.0	3925.0
2005-12-28	BKF	ETF	20.01	20.06	19.88	20.01	67600.0
2005-12-28	BNE	ETF	14.92	15.08	14.92	14.99	41000.0
2005-12-28	BRF	ETF	15.22	15.22	15.0	15.09	18600.0
2005-12-28	BTF	ETF	85.5	85.5	84.55	84.55	1280.0
2005-12-28	CBON	ETF	31.82	32.07	31.77	31.97	2260.0
2005-12-28	CDL	ETF	13.9	13.91	13.2	13.35	415300.0
2005-12-28	CEF	ETF	6.52	6.68	6.52	6.68	530800.0
2005-12-28	CEW	ETF	26.0	26.0	26.0	26.0	100.0
2005-12-28	CFO	ETF	9.9	9.9	9.9	9.9	700.0
2005-12-28	CGO	ETF	13.3	13.7	13.2	13.7	154400.0
2005-12-28	CHB	ETF	13.75	14.0	13.63	13.65	591900.0
2005-12-28	CHI	ETF	19.79	20.05	19.79	20.02	80900.0
2005-12-28	CHIC	ETF	19.65	20.77	19.54	20.59	238476.0
2005-12-28	CHIR	ETF	44.6199	44.7	44.5401	44.6001	557770.0
2005-12-28	CHY	ETF	15.78	15.88	15.75	15.82	66600.0
2005-12-28	CIL	ETF	25.4	25.4	25.4	25.4	200.0
2005-12-28	CN	ETF	32.0	32.25	31.6	31.9	44200.0
2005-12-28	CNXT	ETF	2.27	2.31	2.25	2.29	5218443.0
2005-12-28	CPST	ETF	2.925	3.34	2.75	3.31	11408189.0
2005-12-28	CSA	ETF	16.88	16.97	16.88	16.97	52900.0
2005-12-28	CSB	ETF	32.06	32.2	31.72	31.96	13500.0
2005-12-28	CSM	ETF	2.45	2.45	2.45	2.45	3600.0
2005-12-28	CSQ	ETF	13.31	13.53	13.21	13.48	602700.0
2005-12-28	CTEC	ETF	47.0	47.64999999999999	46.8	46.9	4012.6000000000004
2005-12-28	CURE	ETF	0.0338	0.0362	0.031	0.0325	7014680.0
2005-12-28	CYB	ETF	3.47	3.48	3.47	3.48	200.0
2005-12-28	DGT	ETF	65.27	65.35	65.24	65.24	900.0
2005-12-28	DIG	ETF	16.125	16.125	16.125	16.125	1200.0
2005-12-28	DIV	ETF	12.1	12.17	12.06	12.1	60500.0
2005-12-28	DRIV	ETF	30.02	30.15	29.41	29.85	723863.0
2005-12-28	DSI	ETF	6.03	6.045	6.03	6.045	6400.0

> showing 50 of 297 rows — these rows as CSV

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