PREVIEW / etf_daily / 2000-04-26

all etf daily files

  file:    by_date/etf_daily/2000/2000-04-26.parquet
  size:    6 KB
  rows:    48

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-04-26	SPY	ETF	147.9688	148.75	146.0	146.4844	7711100.0
2000-04-26	QQQ	ETF	90.625	92.4219	87.125	87.375	25688300.0
2000-04-26	DIA	ETF	111.5625	111.5625	108.9375	109.0	2051700.0
2000-04-26	BBH	ETF	43.5	45.6667	43.0625	44.3333	1613100.0
2000-04-26	BITS	ETF	22.0	25.0	21.75	23.5	73475.0
2000-04-26	BOSS	ETF	14.5	14.5	14.3	14.3	600.0
2000-04-26	CEF	ETF	3.4375	3.5	3.4375	3.5	16200.0
2000-04-26	CHB	ETF	7.75	7.75	7.25	7.25	222400.0
2000-04-26	CNXT	ETF	61.5	61.69	56.5	56.5	2736300.0
2000-04-26	CSB	ETF	3.79999995231628	4.0	3.79999995231628	4.0	8200.0
2000-04-26	EWA	ETF	9.75	10.0	9.75	10.0	6400.0
2000-04-26	EWC	ETF	17.6875	18.0625	17.6875	18.0625	5600.0
2000-04-26	EWD	ETF	32.9375	32.9375	32.4375	32.4375	1500.0
2000-04-26	EWG	ETF	25.25	25.375	25.0625	25.25	34700.0
2000-04-26	EWH	ETF	12.3125	12.4375	12.125	12.1875	39600.0
2000-04-26	EWI	ETF	47.0	47.0	46.75	47.0	10850.0
2000-04-26	EWJ	ETF	62.25	62.25	61.25	61.5	83800.0
2000-04-26	EWK	ETF	12.5625	12.75	12.5625	12.5625	2300.0
2000-04-26	EWL	ETF	15.125	15.125	14.8125	15.125	3600.0
2000-04-26	EWM	ETF	24.5	24.5	24.0	24.0	18150.0
2000-04-26	EWN	ETF	23.25	23.5	23.125	23.125	1300.0
2000-04-26	EWO	ETF	7.6875	7.75	7.6875	7.6875	1700.0
2000-04-26	EWP	ETF	27.125	27.125	27.0	27.0	700.0
2000-04-26	EWQ	ETF	27.1875	27.375	27.125	27.125	17200.0
2000-04-26	EWS	ETF	15.0	15.0	14.75	14.75	36700.0
2000-04-26	EWU	ETF	39.625	39.625	38.875	39.25	9250.0
2000-04-26	EWW	ETF	16.75	17.0625	16.4375	16.5	7700.0
2000-04-26	FCTR	ETF	13.0313	13.875	13.0	13.75	27600.0
2000-04-26	FMAR	ETF	5.38	5.56	5.12	5.56	38010.0
2000-04-26	GLDB	ETF	6.25	6.375	6.0625	6.3125	47400.0
2000-04-26	GSIG	ETF	17.37	17.69	16.69	17.62	610300.0
2000-04-26	IGLD	ETF	1125.0	1137.5	1081.25	1093.75	283.0
2000-04-26	KTEC	ETF	9.5	9.5	9.0	9.375	28600.0
2000-04-26	MDY	ETF	87.25	87.75	85.875	86.125	1107100.0
2000-04-26	MIG	ETF	5.0625	5.25	5.0625	5.1875	3800.0
2000-04-26	PPH	ETF	48.125	48.125	47.0	47.7812	176000.0
2000-04-26	SFY	ETF	20.125	20.5625	19.875	19.9375	83300.0
2000-04-26	TDSC	ETF	5.28	5.31	5.22	5.22	54400.0
2000-04-26	TINY	ETF	11.44	12.0	10.81	10.94	135600.0
2000-04-26	XLB	ETF	11.289	11.3281	11.0781	11.0938	59800.0
2000-04-26	XLE	ETF	14.5312	14.7031	14.4531	14.6719	859000.0
2000-04-26	XLF	ETF	20.296	20.296	19.8136	19.9025	938761.0
2000-04-26	XLI	ETF	30.3906	30.4375	29.6094	29.7969	515300.0
2000-04-26	XLK	ETF	27.1875	27.5938	26.5938	26.5938	2924000.0
2000-04-26	XLP	ETF	23.3125	23.3125	22.7969	23.0	39100.0
2000-04-26	XLU	ETF	14.6172	14.6875	14.5234	14.5781	46800.0
2000-04-26	XLV	ETF	30.0	30.4688	30.0	30.2188	15500.0
2000-04-26	XLY	ETF	14.9688	15.0781	14.9688	15.0156	23800.0

> showing 48 of 48 rows — these rows as CSV

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