PREVIEW / etf_daily / 2001-07-09

all etf daily files

  file:    by_date/etf_daily/2001/2001-07-09.parquet
  size:    8 KB
  rows:    97

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
2001-07-09	SPY	ETF	119.49	120.54	119.2	119.7	8339300.0
2001-07-09	QQQ	ETF	41.898	42.69	41.5	42.01	45547500.0
2001-07-09	IWM	ETF	48.125	48.475	47.625	48.4	895400.0
2001-07-09	DIA	ETF	102.95	103.39	102.32	102.85	2770800.0
2001-07-09	BBH	ETF	41.5333	42.4667	41.25	41.62	3945300.0
2001-07-09	BITS	ETF	12.2	12.6	12.2	12.6	3950.0
2001-07-09	BOSS	ETF	29.33	29.8	29.33	29.6	700.0
2001-07-09	CEF	ETF	3.2	3.2	3.01	3.01	143400.0
2001-07-09	CHB	ETF	10.95	11.0	10.8	10.98	392300.0
2001-07-09	CNXT	ETF	7.43	8.77	7.37	8.09	3563730.0
2001-07-09	EWA	ETF	9.16	9.3	9.16	9.3	25900.0
2001-07-09	EWC	ETF	11.4	11.4	11.1	11.12	1000.0
2001-07-09	EWD	ETF	12.45	12.6	12.4	12.4	2800.0
2001-07-09	EWG	ETF	15.87	15.95	15.8	15.9	54700.0
2001-07-09	EWH	ETF	9.7	9.89	9.7	9.87	63600.0
2001-07-09	EWI	ETF	35.42	35.6	35.42	35.6	400.0
2001-07-09	EWJ	ETF	38.68	38.96	38.64	38.96	55825.0
2001-07-09	EWK	ETF	11.04	11.2	11.04	11.2	400.0
2001-07-09	EWL	ETF	13.0	13.05	13.0	13.05	2000.0
2001-07-09	EWM	ETF	18.0	18.52	18.0	18.28	52825.0
2001-07-09	EWN	ETF	19.0	19.0	19.0	19.0	200.0
2001-07-09	EWO	ETF	7.76	7.8	7.76	7.8	2200.0
2001-07-09	EWP	ETF	20.5	20.5	20.3	20.3	300.0
2001-07-09	EWQ	ETF	19.1	19.39	19.1	19.25	5000.0
2001-07-09	EWS	ETF	10.16	10.34	10.16	10.34	21100.0
2001-07-09	EWT	ETF	19.62	19.62	19.2	19.2	450.0
2001-07-09	EWU	ETF	30.28	30.38	30.12	30.38	8250.0
2001-07-09	EWW	ETF	16.59	16.59	16.35	16.46	13400.0
2001-07-09	EWY	ETF	13.7	13.7	13.36	13.36	3300.0
2001-07-09	EWZ	ETF	13.22	13.23	13.08	13.08	6600.0
2001-07-09	EZU	ETF	29.0	29.145	28.905	29.14	7000.0
2001-07-09	FCTR	ETF	16.75	17.0	16.67	16.9	9100.0
2001-07-09	FMAR	ETF	5.68	5.68	5.68	5.68	300.0
2001-07-09	GLDB	ETF	7.46	7.93	7.38	7.74	47600.0
2001-07-09	GSIG	ETF	8.82	8.98	8.73	8.75	42900.0
2001-07-09	IBB	ETF	30.95	31.85	30.94	31.4	1706100.0
2001-07-09	ICF	ETF	21.25	21.25	20.8875	20.9425	128400.0
2001-07-09	IDU	ETF	40.46	40.46	40.175	40.205	12600.0
2001-07-09	IEV	ETF	30.44	30.45	30.125	30.445	20000.0
2001-07-09	IGLD	ETF	69.0	70.0	69.0	70.0	166.0
2001-07-09	IGM	ETF	9.0017	9.19	9.0017	9.1067	265200.0
2001-07-09	IJH	ETF	10.054	10.12	10.023	10.041	425000.0
2001-07-09	IJJ	ETF	22.305	22.5125	22.305	22.3625	109600.0
2001-07-09	IJK	ETF	14.0062	14.1038	13.9588	14.0138	272800.0
2001-07-09	IJR	ETF	18.3333	18.4267	18.3033	18.385	295800.0
2001-07-09	IJS	ETF	20.475	20.59	20.4375	20.4925	218400.0
2001-07-09	IJT	ETF	18.39	18.5475	18.39	18.515	49200.0
2001-07-09	IOO	ETF	30.23	30.45	30.23	30.44	13200.0
2001-07-09	IUSG	ETF	21.385	21.425	21.385	21.405	15200.0
2001-07-09	IUSV	ETF	24.6767	24.7033	24.58	24.7033	19200.0

> showing 50 of 97 rows — these rows as CSV

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