PREVIEW / etf_daily / 2000-03-27

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-27.parquet
  size:    6 KB
  rows:    46

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
2000-03-27	SPY	ETF	153.375	153.7812	151.8125	151.9375	8798600.0
2000-03-27	QQQ	ETF	118.0	119.5	117.125	117.75	11752600.0
2000-03-27	DIA	ETF	111.3438	111.9062	109.6875	109.8125	1431300.0
2000-03-27	BBH	ETF	59.75	59.75	58.1875	59.0	986400.0
2000-03-27	BITS	ETF	40.0	66.0	38.0	53.5	960900.0
2000-03-27	CEF	ETF	3.5625	3.5625	3.5	3.5	15900.0
2000-03-27	CHB	ETF	6.5	6.5	6.25	6.44	100000.0
2000-03-27	CNXT	ETF	80.5	82.87	79.5	81.25	4578270.0
2000-03-27	EWA	ETF	10.5	10.625	10.375	10.375	4900.0
2000-03-27	EWC	ETF	19.0	19.0	18.9375	18.9375	12900.0
2000-03-27	EWD	ETF	35.4375	35.4375	34.9375	34.9375	2600.0
2000-03-27	EWG	ETF	28.3125	28.3125	27.8125	28.0	64500.0
2000-03-27	EWH	ETF	14.0625	14.125	13.9375	14.0625	50100.0
2000-03-27	EWI	ETF	52.5	52.625	51.75	51.75	9850.0
2000-03-27	EWJ	ETF	60.75	60.75	60.0	60.5	152225.0
2000-03-27	EWK	ETF	13.125	13.125	12.75	12.75	14800.0
2000-03-27	EWL	ETF	15.3125	15.5625	15.3125	15.5	58300.0
2000-03-27	EWM	ETF	28.25	28.75	28.25	28.5	33000.0
2000-03-27	EWN	ETF	24.5	24.5	24.125	24.25	5000.0
2000-03-27	EWO	ETF	7.8125	7.8125	7.75	7.75	300.0
2000-03-27	EWP	ETF	29.1875	29.1875	28.8125	28.8125	4200.0
2000-03-27	EWQ	ETF	29.125	29.1875	28.75	29.0	29500.0
2000-03-27	EWS	ETF	15.625	15.625	15.375	15.5	64300.0
2000-03-27	EWU	ETF	41.625	41.75	41.25	41.5	20650.0
2000-03-27	EWW	ETF	20.3125	20.3125	20.0	20.1875	11200.0
2000-03-27	FCTR	ETF	13.375	13.375	13.125	13.25	21300.0
2000-03-27	FMAR	ETF	6.0	6.13	5.75	5.87	7500.0
2000-03-27	GLDB	ETF	7.25	7.25	7.0	7.0	226200.0
2000-03-27	GSIG	ETF	19.69	19.94	18.5	19.44	350600.0
2000-03-27	IGLD	ETF	2112.5	2400.0	2100.0	2312.5	1188.0
2000-03-27	KTEC	ETF	9.0	9.0	8.875	8.875	5000.0
2000-03-27	MDY	ETF	92.0	92.5	90.9375	91.4688	317800.0
2000-03-27	MIG	ETF	6.0	6.0	6.0	6.0	3100.0
2000-03-27	PPH	ETF	41.7188	41.7188	41.0312	41.1875	163400.0
2000-03-27	SFY	ETF	15.4375	15.625	14.875	15.0	169900.0
2000-03-27	TDSC	ETF	5.28	5.375	5.125	5.31	218000.0
2000-03-27	TINY	ETF	22.0	22.62	20.56	20.75	150100.0
2000-03-27	XLB	ETF	11.3203	11.4062	11.0938	11.211	79800.0
2000-03-27	XLE	ETF	13.9688	14.2188	13.7969	14.0625	438200.0
2000-03-27	XLF	ETF	20.1945	20.1945	19.3948	19.5471	316613.0
2000-03-27	XLI	ETF	29.0781	29.0781	28.6719	28.6875	10300.0
2000-03-27	XLK	ETF	32.125	32.4688	32.0312	32.25	1566200.0
2000-03-27	XLP	ETF	20.7812	20.7812	20.2969	20.3125	52200.0
2000-03-27	XLU	ETF	13.0469	13.1719	13.0469	13.1484	66000.0
2000-03-27	XLV	ETF	31.0469	31.3594	31.0	31.0	14400.0
2000-03-27	XLY	ETF	14.1797	14.2812	14.1094	14.1406	28000.0

> showing 46 of 46 rows — these rows as CSV

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