PREVIEW / etf_daily / 2023-10-09

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-09.parquet
  size:    106 KB
  rows:    2,962

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
2023-10-09	SPY	ETF	427.58	432.88	427.01	432.29	80374400.0
2023-10-09	QQQ	ETF	362.3	367.11	360.78	366.56	45304766.0
2023-10-09	IWM	ETF	171.84	174.55	171.77	174.0	26658400.0
2023-10-09	DIA	ETF	332.95	336.38	332.59	336.09	3756300.0
2023-10-09	GLD	ETF	171.18	172.86	171.08	172.82	10201500.0
2023-10-09	TLT	ETF	85.5	86.8	84.95	86.78	29424900.0
2023-10-09	AAA	ETF	24.78	24.79	24.765	24.775	4700.0
2023-10-09	AAAU	ETF	18.29	18.47	18.28	18.46	1566500.0
2023-10-09	AADR	ETF	46.98	48.61	46.98	48.33	400.0
2023-10-09	AAPB	ETF	23.9632	24.65	23.96	24.65	8079.0
2023-10-09	AAPD	ETF	22.01	22.11	21.71	21.73	126880.0
2023-10-09	AAPU	ETF	24.63	25.13	24.48	25.125	80556.0
2023-10-09	AAXJ	ETF	63.0	63.49	62.87	63.45	245400.0
2023-10-09	ABEQ	ETF	27.01	27.29	27.01	27.263	10300.0
2023-10-09	ACES	ETF	32.97	33.081	32.54	32.99	58900.0
2023-10-09	ACIO	ETF	30.44	30.69	30.38	30.65	82500.0
2023-10-09	ACT	ETF	27.88	28.365	27.88	28.1	204551.0
2023-10-09	ACTV	ETF	29.17	29.389	29.09	29.272	10000.0
2023-10-09	ACVF	ETF	32.89	33.249	32.86	33.249	15000.0
2023-10-09	ACWF	ETF	34.3199	34.5395	34.3	34.5395	554.0
2023-10-09	ACWI	ETF	91.85	92.92	91.78	92.81	3179700.0
2023-10-09	ACWV	ETF	94.59	95.51	94.39	95.47	159800.0
2023-10-09	ACWX	ETF	46.26	46.7	46.23	46.65	1018600.0
2023-10-09	ADFI	ETF	8.17	8.22	8.16	8.2	17500.0
2023-10-09	ADIV	ETF	13.19	13.294	13.19	13.293	3900.0
2023-10-09	ADME	ETF	35.11	35.43	35.11	35.43	26500.0
2023-10-09	ADPV	ETF	24.17	24.1998	24.17	24.1998	621.0
2023-10-09	AEMB	ETF	35.06	35.215	35.06	35.215	500.0
2023-10-09	AESR	ETF	12.27	12.4	12.24	12.38	19200.0
2023-10-09	AETH	ETF	23.79	23.79	23.4756	23.5985	1136.0
2023-10-09	AFIF	ETF	8.9	8.92	8.89	8.89	4200.0
2023-10-09	AFK	ETF	13.49	13.82	13.45	13.82	7800.0
2023-10-09	AFMC	ETF	23.32	23.66	23.32	23.66	1500.0
2023-10-09	AFTY	ETF	14.5	14.56	14.49	14.56	600.0
2023-10-09	AGG	ETF	93.22	93.72	93.15	93.71	4353100.0
2023-10-09	AGGH	ETF	21.25	21.2599	21.22	21.22	4506.0
2023-10-09	AGGY	ETF	41.26	41.41	41.199	41.408	95400.0
2023-10-09	AGNG	ETF	25.8	25.88	25.8	25.812	800.0
2023-10-09	AGOV	ETF	72.8	73.625	72.76	73.625	4008.0
2023-10-09	AGOX	ETF	22.728	22.88	22.65	22.77	29800.0
2023-10-09	AGQ	ETF	23.21	23.81	23.14	23.79	933300.0
2023-10-09	AGRH	ETF	25.63	25.65	25.58	25.58	1353.0
2023-10-09	AGZ	ETF	105.43	105.69	105.43	105.69	9000.0
2023-10-09	AGZD	ETF	22.09	22.19	22.05	22.06	17000.0
2023-10-09	AHLT	ETF	26.5	26.5	26.2928	26.2928	932.0
2023-10-09	AHYB	ETF	43.128	43.148	43.1	43.148	1000.0
2023-10-09	AIA	ETF	55.19	55.71	55.08	55.71	39000.0
2023-10-09	AIEQ	ETF	29.19	29.55	29.19	29.545	5900.0
2023-10-09	AIQ	ETF	27.09	27.47	27.01	27.38	503000.0
2023-10-09	AIRR	ETF	50.45	50.7	50.26	50.62	129000.0

> showing 50 of 2,962 rows — these rows as CSV

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