PREVIEW / etf_daily / 2004-07-27

all etf daily files

  file:    by_date/etf_daily/2004/2004-07-27.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-27	SPY	ETF	109.05	110.11	108.97	109.77	51295100.0
2004-07-27	QQQ	ETF	34.19	34.71	34.04	34.53	103537600.0
2004-07-27	IWM	ETF	53.39	54.345	53.34	54.105	16286600.0
2004-07-27	DIA	ETF	100.05	101.21	99.98	100.95	7015800.0
2004-07-27	TLT	ETF	84.4	84.47	83.41	83.41	961200.0
2004-07-27	AAA	ETF	54.48	54.48	53.81	53.82	9900.0
2004-07-27	ADRE	ETF	65.29	65.29	65.04	65.06	448.0
2004-07-27	AGG	ETF	100.89	100.89	100.29	100.49	20500.0
2004-07-27	ARB	ETF	34.19	34.55	34.07	34.31	150300.0
2004-07-27	BBH	ETF	44.0267	45.17	43.8667	45.0	5037900.0
2004-07-27	BITS	ETF	6.64	6.64	6.0	6.16	1250.0
2004-07-27	BNE	ETF	14.59	14.92	14.45	14.68	78100.0
2004-07-27	BOSS	ETF	17.45	17.85	17.45	17.85	100.0
2004-07-27	CEF	ETF	5.33	5.37	5.3	5.36	184100.0
2004-07-27	CHB	ETF	9.39	9.55	9.2	9.51	720300.0
2004-07-27	CNXT	ETF	1.845	1.9148	1.6555	1.845	21912710.0
2004-07-27	DGT	ETF	59.33	59.57	59.13	59.57	11700.0
2004-07-27	DVY	ETF	54.38	54.69	54.23	54.63	343900.0
2004-07-27	EEM	ETF	17.0	17.2867	17.0	17.2867	1133100.0
2004-07-27	EFA	ETF	45.1533	45.4067	44.9167	45.35	1640400.0
2004-07-27	ELV	ETF	41.75	42.125	39.98	40.89	17384200.0
2004-07-27	EPP	ETF	24.55	24.55	24.2033	24.33	55800.0
2004-07-27	EWA	ETF	13.21	13.21	13.03	13.11	22700.0
2004-07-27	EWC	ETF	14.05	14.05	13.9	14.02	80300.0
2004-07-27	EWD	ETF	16.39	16.55	16.28	16.46	23300.0
2004-07-27	EWG	ETF	14.96	15.05	14.88	15.04	19300.0
2004-07-27	EWH	ETF	10.13	10.35	10.12	10.3	1042800.0
2004-07-27	EWI	ETF	40.38	40.56	40.3	40.54	300.0
2004-07-27	EWJ	ETF	39.08	39.44	38.76	39.32	2054200.0
2004-07-27	EWK	ETF	13.91	14.05	13.91	14.02	2600.0
2004-07-27	EWL	ETF	14.51	14.68	14.49	14.67	5200.0
2004-07-27	EWM	ETF	26.0	26.24	25.84	26.08	66975.0
2004-07-27	EWN	ETF	15.36	15.55	15.36	15.52	16400.0
2004-07-27	EWO	ETF	17.16	17.24	17.01	17.16	17800.0
2004-07-27	EWP	ETF	27.39	27.4	27.39	27.4	4700.0
2004-07-27	EWQ	ETF	19.97	20.29	19.97	20.28	14500.0
2004-07-27	EWS	ETF	12.54	12.54	12.2	12.36	182300.0
2004-07-27	EWT	ETF	19.72	19.72	19.36	19.72	281000.0
2004-07-27	EWU	ETF	31.08	31.2	30.86	31.12	75250.0
2004-07-27	EWW	ETF	18.61	18.93	18.6	18.88	44200.0
2004-07-27	EWY	ETF	22.05	22.41	22.04	22.3	347000.0
2004-07-27	EWZ	ETF	15.06	15.26	14.91	15.21	344300.0
2004-07-27	EZA	ETF	28.235	28.34	28.22	28.34	8200.0
2004-07-27	EZU	ETF	29.38	29.595	29.22	29.57	74000.0
2004-07-27	FCTR	ETF	22.23	22.71	22.13	22.71	33525.0
2004-07-27	FEZ	ETF	32.48	32.55	32.23	32.55	12700.0
2004-07-27	FMAR	ETF	15.94	15.94	15.94	15.94	100.0
2004-07-27	FVD	ETF	13.84	13.86	13.73	13.86	269400.0
2004-07-27	GLDB	ETF	15.55	15.57	15.39	15.57	114336.0
2004-07-27	GRNB	ETF	22.745	22.8922	22.7254	22.7842	1413.0

> showing 50 of 162 rows — these rows as CSV

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