PREVIEW / etf_daily / 2000-03-07

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-07.parquet
  size:    6 KB
  rows:    47

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-07	SPY	ETF	140.0	140.1562	135.2188	137.0469	20062000.0
2000-03-07	QQQ	ETF	56.9062	56.9375	54.375	55.125	39471000.0
2000-03-07	DIA	ETF	101.4688	101.5312	97.5312	98.0	3745500.0
2000-03-07	BBH	ETF	81.5833	81.5833	73.1667	74.4583	3331800.0
2000-03-07	BITS	ETF	40.0	40.5	37.5	37.5	32950.0
2000-03-07	CEF	ETF	3.4375	3.6875	3.4375	3.625	35900.0
2000-03-07	CHB	ETF	6.0	6.0	5.75	5.81	72300.0
2000-03-07	CNXT	ETF	105.0	105.0	96.5	98.06	5932300.0
2000-03-07	CSB	ETF	3.79999995231628	4.0	3.79999995231628	4.0	8000.0
2000-03-07	EWA	ETF	10.1875	10.625	10.1875	10.5625	9400.0
2000-03-07	EWC	ETF	18.125	18.125	17.8125	18.0	23500.0
2000-03-07	EWD	ETF	37.3125	37.3125	36.5	36.625	6900.0
2000-03-07	EWG	ETF	29.25	29.25	28.375	28.375	77800.0
2000-03-07	EWH	ETF	13.875	13.9375	13.4375	13.5	72000.0
2000-03-07	EWI	ETF	53.75	54.25	53.25	53.25	2150.0
2000-03-07	EWJ	ETF	60.5	60.75	59.5	59.75	221275.0
2000-03-07	EWK	ETF	12.3125	12.4375	12.0625	12.1875	3900.0
2000-03-07	EWL	ETF	14.8125	14.8125	14.3125	14.625	9600.0
2000-03-07	EWM	ETF	27.75	28.0	27.25	27.75	60075.0
2000-03-07	EWN	ETF	24.0	24.0	23.5	23.5625	8800.0
2000-03-07	EWO	ETF	7.0625	7.0625	7.0625	7.0625	2700.0
2000-03-07	EWP	ETF	29.625	29.625	28.8125	28.8125	31200.0
2000-03-07	EWQ	ETF	29.25	29.25	28.5	28.5	71100.0
2000-03-07	EWS	ETF	14.25	14.5	13.5	13.875	366650.0
2000-03-07	EWU	ETF	40.125	40.125	38.5	38.5	64050.0
2000-03-07	EWW	ETF	19.3125	20.4375	19.125	19.75	75700.0
2000-03-07	FCTR	ETF	13.0625	13.4375	13.0	13.0625	26600.0
2000-03-07	FMAR	ETF	6.5	6.59	6.38	6.59	3100.0
2000-03-07	GLDB	ETF	7.0	7.5	7.0	7.375	94100.0
2000-03-07	GSIG	ETF	24.69	25.75	21.62	21.87	808600.0
2000-03-07	IGLD	ETF	2400.0	2625.0	2393.75	2512.5	2751.0
2000-03-07	KTEC	ETF	9.125	9.375	8.875	9.0	14200.0
2000-03-07	MDY	ETF	89.1875	89.2188	86.875	87.375	629800.0
2000-03-07	MIG	ETF	5.875	5.9375	5.625	5.875	7100.0
2000-03-07	PPH	ETF	37.9375	37.9375	36.0312	36.1562	585200.0
2000-03-07	SFY	ETF	13.25	13.625	12.9375	13.375	192700.0
2000-03-07	TDSC	ETF	5.94	6.095	5.56	5.72	170400.0
2000-03-07	TINY	ETF	34.97	35.12	30.44	32.5	763800.0
2000-03-07	XLB	ETF	10.289	10.2969	9.875	9.9062	396800.0
2000-03-07	XLE	ETF	13.3281	14.2812	13.3281	14.2812	999000.0
2000-03-07	XLF	ETF	16.6531	16.8054	16.1454	16.3358	1253281.0
2000-03-07	XLI	ETF	26.4531	26.4531	25.1875	25.1875	50300.0
2000-03-07	XLK	ETF	29.5781	29.75	28.4375	28.4375	2609600.0
2000-03-07	XLP	ETF	19.2031	19.2031	18.3438	18.7188	224100.0
2000-03-07	XLU	ETF	12.9531	13.0234	12.5234	12.6016	163800.0
2000-03-07	XLV	ETF	28.0938	28.25	27.5	27.5625	635200.0
2000-03-07	XLY	ETF	12.5625	12.5625	12.164	12.2578	12600.0

> showing 47 of 47 rows — these rows as CSV

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