PREVIEW / etf_daily / 2004-01-20

all etf daily files

  file:    by_date/etf_daily/2004/2004-01-20.parquet
  size:    10 KB
  rows:    140

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-01-20	SPY	ETF	114.53	114.65	113.82	114.2	29863000.0
2004-01-20	QQQ	ETF	38.73	39.0	38.307	38.54	82083600.0
2004-01-20	IWM	ETF	59.05	59.565	58.655	59.455	7429800.0
2004-01-20	DIA	ETF	106.4	106.4	105.3	105.46	8631500.0
2004-01-20	TLT	ETF	87.5	87.93	87.5	87.59	629600.0
2004-01-20	AAA	ETF	59.35	59.64	59.35	59.64	600.0
2004-01-20	ADRE	ETF	77.1	77.24	76.51	77.24	7080.0
2004-01-20	AGG	ETF	103.18	103.29	102.93	103.1	51700.0
2004-01-20	ARB	ETF	44.0	44.42	43.82	44.3	88200.0
2004-01-20	BBH	ETF	46.6167	46.7333	46.0433	46.2	3124200.0
2004-01-20	BITS	ETF	13.24	15.16	13.2	14.7696	7946.0
2004-01-20	BNE	ETF	14.5	14.58	14.43	14.5	227200.0
2004-01-20	CEF	ETF	5.35	5.39	5.25	5.37	369700.0
2004-01-20	CHB	ETF	6.53	6.85	6.36	6.83	454500.0
2004-01-20	CNXT	ETF	7.18	7.2	6.76	6.988	20809360.0
2004-01-20	DGT	ETF	62.78	62.82	62.48	62.67	17200.0
2004-01-20	DVY	ETF	54.6	54.62	54.29	54.52	578200.0
2004-01-20	EEM	ETF	19.1111	19.2944	19.0744	19.2778	1243800.0
2004-01-20	EFA	ETF	46.75	46.8933	46.66	46.7333	1307400.0
2004-01-20	ELV	ETF	39.175	39.32	38.53	38.695	2402100.0
2004-01-20	EPP	ETF	25.2667	25.32	25.0767	25.3133	264000.0
2004-01-20	EWA	ETF	13.5	13.59	13.41	13.54	111000.0
2004-01-20	EWC	ETF	14.82	15.0	14.76	14.94	244900.0
2004-01-20	EWD	ETF	16.5	16.5	16.25	16.36	14100.0
2004-01-20	EWG	ETF	16.69	16.84	16.64	16.67	162000.0
2004-01-20	EWH	ETF	11.19	11.2	11.05	11.1	965200.0
2004-01-20	EWI	ETF	41.2	41.46	41.16	41.26	12900.0
2004-01-20	EWJ	ETF	39.24	39.44	39.12	39.36	1465875.0
2004-01-20	EWK	ETF	13.92	13.95	13.79	13.86	8900.0
2004-01-20	EWL	ETF	14.98	15.21	14.98	15.07	10700.0
2004-01-20	EWM	ETF	27.16	27.2	26.8	27.12	363150.0
2004-01-20	EWN	ETF	16.6	16.6	16.4	16.56	8900.0
2004-01-20	EWO	ETF	14.56	14.62	14.48	14.6	36300.0
2004-01-20	EWP	ETF	28.55	28.82	28.55	28.82	18000.0
2004-01-20	EWQ	ETF	20.94	21.05	20.89	20.96	37400.0
2004-01-20	EWS	ETF	12.78	12.82	12.62	12.66	191250.0
2004-01-20	EWT	ETF	24.36	24.38	23.92	24.24	273550.0
2004-01-20	EWU	ETF	31.6	31.72	31.34	31.44	35750.0
2004-01-20	EWW	ETF	18.61	18.78	18.51	18.72	533400.0
2004-01-20	EWY	ETF	27.19	27.2	26.6	26.78	142700.0
2004-01-20	EWZ	ETF	17.94	18.05	17.8	18.02	1581000.0
2004-01-20	EZA	ETF	27.695	27.895	27.615	27.895	27000.0
2004-01-20	EZU	ETF	31.77	31.8	31.6	31.65	394600.0
2004-01-20	FCTR	ETF	19.885	20.49	19.75	20.49	64801.0
2004-01-20	FEZ	ETF	36.08	36.18	35.93	36.18	24000.0
2004-01-20	FMAR	ETF	18.4	19.0	18.3	18.61	12800.0
2004-01-20	FVD	ETF	14.7	14.75	14.52	14.6	149100.0
2004-01-20	GLDB	ETF	14.06	14.36	13.85	14.36	162948.0
2004-01-20	GRNB	ETF	24.0506	24.1881	23.3546	24.0407	3230.0
2004-01-20	GSIG	ETF	13.25	13.82	13.25	13.57	66900.0

> showing 50 of 140 rows — these rows as CSV

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