PREVIEW / etf_daily / 2000-07-21

all etf daily files

  file:    by_date/etf_daily/2000/2000-07-21.parquet
  size:    7 KB
  rows:    70

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-07-21	SPY	ETF	149.75	149.75	147.6875	147.6875	5656900.0
2000-07-21	QQQ	ETF	98.4375	99.5156	97.0	97.0	14411400.0
2000-07-21	IWM	ETF	53.1875	53.1875	52.0312	52.0312	150600.0
2000-07-21	DIA	ETF	108.0156	108.3438	107.0	107.0	471000.0
2000-07-21	BBH	ETF	60.75	63.1458	60.75	62.6667	1161300.0
2000-07-21	BITS	ETF	20.375	20.375	18.25	19.0	13625.0
2000-07-21	CEF	ETF	3.25	3.375	3.25	3.375	19600.0
2000-07-21	CHB	ETF	5.19	5.25	5.13	5.13	22600.0
2000-07-21	CNXT	ETF	39.0	41.31	38.87	39.94	11630880.0
2000-07-21	CSB	ETF	3.09999990463257	3.09999990463257	3.09999990463257	3.09999990463257	4000.0
2000-07-21	EWA	ETF	10.375	10.625	10.375	10.625	5000.0
2000-07-21	EWC	ETF	21.0	21.3125	21.0	21.25	21600.0
2000-07-21	EWD	ETF	31.1875	31.625	31.1875	31.375	6900.0
2000-07-21	EWG	ETF	25.1875	25.1875	24.9375	25.125	99200.0
2000-07-21	EWH	ETF	13.875	13.875	13.625	13.75	39900.0
2000-07-21	EWI	ETF	52.625	52.625	52.5	52.5	15850.0
2000-07-21	EWJ	ETF	55.75	56.75	55.75	56.0	61275.0
2000-07-21	EWK	ETF	13.75	13.875	13.625	13.875	1000.0
2000-07-21	EWL	ETF	15.9375	16.1875	15.9375	16.0	98300.0
2000-07-21	EWM	ETF	24.75	25.0	24.75	24.75	9100.0
2000-07-21	EWN	ETF	24.625	24.625	24.25	24.375	50800.0
2000-07-21	EWO	ETF	7.8125	7.875	7.75	7.875	2200.0
2000-07-21	EWP	ETF	26.4375	26.4375	26.1875	26.4375	5700.0
2000-07-21	EWQ	ETF	28.375	28.4375	28.1875	28.4375	15400.0
2000-07-21	EWS	ETF	15.375	15.5	15.25	15.25	30200.0
2000-07-21	EWT	ETF	35.75	35.75	35.75	35.75	200.0
2000-07-21	EWU	ETF	38.25	39.0	38.25	38.625	154000.0
2000-07-21	EWW	ETF	17.125	17.4375	17.0	17.0	9900.0
2000-07-21	EWY	ETF	20.25	20.5	20.25	20.5	11100.0
2000-07-21	EWZ	ETF	20.0	20.0	20.0	20.0	200.0
2000-07-21	FCTR	ETF	16.0	16.0	15.8125	15.8125	7600.0
2000-07-21	FMAR	ETF	5.12	5.25	5.12	5.25	2400.0
2000-07-21	GLDB	ETF	5.0156	5.0313	4.875	4.875	157600.0
2000-07-21	GSIG	ETF	42.41	43.44	38.0	39.37	1225600.0
2000-07-21	IGLD	ETF	834.375	837.5	800.0	800.0	617.0
2000-07-21	IJH	ETF	10.1375	10.1453	10.1	10.1	358000.0
2000-07-21	IJR	ETF	18.0781	18.0781	17.6667	17.6667	21000.0
2000-07-21	IVE	ETF	60.625	60.7031	60.0781	60.0781	28900.0
2000-07-21	IVV	ETF	149.4062	149.4375	147.7188	147.7188	601300.0
2000-07-21	IVW	ETF	22.8711	22.8711	22.8125	22.832	10400.0
2000-07-21	IWB	ETF	78.9844	78.9844	78.9375	78.9688	900.0
2000-07-21	IWD	ETF	55.7812	55.7812	55.25	55.3125	9100.0
2000-07-21	IWF	ETF	22.2578	22.296875	22.15625	22.28515	28800.0
2000-07-21	IWV	ETF	82.1719	82.1719	81.4531	81.5312	6700.0
2000-07-21	IYE	ETF	15.6875	15.6875	15.5	15.5417	6600.0
2000-07-21	IYF	ETF	38.2812	38.2812	38.0	38.0234	25000.0
2000-07-21	IYG	ETF	29.5938	29.5938	29.3229	29.401	4200.0
2000-07-21	IYH	ETF	12.6	12.7438	12.6	12.7312	114500.0
2000-07-21	IYR	ETF	36.3281	36.375	36.3125	36.3438	3000.0
2000-07-21	IYW	ETF	32.8398	32.8398	32.3281	32.3281	17200.0

> showing 50 of 70 rows — these rows as CSV

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