PREVIEW / etf_daily / 2005-01-24

all etf daily files

  file:    by_date/etf_daily/2005/2005-01-24.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-24	SPY	ETF	117.09	117.34	116.37	116.55	58441900.0
2005-01-24	QQQ	ETF	37.14	37.2	36.46	36.53	137586438.0
2005-01-24	IWM	ETF	60.96	61.25	60.085	60.315	18547200.0
2005-01-24	DIA	ETF	104.11	104.31	103.62	103.75	9877700.0
2005-01-24	GLD	ETF	42.74	42.82	42.67	42.77	2294900.0
2005-01-24	TLT	ETF	91.09	91.5	91.0	91.4	561400.0
2005-01-24	AAA	ETF	57.5	57.5	57.23	57.25	3800.0
2005-01-24	ADRE	ETF	81.8	81.8	79.316	79.316	5624.0
2005-01-24	AFK	ETF	26.47	26.47	26.44	26.44	13200.0
2005-01-24	AGG	ETF	103.04	103.08	102.9	103.05	85200.0
2005-01-24	AIQ	ETF	64.75	65.7	62.55	62.8	38540.0
2005-01-24	ARB	ETF	37.55	37.8	37.2	37.3	176200.0
2005-01-24	BAB	ETF	45.66	46.04	45.45	45.73	71800.0
2005-01-24	BBH	ETF	48.4333	48.49	47.05	47.4833	5577300.0
2005-01-24	BCM	ETF	55.72	55.72	55.28	55.52	20500.0
2005-01-24	BIS	ETF	944.0	948.8	940.8	948.8	11.25
2005-01-24	BITS	ETF	10.44	10.72	9.72	9.72	6878.0
2005-01-24	BKF	ETF	36.7	37.08	36.7	36.76	13200.0
2005-01-24	BNE	ETF	14.96	14.96	14.68	14.72	79700.0
2005-01-24	BRF	ETF	15.62	15.62	15.61	15.61	2500.0
2005-01-24	BTF	ETF	90.5	90.5	90.35	90.44999999999999	2700.0
2005-01-24	CBON	ETF	28.49	28.49	27.75	28.07	9398.0
2005-01-24	CDC	ETF	9.0	9.0	8.5	8.55	5200.0
2005-01-24	CDL	ETF	14.13	14.24	13.97	14.11	273600.0
2005-01-24	CEF	ETF	5.31	5.35	5.28	5.3	177700.0
2005-01-24	CGW	ETF	28.2	28.2	27.85	27.85	500.0
2005-01-24	CHB	ETF	10.85	10.95	10.12	10.18	492900.0
2005-01-24	CHIC	ETF	9.5	9.5	9.13	9.48	447896.0
2005-01-24	CHIR	ETF	34.14	34.4601	33.3501	33.6201	2388658.0
2005-01-24	CID	ETF	9.19	9.19	9.15	9.19	1900.0
2005-01-24	CIL	ETF	26.45	26.45	26.45	26.45	1000.0
2005-01-24	CIZ	ETF	20.1	20.1	20.1	20.1	200.0
2005-01-24	CN	ETF	28.15	28.15	27.8	27.9	110900.0
2005-01-24	CNXT	ETF	1.63	1.64	1.52	1.53	5259766.0
2005-01-24	CPI	ETF	22.0	22.5	20.77	20.77	2600.0
2005-01-24	CSB	ETF	35.8	35.9	35.76	35.76	500.0
2005-01-24	CTEC	ETF	49.949999999999996	51.25	49.949999999999996	50.99999999999999	22265.2
2005-01-24	CURE	ETF	0.6637	0.6675	0.635	0.6462	976640.0
2005-01-24	CYA	ETF	177.0	177.0	167.0	172.0	575.0
2005-01-24	CYB	ETF	4.3	4.3	4.0	4.1	23000.0
2005-01-24	CZA	ETF	10.22	10.22	10.22	10.22	2500.0
2005-01-24	DGT	ETF	62.53	62.7	62.44	62.51	7300.0
2005-01-24	DIG	ETF	12.1875	12.2	12.1875	12.1875	1600.0
2005-01-24	DIV	ETF	14.1	14.18	14.08	14.16	6400.0
2005-01-24	DJP	ETF	26.6	26.6	26.6	26.6	900.0
2005-01-24	DRIV	ETF	32.52	33.08	31.75	31.91	830231.0
2005-01-24	DSI	ETF	5.895	5.895	5.895	5.895	1000.0
2005-01-24	DTH	ETF	25.38	25.39	25.34	25.34	1700.0
2005-01-24	DUSA	ETF	14.44	14.54	13.8	13.84	247661.0
2005-01-24	DVY	ETF	59.35	59.35	58.97	59.04	484200.0

> showing 50 of 249 rows — these rows as CSV

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