PREVIEW / etf_daily / 2004-09-27

all etf daily files

  file:    by_date/etf_daily/2004/2004-09-27.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-09-27	SPY	ETF	111.1	111.2	110.58	110.75	39355100.0
2004-09-27	QQQ	ETF	34.62	34.74	34.38	34.5	86113200.0
2004-09-27	IWM	ETF	56.185	56.2	55.545	55.735	15947800.0
2004-09-27	DIA	ETF	100.38	100.58	100.0	100.16	5243000.0
2004-09-27	TLT	ETF	89.6	89.89	89.57	89.82	1420800.0
2004-09-27	AAA	ETF	57.93	58.25	57.85	57.85	1000.0
2004-09-27	ADRE	ETF	70.9	70.95	70.9	70.95	1412.0
2004-09-27	AGG	ETF	102.86	103.14	102.85	102.94	39100.0
2004-09-27	ARB	ETF	36.43	36.52	35.9	36.3	149700.0
2004-09-27	BBH	ETF	47.5333	47.8567	47.3533	47.4167	2265300.0
2004-09-27	BITS	ETF	6.76	6.76	6.6	6.604	830.0
2004-09-27	BNE	ETF	13.01	13.02	12.6	12.6	92400.0
2004-09-27	CEF	ETF	5.59	5.64	5.59	5.63	289300.0
2004-09-27	CHB	ETF	10.18	10.35	10.06	10.1	364600.0
2004-09-27	CNXT	ETF	1.765	1.8148	1.7251	1.755	8672180.0
2004-09-27	CSB	ETF	26.0	26.0	26.0	26.0	1200.0
2004-09-27	DGT	ETF	60.09	60.23	60.09	60.16	5200.0
2004-09-27	DVY	ETF	56.5	56.55	56.15	56.32	326300.0
2004-09-27	EEM	ETF	18.8322	18.8322	18.65	18.7344	2089800.0
2004-09-27	EFA	ETF	46.3133	46.48	46.25	46.3333	1306800.0
2004-09-27	ELV	ETF	43.35	43.35	42.8	42.95	892700.0
2004-09-27	EPP	ETF	26.0667	26.0833	25.9033	25.9033	102300.0
2004-09-27	EWA	ETF	14.06	14.14	14.05	14.05	46700.0
2004-09-27	EWC	ETF	15.21	15.21	15.07	15.07	50400.0
2004-09-27	EWD	ETF	17.82	17.87	17.82	17.86	2400.0
2004-09-27	EWG	ETF	15.46	15.51	15.39	15.48	23300.0
2004-09-27	EWH	ETF	11.03	11.04	10.95	10.96	416300.0
2004-09-27	EWI	ETF	42.14	42.46	42.12	42.36	2700.0
2004-09-27	EWJ	ETF	38.0	38.68	37.8	37.92	1073150.0
2004-09-27	EWK	ETF	15.68	15.76	15.38	15.38	20600.0
2004-09-27	EWL	ETF	14.69	14.8	14.65	14.67	10100.0
2004-09-27	EWM	ETF	27.0	27.12	26.72	26.96	23375.0
2004-09-27	EWN	ETF	16.02	16.02	15.95	15.95	3200.0
2004-09-27	EWO	ETF	17.52	17.7	17.5	17.7	33400.0
2004-09-27	EWP	ETF	28.03	28.14	27.96	27.99	6400.0
2004-09-27	EWQ	ETF	20.92	21.04	20.84	21.04	3400.0
2004-09-27	EWS	ETF	13.7	13.7	13.58	13.66	55500.0
2004-09-27	EWT	ETF	21.02	21.2	21.02	21.08	149600.0
2004-09-27	EWU	ETF	32.4	32.5	32.28	32.46	26200.0
2004-09-27	EWW	ETF	20.07	20.25	20.05	20.13	394100.0
2004-09-27	EWY	ETF	24.87	25.0	24.81	24.91	87200.0
2004-09-27	EWZ	ETF	17.96	18.03	17.86	17.94	552100.0
2004-09-27	EZA	ETF	31.905	31.975	31.775	31.95	3600.0
2004-09-27	EZU	ETF	30.6	30.75	30.48	30.56	19800.0
2004-09-27	FCTR	ETF	23.58	23.79	23.46	23.48	33198.0
2004-09-27	FEZ	ETF	33.49	33.67	33.48	33.6	28600.0
2004-09-27	FMAR	ETF	17.1	17.1	17.03	17.03	3760.0
2004-09-27	FVD	ETF	14.28	14.3	14.15	14.21	127900.0
2004-09-27	GLDB	ETF	13.66	13.74	13.65	13.67	256293.0
2004-09-27	GRNB	ETF	23.275	23.275	23.275	23.275	202.0

> showing 50 of 161 rows — these rows as CSV

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