PREVIEW / etf_daily / 2004-07-19

all etf daily files

  file:    by_date/etf_daily/2004/2004-07-19.parquet
  size:    11 KB
  rows:    162

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-07-19	SPY	ETF	110.75	110.96	109.99	110.24	39592800.0
2004-07-19	QQQ	ETF	34.78	34.97	34.47	34.6	106437400.0
2004-07-19	IWM	ETF	55.42	55.5	54.825	55.18	19252200.0
2004-07-19	DIA	ETF	101.61	101.69	100.78	100.95	9645400.0
2004-07-19	TLT	ETF	85.41	85.57	85.36	85.55	978300.0
2004-07-19	AAA	ETF	56.85	56.85	56.5	56.65	47800.0
2004-07-19	ADRE	ETF	66.64	66.64	66.41	66.45	604.0
2004-07-19	AGG	ETF	101.49	101.49	101.23	101.25	13000.0
2004-07-19	ARB	ETF	34.12	34.65	34.05	34.45	169200.0
2004-07-19	BBH	ETF	46.2033	46.5433	45.07	45.6333	5087100.0
2004-07-19	BITS	ETF	7.32	7.676	7.32	7.4	920.0
2004-07-19	BNE	ETF	14.83	14.85	14.58	14.79	90300.0
2004-07-19	CEF	ETF	5.7	5.78	5.57	5.65	267400.0
2004-07-19	CHB	ETF	8.13	8.28	8.04	8.1	427200.0
2004-07-19	CNXT	ETF	2.35	2.37	2.27	2.31	7017390.0
2004-07-19	CSB	ETF	23.1000003814697	23.1000003814697	23.1000003814697	23.1000003814697	8400.0
2004-07-19	DGT	ETF	59.93	60.1	59.84	59.95	42700.0
2004-07-19	DVY	ETF	55.05	55.2	54.84	55.05	232400.0
2004-07-19	EEM	ETF	17.5944	17.6744	17.4622	17.5511	995400.0
2004-07-19	EFA	ETF	46.7967	46.85	46.4333	46.66	769200.0
2004-07-19	ELV	ETF	46.625	46.665	45.975	46.49	1952700.0
2004-07-19	EPP	ETF	25.1667	25.2367	25.0767	25.0767	64800.0
2004-07-19	EWA	ETF	13.95	14.05	13.85	13.88	22300.0
2004-07-19	EWC	ETF	14.27	14.45	14.27	14.42	77300.0
2004-07-19	EWD	ETF	16.98	16.98	16.39	16.71	68900.0
2004-07-19	EWG	ETF	15.37	15.5	15.28	15.4	38900.0
2004-07-19	EWH	ETF	10.01	10.14	10.01	10.07	129900.0
2004-07-19	EWI	ETF	41.68	42.16	41.66	41.88	26800.0
2004-07-19	EWJ	ETF	40.72	40.8	40.32	40.64	761975.0
2004-07-19	EWK	ETF	14.31	14.52	14.3	14.48	17700.0
2004-07-19	EWL	ETF	14.86	14.95	14.85	14.85	5700.0
2004-07-19	EWM	ETF	26.4	26.64	26.04	26.24	24850.0
2004-07-19	EWN	ETF	16.17	16.17	15.94	16.09	7700.0
2004-07-19	EWO	ETF	17.57	17.62	17.37	17.52	58900.0
2004-07-19	EWP	ETF	28.55	28.94	28.55	28.75	23400.0
2004-07-19	EWQ	ETF	20.81	20.81	20.75	20.75	16400.0
2004-07-19	EWS	ETF	12.94	12.94	12.76	12.9	75100.0
2004-07-19	EWT	ETF	19.96	20.08	19.7	20.0	161350.0
2004-07-19	EWU	ETF	32.1	32.1	31.62	31.9	109800.0
2004-07-19	EWW	ETF	18.81	19.03	18.67	18.72	126300.0
2004-07-19	EWY	ETF	22.84	22.9	22.53	22.61	132800.0
2004-07-19	EWZ	ETF	16.12	16.14	15.8	15.84	449200.0
2004-07-19	EZA	ETF	29.445	29.645	29.42	29.485	30000.0
2004-07-19	EZU	ETF	30.38	30.53	30.225	30.375	121200.0
2004-07-19	FCTR	ETF	22.16	22.5	22.05	22.37	69982.0
2004-07-19	FEZ	ETF	33.79	33.8	33.51	33.8	81600.0
2004-07-19	FMAR	ETF	16.0	16.3	16.0	16.11	7100.0
2004-07-19	FVD	ETF	14.05	14.07	14.0	14.05	85500.0
2004-07-19	GLDB	ETF	15.36	15.45	15.28	15.42	152442.0
2004-07-19	GRNB	ETF	22.5094	22.5879	22.4701	22.4799	4441.0

> showing 50 of 162 rows — these rows as CSV

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