PREVIEW / etf_daily / 2000-03-20

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-20.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-20	SPY	ETF	146.875	147.3438	144.7812	146.1875	12502300.0
2000-03-20	QQQ	ETF	111.0	111.5	106.25	107.6875	21167200.0
2000-03-20	DIA	ETF	106.2812	107.3438	105.8906	106.8125	1812000.0
2000-03-20	BBH	ETF	62.0833	62.2917	55.5	55.9167	2809800.0
2000-03-20	BITS	ETF	46.0	46.0	39.0	39.25	52000.0
2000-03-20	CEF	ETF	3.5	3.5	3.4375	3.4375	13800.0
2000-03-20	CHB	ETF	6.31	6.63	6.06	6.56	71500.0
2000-03-20	CNXT	ETF	80.37	84.75	78.25	79.0	4872600.0
2000-03-20	EWA	ETF	10.5	10.5	10.25	10.5	10200.0
2000-03-20	EWC	ETF	17.875	17.875	17.875	17.875	16000.0
2000-03-20	EWD	ETF	36.0625	36.0625	35.8125	35.8125	6100.0
2000-03-20	EWG	ETF	28.1875	28.6875	28.125	28.375	202900.0
2000-03-20	EWH	ETF	13.5	13.5	13.25	13.25	24600.0
2000-03-20	EWI	ETF	52.75	52.75	51.75	51.75	10950.0
2000-03-20	EWJ	ETF	60.0	60.5	59.75	60.5	156750.0
2000-03-20	EWK	ETF	13.375	13.375	13.125	13.125	9600.0
2000-03-20	EWL	ETF	14.9375	15.0	14.6875	14.9375	45100.0
2000-03-20	EWM	ETF	27.75	27.75	27.25	27.5	16800.0
2000-03-20	EWN	ETF	24.125	24.125	23.6875	23.8125	15300.0
2000-03-20	EWO	ETF	7.9375	7.9375	7.6875	7.6875	2600.0
2000-03-20	EWP	ETF	29.625	29.625	29.1875	29.1875	6100.0
2000-03-20	EWQ	ETF	28.9375	28.9375	28.5625	28.8125	29100.0
2000-03-20	EWS	ETF	14.375	14.75	14.25	14.375	24400.0
2000-03-20	EWU	ETF	40.875	41.125	40.5	40.75	84800.0
2000-03-20	EWW	ETF	19.75	19.75	19.4375	19.6875	55000.0
2000-03-20	FCTR	ETF	12.75	13.625	12.75	13.3125	17500.0
2000-03-20	FMAR	ETF	5.75	6.5	5.75	6.0	5700.0
2000-03-20	GLDB	ETF	6.6875	6.75	6.5	6.625	71100.0
2000-03-20	GSIG	ETF	17.5	20.0	17.5	18.44	627500.0
2000-03-20	IGLD	ETF	2746.875	2793.75	2525.0	2650.0	653.0
2000-03-20	KTEC	ETF	9.1875	9.5	8.9375	9.0	23900.0
2000-03-20	MDY	ETF	89.4375	90.25	87.0	87.125	532100.0
2000-03-20	MIG	ETF	5.25	5.25	5.0	5.0625	13100.0
2000-03-20	PPH	ETF	42.375	42.375	41.75	42.125	213000.0
2000-03-20	SFY	ETF	12.625	13.1875	12.625	12.9375	119900.0
2000-03-20	TDSC	ETF	5.625	5.75	5.155	5.56	328200.0
2000-03-20	TINY	ETF	26.25	26.31	21.5	21.88	476100.0
2000-03-20	XLB	ETF	11.1562	11.3438	11.0781	11.1328	55000.0
2000-03-20	XLE	ETF	13.9531	13.9531	13.6094	13.6719	475000.0
2000-03-20	XLF	ETF	18.8744	18.8871	18.2652	18.4682	422233.0
2000-03-20	XLI	ETF	27.8594	27.9219	27.5	27.75	129700.0
2000-03-20	XLK	ETF	30.0625	30.3125	29.5625	29.8125	790800.0
2000-03-20	XLP	ETF	21.2031	21.2031	20.6562	20.9062	563400.0
2000-03-20	XLU	ETF	13.375	13.4062	13.1875	13.2656	122600.0
2000-03-20	XLV	ETF	29.8125	30.0	29.7031	29.875	8200.0
2000-03-20	XLY	ETF	14.1406	14.1406	13.8438	14.0	162200.0

> showing 46 of 46 rows — these rows as CSV

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