PREVIEW / etf_daily / 2000-08-17

all etf daily files

  file:    by_date/etf_daily/2000/2000-08-17.parquet
  size:    8 KB
  rows:    77

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
2000-08-17	SPY	ETF	148.6875	150.4375	148.3438	150.1875	5652200.0
2000-08-17	QQQ	ETF	92.9375	95.875	92.875	95.75	14492400.0
2000-08-17	IWM	ETF	51.3438	51.8438	51.2188	51.625	358800.0
2000-08-17	DIA	ETF	110.0156	111.1094	110.0156	110.8438	590600.0
2000-08-17	BBH	ETF	58.5417	59.5	58.2708	58.9583	1059600.0
2000-08-17	BITS	ETF	13.5	13.625	12.0	12.25	5400.0
2000-08-17	BOSS	ETF	20.6	20.6	20.6	20.6	100.0
2000-08-17	CEF	ETF	3.25	3.3125	3.25	3.3125	21100.0
2000-08-17	CHB	ETF	6.13	6.19	6.06	6.19	9100.0
2000-08-17	CNXT	ETF	33.75	37.75	33.25	37.5	6302300.0
2000-08-17	CSB	ETF	2.15000009536743	2.15000009536743	2.15000009536743	2.15000009536743	10000.0
2000-08-17	EWA	ETF	10.5625	10.6875	10.5	10.6875	72100.0
2000-08-17	EWC	ETF	21.5625	21.6875	21.5	21.6875	25500.0
2000-08-17	EWD	ETF	29.4375	29.75	29.25	29.75	11400.0
2000-08-17	EWG	ETF	23.875	24.1875	23.875	24.125	42500.0
2000-08-17	EWH	ETF	13.875	14.0	13.75	13.9375	48300.0
2000-08-17	EWI	ETF	50.75	51.125	50.625	51.0	19600.0
2000-08-17	EWJ	ETF	54.75	55.0	54.25	55.0	149425.0
2000-08-17	EWK	ETF	14.0625	14.3125	14.0625	14.25	3400.0
2000-08-17	EWL	ETF	16.0625	16.4375	16.0625	16.375	12000.0
2000-08-17	EWM	ETF	24.5	24.75	24.25	24.5	15350.0
2000-08-17	EWN	ETF	24.75	24.75	24.5	24.75	4000.0
2000-08-17	EWO	ETF	8.125	8.125	8.0625	8.0625	5700.0
2000-08-17	EWP	ETF	27.0625	27.0625	26.8125	26.875	6400.0
2000-08-17	EWQ	ETF	28.375	28.5	28.3125	28.4375	16000.0
2000-08-17	EWS	ETF	15.875	16.375	15.875	16.375	52200.0
2000-08-17	EWT	ETF	37.0	37.125	37.0	37.125	550.0
2000-08-17	EWU	ETF	39.375	39.875	38.875	39.875	25150.0
2000-08-17	EWW	ETF	16.625	17.0	16.625	16.875	27200.0
2000-08-17	EWY	ETF	19.8125	20.3125	19.75	20.3125	7000.0
2000-08-17	EWZ	ETF	20.3125	20.3125	20.3125	20.3125	300.0
2000-08-17	EZU	ETF	39.3125	39.4688	39.25	39.2812	48000.0
2000-08-17	FCTR	ETF	14.0	14.3125	13.9375	14.3125	7500.0
2000-08-17	FMAR	ETF	5.0	5.0013	4.94	4.94	2400.0
2000-08-17	GLDB	ETF	5.0	5.5	4.9375	5.5	121600.0
2000-08-17	GSIG	ETF	24.25	25.31	24.12	24.87	228300.0
2000-08-17	IDU	ETF	39.125	39.3359	39.0	39.3359	2400.0
2000-08-17	IEV	ETF	39.4375	39.7109	39.4375	39.7109	42600.0
2000-08-17	IGLD	ETF	662.5	662.5	631.25	643.75	185.0
2000-08-17	IJH	ETF	10.3688	10.4453	10.3641	10.4438	704000.0
2000-08-17	IJJ	ETF	19.3594	19.3594	19.3008	19.3008	13200.0
2000-08-17	IJK	ETF	17.2383	17.5176	17.2383	17.5176	8000.0
2000-08-17	IJR	ETF	17.6771	17.6771	17.6771	17.6771	600.0
2000-08-17	IVE	ETF	62.5781	62.8594	62.5781	62.8594	400.0
2000-08-17	IVV	ETF	148.5312	150.2812	148.5	149.9219	96900.0
2000-08-17	IVW	ETF	22.1992	22.4922	22.1992	22.4766	30000.0
2000-08-17	IWB	ETF	79.0	79.2656	79.0	79.2656	900.0
2000-08-17	IWD	ETF	57.4688	57.4844	57.3438	57.4375	34100.0
2000-08-17	IWF	ETF	21.484375	21.85155	21.484375	21.8203	88000.0
2000-08-17	IWN	ETF	35.8021	36.0208	35.8021	36.0208	1200.0

> showing 50 of 77 rows — these rows as CSV

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