PREVIEW / etf_daily / 2023-10-05

all etf daily files

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

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-05	SPY	ETF	424.36	425.37	421.17	424.5	70142700.0
2023-10-05	QQQ	ETF	359.74	360.15	355.14	358.69	45897390.0
2023-10-05	IWM	ETF	170.8	171.9	169.94	171.35	33365100.0
2023-10-05	DIA	ETF	330.82	331.75	329.39	331.17	3172200.0
2023-10-05	GLD	ETF	168.74	169.0	168.3	168.83	6970200.0
2023-10-05	TLT	ETF	86.11	86.19	85.64	85.83	35758800.0
2023-10-05	AAAU	ETF	18.02	18.05	17.97	18.04	1338400.0
2023-10-05	AADR	ETF	47.46	47.82	47.41	47.82	1100.0
2023-10-05	AAPB	ETF	23.5	23.81	23.32	23.73	15371.0
2023-10-05	AAPD	ETF	22.38	22.505	22.16	22.21	173452.0
2023-10-05	AAPU	ETF	24.04	24.39	23.855	24.32	70000.0
2023-10-05	AAXJ	ETF	62.59	62.81	62.32	62.77	413400.0
2023-10-05	ABEQ	ETF	26.92	26.937	26.79	26.937	18000.0
2023-10-05	ACES	ETF	33.75	33.75	32.7	32.76	54800.0
2023-10-05	ACIO	ETF	30.28	30.29	30.032	30.21	54000.0
2023-10-05	ACT	ETF	27.3	28.07	27.3	28.03	274067.0
2023-10-05	ACTV	ETF	29.52	29.52	29.357	29.371	4700.0
2023-10-05	ACVF	ETF	32.69	32.768	32.51	32.72	9700.0
2023-10-05	ACWF	ETF	34.05	34.05	33.81	34.0186	10030.0
2023-10-05	ACWI	ETF	91.25	91.5	90.69	91.35	8876300.0
2023-10-05	ACWV	ETF	94.41	94.6	94.07	94.41	172400.0
2023-10-05	ACWX	ETF	46.01	46.21	45.86	46.17	1502800.0
2023-10-05	ADFI	ETF	8.16	8.18	8.151	8.16	3900.0
2023-10-05	ADME	ETF	34.67	34.835	34.67	34.785	16400.0
2023-10-05	ADPV	ETF	23.53	23.726	23.53	23.7194	8721.0
2023-10-05	AESR	ETF	12.14	12.168	12.055	12.13	18600.0
2023-10-05	AETH	ETF	24.64	24.64	24.0785	24.1321	3733.0
2023-10-05	AFIF	ETF	8.93	8.93	8.88	8.89	39000.0
2023-10-05	AFK	ETF	13.67	13.86	13.4	13.56	3400.0
2023-10-05	AFLG	ETF	24.535	24.535	24.52	24.52	200.0
2023-10-05	AFMC	ETF	23.24	23.378	23.24	23.378	400.0
2023-10-05	AGG	ETF	93.17	93.22	92.99	93.11	7129400.0
2023-10-05	AGGH	ETF	21.23	21.23	21.13	21.17	53667.0
2023-10-05	AGGY	ETF	41.22	41.244	41.15	41.185	115700.0
2023-10-05	AGNG	ETF	25.545	25.67	25.545	25.639	1700.0
2023-10-05	AGOV	ETF	72.525	72.525	72.525	72.525	52.0
2023-10-05	AGOX	ETF	22.7	22.7	22.35	22.48	17700.0
2023-10-05	AGQ	ETF	22.08	22.24	21.33	21.91	997800.0
2023-10-05	AGRH	ETF	25.6	25.6	25.6	25.6	101.0
2023-10-05	AGZ	ETF	105.15	105.42	105.15	105.39	14100.0
2023-10-05	AGZD	ETF	22.13	22.14	22.04	22.11	17200.0
2023-10-05	AHLT	ETF	26.69	26.69	26.4755	26.4936	651.0
2023-10-05	AHYB	ETF	42.73	42.785	42.73	42.772	700.0
2023-10-05	AIA	ETF	54.64	54.87	54.36	54.82	20200.0
2023-10-05	AIEQ	ETF	29.12	29.169	28.91	29.12	3500.0
2023-10-05	AIQ	ETF	26.9	26.91	26.584	26.88	433300.0
2023-10-05	AIRR	ETF	50.07	50.38	49.75	50.02	49300.0
2023-10-05	AIVI	ETF	36.68	36.86	36.68	36.86	800.0
2023-10-05	AIVL	ETF	87.06	87.17	86.65	87.04	1400.0
2023-10-05	ALTL	ETF	33.77	33.82	33.33	33.61	240000.0

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

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