PREVIEW / etf_daily / 2001-01-31

all etf daily files

  file:    by_date/etf_daily/2001/2001-01-31.parquet
  size:    8 KB
  rows:    95

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
2001-01-31	SPY	ETF	137.4	138.7	136.6	137.02	9706900.0
2001-01-31	QQQ	ETF	67.25	68.0	64.3	64.3	59334200.0
2001-01-31	IWM	ETF	51.225	51.525	50.45	50.45	922400.0
2001-01-31	DIA	ETF	109.0	109.5	108.3	108.67	1740200.0
2001-01-31	BBH	ETF	52.6333	52.6333	50.67	50.76	2175900.0
2001-01-31	BITS	ETF	11.5	12.75	11.5	12.25	5975.0
2001-01-31	CEF	ETF	3.17	3.17	3.13	3.14	25300.0
2001-01-31	CHB	ETF	7.14	7.25	7.01	7.06	70500.0
2001-01-31	CNXT	ETF	18.87	20.0	17.81	18.06	3803240.0
2001-01-31	CSB	ETF	1.20000004768372	1.20000004768372	1.20000004768372	1.20000004768372	3000.0
2001-01-31	DGT	ETF	80.68	80.68	79.94	79.94	1000.0
2001-01-31	EWA	ETF	9.7	9.92	9.7	9.92	23400.0
2001-01-31	EWC	ETF	14.25	14.35	14.1	14.1	25400.0
2001-01-31	EWD	ETF	19.38	19.75	19.36	19.54	59300.0
2001-01-31	EWG	ETF	20.2	20.6	20.06	20.5	173000.0
2001-01-31	EWH	ETF	12.26	12.26	12.15	12.15	61600.0
2001-01-31	EWI	ETF	45.76	45.86	45.5	45.68	45400.0
2001-01-31	EWJ	ETF	44.04	44.24	43.76	44.0	129025.0
2001-01-31	EWK	ETF	12.7	12.8	12.7	12.8	4000.0
2001-01-31	EWL	ETF	16.52	16.59	16.37	16.4	14100.0
2001-01-31	EWM	ETF	21.6	22.6	21.6	22.6	9800.0
2001-01-31	EWN	ETF	22.75	23.05	22.75	22.82	17700.0
2001-01-31	EWO	ETF	7.89	7.89	7.89	7.89	1200.0
2001-01-31	EWP	ETF	25.52	25.55	25.31	25.49	56600.0
2001-01-31	EWQ	ETF	24.54	25.24	24.51	24.99	105200.0
2001-01-31	EWS	ETF	13.26	13.44	13.26	13.3	15850.0
2001-01-31	EWT	ETF	26.5	27.0	26.14	26.14	185450.0
2001-01-31	EWU	ETF	35.2	35.66	34.98	35.66	64850.0
2001-01-31	EWW	ETF	15.55	15.65	15.05	15.35	34800.0
2001-01-31	EWY	ETF	15.4	15.45	15.1	15.1	27000.0
2001-01-31	EWZ	ETF	18.3	18.75	18.3	18.75	54600.0
2001-01-31	EZU	ETF	36.75	37.0781	36.5156	37.0781	45400.0
2001-01-31	FCTR	ETF	15.75	15.75	14.75	14.9375	17200.0
2001-01-31	FMAR	ETF	6.12	6.25	6.0	6.0	3100.0
2001-01-31	GLDB	ETF	6.25	6.375	6.25	6.2813	198200.0
2001-01-31	GRNB	ETF	26.3084	26.3084	26.3084	26.3084	3028.0
2001-01-31	GSIG	ETF	12.5	14.0	12.31	13.31	296800.0
2001-01-31	IDU	ETF	40.0	40.0	39.55	40.0	5800.0
2001-01-31	IEV	ETF	37.525	38.5	37.525	38.25	36200.0
2001-01-31	IGLD	ETF	262.5	265.625	262.5	265.625	38.0
2001-01-31	IJH	ETF	10.63	10.671	10.486	10.5	2021000.0
2001-01-31	IJJ	ETF	22.345	22.505	22.19	22.2125	132000.0
2001-01-31	IJK	ETF	15.6188	15.6775	15.395	15.4625	348800.0
2001-01-31	IJR	ETF	19.005	19.1517	18.8717	18.8717	1524000.0
2001-01-31	IJS	ETF	20.6875	20.95	20.6875	20.7625	64400.0
2001-01-31	IJT	ETF	19.76	19.8475	19.575	19.575	93200.0
2001-01-31	IOO	ETF	36.3672	36.4375	36.0938	36.0938	11400.0
2001-01-31	IUSG	ETF	27.865	27.895	27.605	27.605	31600.0
2001-01-31	IUSV	ETF	25.4233	25.4867	25.4233	25.4533	6600.0
2001-01-31	IVE	ETF	66.58	67.0	66.24	66.26	54700.0

> showing 50 of 95 rows — these rows as CSV

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