PREVIEW / etf_daily / 2004-08-18

all etf daily files

  file:    by_date/etf_daily/2004/2004-08-18.parquet
  size:    11 KB
  rows:    161

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
2004-08-18	SPY	ETF	108.52	110.17	108.49	110.03	43165400.0
2004-08-18	QQQ	ETF	33.06	33.91	33.01	33.85	108019800.0
2004-08-18	IWM	ETF	52.575	54.06	52.5	54.02	13410200.0
2004-08-18	DIA	ETF	99.82	101.3	99.77	101.22	6069000.0
2004-08-18	TLT	ETF	87.03	87.06	86.4	86.41	365300.0
2004-08-18	AAA	ETF	54.06	54.4	54.06	54.4	3100.0
2004-08-18	ADRE	ETF	66.76	67.73	66.76	67.73	4200.0
2004-08-18	AGG	ETF	102.39	102.4	102.01	102.01	47400.0
2004-08-18	ARB	ETF	37.6	38.55	37.05	37.84	1219300.0
2004-08-18	BBH	ETF	44.7	46.0333	44.6667	46.0333	2649300.0
2004-08-18	BITS	ETF	7.52	7.72	7.4	7.4	525.0
2004-08-18	BNE	ETF	13.41	13.6	13.39	13.49	90800.0
2004-08-18	CEF	ETF	5.69	5.7	5.62	5.66	207900.0
2004-08-18	CHB	ETF	10.16	10.29	10.09	10.1	689200.0
2004-08-18	CNXT	ETF	1.59	1.64	1.53	1.64	8653190.0
2004-08-18	CSB	ETF	25.75	27.75	25.5	26.0	111400.0
2004-08-18	DGT	ETF	59.38	59.86	59.38	59.86	12300.0
2004-08-18	DVY	ETF	55.45	55.95	55.33	55.95	532500.0
2004-08-18	EEM	ETF	17.34	17.5833	17.2811	17.5822	1214100.0
2004-08-18	EFA	ETF	44.95	45.5833	44.9033	45.56	1868700.0
2004-08-18	ELV	ETF	40.975	41.55	40.95	41.55	845800.0
2004-08-18	EPP	ETF	24.6367	24.8667	24.6167	24.8633	66300.0
2004-08-18	EWA	ETF	13.38	13.49	13.34	13.49	11600.0
2004-08-18	EWC	ETF	14.16	14.28	14.14	14.24	6000.0
2004-08-18	EWD	ETF	16.15	16.63	16.15	16.63	15800.0
2004-08-18	EWG	ETF	14.75	15.09	14.75	15.03	27600.0
2004-08-18	EWH	ETF	10.18	10.37	10.18	10.35	191000.0
2004-08-18	EWI	ETF	40.34	40.86	40.3	40.86	3450.0
2004-08-18	EWJ	ETF	38.2	38.88	38.12	38.68	732050.0
2004-08-18	EWK	ETF	14.58	14.58	14.4	14.51	18300.0
2004-08-18	EWL	ETF	14.63	14.63	14.25	14.51	8500.0
2004-08-18	EWM	ETF	25.2	25.76	25.2	25.76	25750.0
2004-08-18	EWN	ETF	15.43	15.6	15.43	15.57	36200.0
2004-08-18	EWO	ETF	17.65	17.77	17.55	17.76	38300.0
2004-08-18	EWP	ETF	27.3	27.66	27.11	27.66	2900.0
2004-08-18	EWQ	ETF	20.27	20.45	20.26	20.45	25600.0
2004-08-18	EWS	ETF	12.78	12.94	12.76	12.94	38600.0
2004-08-18	EWT	ETF	19.7	20.28	19.68	20.28	595350.0
2004-08-18	EWU	ETF	31.26	31.48	31.16	31.48	50450.0
2004-08-18	EWW	ETF	19.01	19.12	18.98	19.12	71400.0
2004-08-18	EWY	ETF	23.22	23.88	23.22	23.88	175500.0
2004-08-18	EWZ	ETF	16.19	16.79	16.16	16.75	653000.0
2004-08-18	EZA	ETF	29.325	29.375	29.29	29.375	7400.0
2004-08-18	EZU	ETF	29.42	29.885	29.35	29.83	23000.0
2004-08-18	FCTR	ETF	21.81	22.63	21.7	22.63	52759.0
2004-08-18	FEZ	ETF	32.34	33.05	32.34	33.05	12100.0
2004-08-18	FMAR	ETF	15.78	15.87	15.78	15.85	4610.0
2004-08-18	FVD	ETF	13.97	14.18	13.97	14.15	121600.0
2004-08-18	GLDB	ETF	15.39	15.51	15.39	15.48	145959.0
2004-08-18	GRNB	ETF	22.5781	22.6566	22.5781	22.6566	2826.0

> showing 50 of 161 rows — these rows as CSV

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