PREVIEW / etf_daily / 2005-06-28

all etf daily files

  file:    by_date/etf_daily/2005/2005-06-28.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-06-28	SPY	ETF	119.4	120.24	119.37	120.15	41174200.0
2005-06-28	QQQ	ETF	36.95	37.26	36.9	37.15	73382074.0
2005-06-28	IWM	ETF	62.77	63.86	62.72	63.34	18261700.0
2005-06-28	DIA	ETF	103.18	104.0	103.17	103.98	6487600.0
2005-06-28	GLD	ETF	43.64	43.64	43.37	43.45	1295600.0
2005-06-28	TLT	ETF	96.32	96.37	95.91	95.99	982400.0
2005-06-28	AAA	ETF	56.9	57.37	56.9	57.37	67600.0
2005-06-28	ADRE	ETF	90.25	91.79	90.25	91.71	3420.0
2005-06-28	AFK	ETF	26.3	26.3	26.03	26.16	16200.0
2005-06-28	AGG	ETF	103.25	103.34	103.09	103.1	93800.0
2005-06-28	AIQ	ETF	52.2	54.75	51.75	53.6	40320.0
2005-06-28	AIS	ETF	1.0	1.05	0.992	1.02	95100.0
2005-06-28	ARB	ETF	42.06	42.72	42.01	42.58	220300.0
2005-06-28	BAB	ETF	47.91	48.65	47.72	48.64	26000.0
2005-06-28	BBH	ETF	55.6667	56.7333	55.6167	56.6667	1386000.0
2005-06-28	BCM	ETF	62.31	62.79	62.0	62.6	14500.0
2005-06-28	BIS	ETF	614.4	614.4	576.0	608.0	30.0
2005-06-28	BITS	ETF	12.2	15.64	12.2	12.72	60831.0
2005-06-28	BKF	ETF	37.76	37.76	37.25	37.49	31300.0
2005-06-28	BNE	ETF	14.25	15.15	14.2	15.14	1401200.0
2005-06-28	BOSS	ETF	25.53	25.53	25.53	25.53	500.0
2005-06-28	BRF	ETF	15.48	15.52	15.42	15.49	14400.0
2005-06-28	BTF	ETF	85.35	85.85000000000001	84.55	85.6	4760.0
2005-06-28	CBON	ETF	31.31	31.53	30.73	31.5	21017.0
2005-06-28	CDC	ETF	6.53	6.65	6.53	6.65	1300.0
2005-06-28	CDL	ETF	12.04	12.18	12.03	12.1	289300.0
2005-06-28	CEF	ETF	5.32	5.34	5.29	5.31	199900.0
2005-06-28	CEW	ETF	26.65	26.65	26.65	26.65	2200.0
2005-06-28	CHB	ETF	9.8	10.0	9.75	9.99	309800.0
2005-06-28	CHI	ETF	19.39	19.48	19.37	19.43	58000.0
2005-06-28	CHIC	ETF	12.26	12.51	12.25	12.37	186705.0
2005-06-28	CHIR	ETF	35.13	35.67	34.92	35.6301	1712861.0
2005-06-28	CHY	ETF	16.4	16.45	16.33	16.38	153100.0
2005-06-28	CIL	ETF	25.6	25.84	25.6	25.65	2800.0
2005-06-28	CN	ETF	29.1	29.1	28.9	29.0	157000.0
2005-06-28	CNXT	ETF	1.5	1.53	1.47	1.5	4663560.0
2005-06-28	CPI	ETF	23.6	23.6	23.45	23.45	700.0
2005-06-28	CPST	ETF	1.28	1.34	1.23	1.33	618352.0
2005-06-28	CSB	ETF	29.1	29.67	29.09	29.11	13300.0
2005-06-28	CSQ	ETF	13.7	13.96	13.67	13.94	444900.0
2005-06-28	CTEC	ETF	52.85	57.144999999999996	52.85	56.6	15225.400000000001
2005-06-28	CURE	ETF	0.32	0.3438	0.285	0.2938	4470032.0
2005-06-28	CYA	ETF	135.8	135.8	135.0	135.0	250.0
2005-06-28	CYB	ETF	3.29	3.36	3.2	3.3	12400.0
2005-06-28	DGT	ETF	63.5	63.6	63.38	63.48	3700.0
2005-06-28	DIG	ETF	12.425	12.425	12.3125	12.3125	1280.0
2005-06-28	DIV	ETF	13.64	13.65	13.58	13.65	21100.0
2005-06-28	DRIV	ETF	30.65	32.1	30.62	31.83	675669.0
2005-06-28	DSI	ETF	5.79	5.8	5.79	5.8	1000.0
2005-06-28	DUSA	ETF	9.0	9.15	8.92	9.15	142509.0

> showing 50 of 275 rows — these rows as CSV

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