PREVIEW / etf_daily / 2005-09-22

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-22.parquet
  size:    15 KB
  rows:    282

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-09-22	SPY	ETF	120.95	121.66	120.44	121.34	84597200.0
2005-09-22	QQQ	ETF	38.44	38.73	38.24	38.64	119165195.0
2005-09-22	IWM	ETF	64.67	65.12	64.1	64.93	34380600.0
2005-09-22	DIA	ETF	103.74	104.4	103.44	104.04	7931300.0
2005-09-22	GLD	ETF	46.84	46.84	46.22	46.36	2347300.0
2005-09-22	TLT	ETF	93.37	93.45	93.13	93.31	761700.0
2005-09-22	AAA	ETF	55.5	55.69	55.4	55.69	1500.0
2005-09-22	ADRE	ETF	107.19	107.19	104.8501	105.58	18912.0
2005-09-22	AFK	ETF	25.52	25.52	25.44	25.52	3700.0
2005-09-22	AGG	ETF	102.09	102.2	101.92	102.05	396000.0
2005-09-22	AIQ	ETF	40.85	42.4	40.25	41.65	71980.0
2005-09-22	AIS	ETF	0.86	0.86	0.83	0.85	69400.0
2005-09-22	ARB	ETF	40.0	40.35	39.47	40.07	77600.0
2005-09-22	BAB	ETF	50.92	51.28	50.9	51.23	21500.0
2005-09-22	BBC	ETF	7.79	7.79	7.5	7.55	72400.0
2005-09-22	BBH	ETF	64.8333	65.4533	64.2933	64.8433	2080500.0
2005-09-22	BCM	ETF	63.01	63.17	62.75	62.76	32400.0
2005-09-22	BIS	ETF	656.0	656.0	652.8	654.4	24.4
2005-09-22	BITS	ETF	12.0	12.0	11.52	11.56	2321.0
2005-09-22	BKF	ETF	31.25	31.4	30.9	31.39	34600.0
2005-09-22	BNE	ETF	14.0	14.1	13.89	14.0	128100.0
2005-09-22	BRF	ETF	15.42	15.42	15.42	15.42	1300.0
2005-09-22	BTF	ETF	85.55	86.4	85.19999999999999	85.99999999999999	8000.0
2005-09-22	CBON	ETF	32.9	32.9	32.5	32.72	1605.0
2005-09-22	CDC	ETF	3.5	3.55	3.5	3.54	8900.0
2005-09-22	CDL	ETF	13.1	13.1	12.88	12.97	384500.0
2005-09-22	CEF	ETF	5.64	5.64	5.53	5.6	440100.0
2005-09-22	CEW	ETF	25.9	25.9	25.89	25.89	300.0
2005-09-22	CHB	ETF	14.75	14.95	14.09	14.44	1505400.0
2005-09-22	CHI	ETF	20.21	20.29	20.11	20.21	86000.0
2005-09-22	CHIC	ETF	13.39	14.1	13.35	13.93	396711.0
2005-09-22	CHIR	ETF	43.4799	43.6401	43.35	43.4499	1285889.0
2005-09-22	CHY	ETF	16.31	16.4	16.24	16.3	98600.0
2005-09-22	CIL	ETF	25.95	25.95	25.95	25.95	300.0
2005-09-22	CN	ETF	34.4	34.4	33.85	34.1	15300.0
2005-09-22	CNXT	ETF	1.84	1.84	1.71	1.78	17280191.0
2005-09-22	CPST	ETF	4.31	4.39	4.09	4.15	4343499.0
2005-09-22	CSB	ETF	29.33	29.47	29.22	29.3	8800.0
2005-09-22	CSM	ETF	2.425	2.425	2.425	2.425	6000.0
2005-09-22	CSQ	ETF	13.77	13.8	13.61	13.7	366700.0
2005-09-22	CTEC	ETF	53.4	53.449999999999996	50.3	52.64999999999999	8566.0
2005-09-22	CURE	ETF	0.2188	0.22	0.2025	0.2075	1975536.0
2005-09-22	CYA	ETF	58.0	63.2	58.0	63.2	555.0
2005-09-22	CYB	ETF	3.99	4.042	3.964	4.04	19100.0
2005-09-22	DGT	ETF	64.5	64.5	64.42	64.49	2000.0
2005-09-22	DIG	ETF	14.5	14.625	14.5	14.5	2480.0
2005-09-22	DIV	ETF	13.3	13.38	13.12	13.12	16700.0
2005-09-22	DRIV	ETF	34.82	35.5	34.35	35.35	1072254.0
2005-09-22	DSI	ETF	5.645	5.645	5.625	5.625	2000.0
2005-09-22	DUSA	ETF	9.5	9.67	9.29	9.64	78351.0

> showing 50 of 282 rows — these rows as CSV

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