PREVIEW / etf_daily / 2001-06-18

all etf daily files

  file:    by_date/etf_daily/2001/2001-06-18.parquet
  size:    8 KB
  rows:    98

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-06-18	SPY	ETF	121.65	122.44	120.91	121.26	11368300.0
2001-06-18	QQQ	ETF	42.64	43.17	41.4	42.03	63539100.0
2001-06-18	IWM	ETF	49.25	49.5	48.75	49.0	685600.0
2001-06-18	DIA	ETF	106.4	107.2	106.2	107.0	2400000.0
2001-06-18	BBH	ETF	44.0667	44.9033	43.5067	43.6333	3108900.0
2001-06-18	BITS	ETF	14.28	15.0	11.6	12.2	33625.0
2001-06-18	BOSS	ETF	31.0	32.1	31.0	32.1	1000.0
2001-06-18	CEF	ETF	3.31	3.31	3.28	3.28	2400.0
2001-06-18	CHB	ETF	9.4	9.42	8.75	8.75	74000.0
2001-06-18	CNXT	ETF	8.54	8.74	7.493	7.59	3176610.0
2001-06-18	CSB	ETF	2.09999990463257	2.09999990463257	2.09999990463257	2.09999990463257	100000.0
2001-06-18	DGT	ETF	70.31	70.31	69.93	69.93	600.0
2001-06-18	EWA	ETF	9.71	9.8	9.71	9.75	2300.0
2001-06-18	EWC	ETF	11.49	11.49	11.3	11.3	2600.0
2001-06-18	EWG	ETF	16.55	16.55	16.3	16.35	17200.0
2001-06-18	EWH	ETF	10.1	10.16	10.02	10.06	24300.0
2001-06-18	EWI	ETF	36.46	36.46	36.02	36.02	750.0
2001-06-18	EWJ	ETF	40.56	40.64	40.16	40.52	57350.0
2001-06-18	EWK	ETF	11.1	11.1	11.1	11.1	200.0
2001-06-18	EWL	ETF	13.65	13.72	13.65	13.72	17200.0
2001-06-18	EWM	ETF	16.64	16.64	16.48	16.48	31875.0
2001-06-18	EWN	ETF	19.35	19.5	19.35	19.5	5600.0
2001-06-18	EWP	ETF	21.93	22.12	21.93	22.12	5800.0
2001-06-18	EWQ	ETF	20.4	20.4	20.1	20.15	20500.0
2001-06-18	EWS	ETF	10.98	11.0	10.8	10.84	9150.0
2001-06-18	EWT	ETF	20.7	20.84	20.7	20.84	1450.0
2001-06-18	EWU	ETF	31.9	31.9	31.48	31.48	11950.0
2001-06-18	EWW	ETF	16.51	16.65	16.1	16.1	8700.0
2001-06-18	EWY	ETF	14.51	14.67	14.51	14.61	1600.0
2001-06-18	EWZ	ETF	14.2	14.2	13.0	13.99	3800.0
2001-06-18	EZU	ETF	30.5	30.5	30.06	30.295	22000.0
2001-06-18	FCTR	ETF	16.45	16.7	16.01	16.01	25700.0
2001-06-18	FMAR	ETF	6.66	6.66	6.66	6.66	1200.0
2001-06-18	GLDB	ETF	7.1	7.12	6.97	7.01	144000.0
2001-06-18	GSIG	ETF	9.11	9.3	9.0	9.0	55200.0
2001-06-18	IBB	ETF	33.3333	33.67	32.7667	32.8	212700.0
2001-06-18	ICF	ETF	20.8375	20.9175	20.8375	20.9125	7200.0
2001-06-18	IDU	ETF	39.925	39.975	39.5	39.5	5000.0
2001-06-18	IEV	ETF	31.7	31.815	31.285	31.445	32000.0
2001-06-18	IGLD	ETF	73.0	73.0	72.0	73.0	84.0
2001-06-18	IGM	ETF	9.2167	9.25	9.125	9.125	302400.0
2001-06-18	IJH	ETF	10.18	10.227	10.092	10.11	405000.0
2001-06-18	IJJ	ETF	22.275	22.32	22.06	22.115	58400.0
2001-06-18	IJK	ETF	14.4638	14.5725	14.31	14.3438	224000.0
2001-06-18	IJR	ETF	18.345	18.3867	18.2	18.2083	63600.0
2001-06-18	IJS	ETF	20.675	20.69	20.45	20.4575	50400.0
2001-06-18	IJT	ETF	18.4	18.465	18.2125	18.275	12800.0
2001-06-18	IOO	ETF	31.525	31.575	31.34	31.34	144400.0
2001-06-18	IUSG	ETF	21.955	21.965	21.685	21.825	5000.0
2001-06-18	IUSV	ETF	24.8433	24.8433	24.78	24.81	3300.0

> showing 50 of 98 rows — these rows as CSV

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