PREVIEW / etf_daily / 2000-03-06

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-06.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-06	SPY	ETF	140.8125	141.3438	138.75	139.75	11967100.0
2000-03-06	QQQ	ETF	55.875	56.6094	55.125	55.9688	23269400.0
2000-03-06	DIA	ETF	103.8125	103.9844	101.1406	101.7188	1220500.0
2000-03-06	BBH	ETF	81.5625	81.5833	79.25	80.6042	2094900.0
2000-03-06	BITS	ETF	37.0	42.5	37.0	39.75	125050.0
2000-03-06	CEF	ETF	3.4375	3.4375	3.4375	3.4375	10000.0
2000-03-06	CHB	ETF	6.31	6.38	6.0	6.13	54400.0
2000-03-06	CNXT	ETF	96.31	105.94	96.25	101.69	12221120.0
2000-03-06	EWA	ETF	10.125	10.75	10.125	10.4375	133200.0
2000-03-06	EWC	ETF	17.75	17.9375	17.5625	17.6875	52300.0
2000-03-06	EWD	ETF	36.8125	37.0	36.5	36.5	20400.0
2000-03-06	EWG	ETF	28.9375	28.9375	28.5625	28.5625	30500.0
2000-03-06	EWH	ETF	13.75	13.75	13.5625	13.625	162400.0
2000-03-06	EWI	ETF	55.0	55.25	54.75	54.75	5300.0
2000-03-06	EWJ	ETF	59.5	59.75	58.75	59.0	198525.0
2000-03-06	EWK	ETF	12.4375	12.625	12.1875	12.1875	14900.0
2000-03-06	EWL	ETF	14.625	14.875	14.375	14.375	16500.0
2000-03-06	EWM	ETF	28.0	28.25	27.75	27.75	37900.0
2000-03-06	EWN	ETF	23.8125	24.0	23.5625	23.5625	6300.0
2000-03-06	EWO	ETF	7.25	7.4375	7.25	7.25	8100.0
2000-03-06	EWP	ETF	29.5	29.625	29.1875	29.1875	9800.0
2000-03-06	EWQ	ETF	29.1875	29.4375	29.0625	29.0625	22700.0
2000-03-06	EWS	ETF	14.25	14.625	14.25	14.375	75800.0
2000-03-06	EWU	ETF	40.0	40.25	39.25	39.25	25300.0
2000-03-06	EWW	ETF	19.9375	19.9375	19.375	19.625	16400.0
2000-03-06	FCTR	ETF	13.25	13.4375	13.0	13.4375	14100.0
2000-03-06	FMAR	ETF	6.69	6.88	6.5	6.88	4500.0
2000-03-06	GLDB	ETF	7.75	7.75	6.25	7.0	73600.0
2000-03-06	GSIG	ETF	26.75	27.19	24.56	24.94	1056500.0
2000-03-06	IGLD	ETF	2650.0	2650.0	2275.0	2350.0	1773.0
2000-03-06	KTEC	ETF	9.25	9.375	8.875	9.375	18000.0
2000-03-06	MDY	ETF	88.1562	89.125	87.5	88.4688	546600.0
2000-03-06	MIG	ETF	6.375	6.5	6.0	6.0	9500.0
2000-03-06	PPH	ETF	39.375	39.375	38.0312	38.125	356200.0
2000-03-06	SFY	ETF	12.5625	13.125	12.5	12.8125	58200.0
2000-03-06	TDSC	ETF	6.405	6.625	6.0	6.235	286000.0
2000-03-06	TINY	ETF	25.06	35.75	25.0	30.0	1472400.0
2000-03-06	XLB	ETF	10.5781	10.5781	10.125	10.2344	41800.0
2000-03-06	XLE	ETF	13.3438	13.5	13.2656	13.3594	559600.0
2000-03-06	XLF	ETF	16.9197	17.0974	16.6785	16.8435	1878260.0
2000-03-06	XLI	ETF	26.25	26.4844	26.0156	26.2344	292100.0
2000-03-06	XLK	ETF	29.289	29.7031	29.0	29.2422	1335000.0
2000-03-06	XLP	ETF	20.0781	20.3125	19.7812	19.7812	315100.0
2000-03-06	XLU	ETF	12.9531	12.9531	12.75	12.75	158400.0
2000-03-06	XLV	ETF	28.4531	28.6094	28.0781	28.0781	316300.0
2000-03-06	XLY	ETF	12.789	12.8125	12.5	12.6094	1200400.0

> showing 46 of 46 rows — these rows as CSV

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