PREVIEW / etf_daily / 2000-07-27

all etf daily files

  file:    by_date/etf_daily/2000/2000-07-27.parquet
  size:    7 KB
  rows:    70

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-07-27	SPY	ETF	145.9375	146.625	144.6875	145.375	7652600.0
2000-07-27	QQQ	ETF	93.9375	95.0625	91.5625	91.875	26141800.0
2000-07-27	IWM	ETF	51.1797	51.1797	49.875	49.875	275000.0
2000-07-27	DIA	ETF	105.5781	106.4844	105.1562	106.0312	804400.0
2000-07-27	BBH	ETF	59.0	59.9792	58.3542	58.6875	2045400.0
2000-07-27	BITS	ETF	16.0	16.5	15.25	15.5	9575.0
2000-07-27	CEF	ETF	3.3125	3.375	3.25	3.375	4000.0
2000-07-27	CHB	ETF	5.88	5.88	5.5	5.56	29500.0
2000-07-27	CNXT	ETF	35.63	35.63	32.25	32.56	6162270.0
2000-07-27	CSB	ETF	2.79999995231628	2.79999995231628	2.79999995231628	2.79999995231628	1000.0
2000-07-27	EWA	ETF	10.4375	10.4375	10.3125	10.3125	2300.0
2000-07-27	EWC	ETF	21.3125	21.3125	20.875	21.125	26400.0
2000-07-27	EWD	ETF	30.25	30.25	29.8125	29.8125	5800.0
2000-07-27	EWG	ETF	24.6875	24.6875	24.25	24.375	37700.0
2000-07-27	EWH	ETF	13.375	13.5	13.25	13.3125	53300.0
2000-07-27	EWI	ETF	51.25	51.25	50.875	50.875	1600.0
2000-07-27	EWJ	ETF	54.0	54.25	53.75	54.25	73600.0
2000-07-27	EWK	ETF	13.8125	14.0	13.8125	14.0	3600.0
2000-07-27	EWL	ETF	16.4375	16.4375	16.125	16.375	68300.0
2000-07-27	EWM	ETF	24.25	24.75	24.25	24.5	15600.0
2000-07-27	EWN	ETF	24.3125	24.3125	23.9375	24.125	7200.0
2000-07-27	EWO	ETF	8.125	8.125	8.125	8.125	400.0
2000-07-27	EWP	ETF	26.375	26.375	26.0625	26.0625	5300.0
2000-07-27	EWQ	ETF	28.6875	28.6875	28.375	28.4375	82000.0
2000-07-27	EWS	ETF	15.0	15.0	14.75	14.875	24350.0
2000-07-27	EWU	ETF	39.0	39.125	38.625	39.0	98400.0
2000-07-27	EWW	ETF	16.9375	17.125	16.875	17.0625	19500.0
2000-07-27	EWY	ETF	18.75	19.0	18.625	19.0	4200.0
2000-07-27	EWZ	ETF	19.75	19.75	19.75	19.75	100.0
2000-07-27	FCTR	ETF	15.375	15.75	15.375	15.375	12600.0
2000-07-27	FMAR	ETF	5.05	5.5	5.05	5.5	2800.0
2000-07-27	GLDB	ETF	4.9375	5.0625	4.9375	4.9688	26100.0
2000-07-27	GSIG	ETF	31.0	32.0	27.12	27.87	1639100.0
2000-07-27	IDU	ETF	35.4375	35.4375	35.4375	35.4375	3400.0
2000-07-27	IGLD	ETF	743.75	750.0	700.0	731.25	548.0
2000-07-27	IJH	ETF	9.8531	9.8672	9.7891	9.8141	335000.0
2000-07-27	IJR	ETF	17.4557	17.4557	17.1667	17.2474	42000.0
2000-07-27	IVE	ETF	59.8125	60.0469	59.3906	59.75	58100.0
2000-07-27	IVV	ETF	145.7188	146.5625	144.875	145.3906	94200.0
2000-07-27	IVW	ETF	22.211	22.3047	22.0039	22.0977	160000.0
2000-07-27	IWB	ETF	76.6719	77.0156	76.6719	77.0156	21700.0
2000-07-27	IWD	ETF	54.9375	55.2188	54.9375	55.1875	15900.0
2000-07-27	IWF	ETF	21.390625	21.484375	21.296875	21.34765	110800.0
2000-07-27	IWV	ETF	79.6875	79.7031	79.2188	79.2188	2100.0
2000-07-27	IYC	ETF	15.3828	15.3828	15.3828	15.3828	400.0
2000-07-27	IYE	ETF	15.3542	15.6354	15.3542	15.5729	10500.0
2000-07-27	IYF	ETF	38.5625	38.5625	38.1875	38.4922	5800.0
2000-07-27	IYH	ETF	12.5938	12.7719	12.5625	12.7719	17500.0
2000-07-27	IYR	ETF	37.2031	37.5938	37.2031	37.5625	121200.0
2000-07-27	IYW	ETF	31.0391	31.0391	30.3125	30.5	10000.0

> showing 50 of 70 rows — these rows as CSV

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