PREVIEW / etf_daily / 2004-07-20

all etf daily files

  file:    by_date/etf_daily/2004/2004-07-20.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-20	SPY	ETF	110.53	111.9	110.25	111.64	46679800.0
2004-07-20	QQQ	ETF	34.75	35.587	34.71	35.43	120170200.0
2004-07-20	IWM	ETF	55.335	56.455	55.22	56.275	9760000.0
2004-07-20	DIA	ETF	101.17	102.15	100.86	101.9	5270600.0
2004-07-20	TLT	ETF	85.31	85.38	84.6	84.78	1091500.0
2004-07-20	AAA	ETF	56.86	57.64	56.86	57.38	9200.0
2004-07-20	ADRE	ETF	66.43	66.71	66.43	66.71	2288.0
2004-07-20	AGG	ETF	101.25	101.35	100.8	100.98	62300.0
2004-07-20	ARB	ETF	34.35	34.8	34.24	34.76	108500.0
2004-07-20	BBH	ETF	45.7167	46.24	45.51	46.24	1818600.0
2004-07-20	BITS	ETF	7.2	7.4	7.2	7.24	760.0
2004-07-20	BNE	ETF	14.87	15.18	14.82	15.11	81400.0
2004-07-20	CEF	ETF	5.61	5.63	5.52	5.63	133300.0
2004-07-20	CHB	ETF	8.15	8.2	7.81	8.09	567900.0
2004-07-20	CNXT	ETF	2.34	2.42	2.28	2.38	7583310.0
2004-07-20	CSB	ETF	23.3500003814697	23.3500003814697	23.3500003814697	23.3500003814697	5000.0
2004-07-20	DGT	ETF	59.95	60.08	59.73	59.99	2200.0
2004-07-20	DVY	ETF	55.18	55.5	54.91	55.5	301000.0
2004-07-20	EEM	ETF	17.5667	17.6256	17.4811	17.6256	1849500.0
2004-07-20	EFA	ETF	46.53	46.7167	46.3567	46.6833	777000.0
2004-07-20	ELV	ETF	46.49	46.49	46.07	46.2	1841100.0
2004-07-20	EPP	ETF	25.0667	25.0667	24.8867	25.0467	52800.0
2004-07-20	EWA	ETF	13.85	13.85	13.71	13.82	33600.0
2004-07-20	EWC	ETF	14.46	14.46	14.38	14.41	10700.0
2004-07-20	EWD	ETF	16.65	16.88	16.46	16.88	19500.0
2004-07-20	EWG	ETF	15.33	15.5	15.33	15.48	22700.0
2004-07-20	EWH	ETF	10.12	10.13	9.99	10.1	87500.0
2004-07-20	EWI	ETF	41.58	41.76	41.44	41.68	2000.0
2004-07-20	EWJ	ETF	40.44	40.92	40.36	40.72	990550.0
2004-07-20	EWK	ETF	14.3	14.37	14.3	14.3	23100.0
2004-07-20	EWL	ETF	14.8	15.1	14.8	15.05	9400.0
2004-07-20	EWM	ETF	26.24	26.72	26.24	26.68	23875.0
2004-07-20	EWN	ETF	16.1	16.1	16.03	16.03	300.0
2004-07-20	EWO	ETF	17.45	17.62	17.33	17.52	49700.0
2004-07-20	EWP	ETF	28.47	28.52	28.41	28.45	1600.0
2004-07-20	EWQ	ETF	20.75	20.83	20.72	20.82	11200.0
2004-07-20	EWS	ETF	12.88	12.9	12.72	12.74	9900.0
2004-07-20	EWT	ETF	19.48	19.8	19.3	19.78	258300.0
2004-07-20	EWU	ETF	31.6	31.78	31.5	31.78	101800.0
2004-07-20	EWW	ETF	18.65	19.02	18.65	18.95	53900.0
2004-07-20	EWY	ETF	22.37	22.54	22.26	22.5	286300.0
2004-07-20	EWZ	ETF	15.8	15.96	15.75	15.92	384600.0
2004-07-20	EZA	ETF	29.25	29.29	29.075	29.115	9200.0
2004-07-20	EZU	ETF	30.425	30.59	30.26	30.33	73000.0
2004-07-20	FCTR	ETF	22.32	22.98	22.28	22.98	80257.0
2004-07-20	FEZ	ETF	33.67	33.78	33.61	33.73	1500.0
2004-07-20	FMAR	ETF	16.0	16.65	15.92	16.56	6500.0
2004-07-20	FVD	ETF	14.04	14.15	14.02	14.11	111900.0
2004-07-20	GLDB	ETF	15.28	15.54	15.28	15.53	50081.0
2004-07-20	GRNB	ETF	22.4907	22.902	22.4907	22.6566	3028.0

> showing 50 of 162 rows — these rows as CSV

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