PREVIEW / etf_daily / 2023-04-03

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-03.parquet
  size:    110 KB
  rows:    2,970

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-04-03	SPY	ETF	408.85	411.37	408.44	410.95	67391100.0
2023-04-03	QQQ	ETF	318.77	320.42	317.4201	320.15	47126839.0
2023-04-03	IWM	ETF	178.95	179.78	176.49	178.48	27609000.0
2023-04-03	DIA	ETF	333.59	336.25	333.51	335.91	3450700.0
2023-04-03	GLD	ETF	183.85	185.04	183.32	184.54	9206600.0
2023-04-03	TLT	ETF	105.88	107.1	105.7	106.6	18234800.0
2023-04-03	AAA	ETF	24.38	24.42	24.38	24.42	805.0
2023-04-03	AAAU	ETF	19.62	19.75	19.56	19.69	2613500.0
2023-04-03	AADR	ETF	48.24	48.58	48.13	48.4	1400.0
2023-04-03	AAPB	ETF	22.58	23.01	22.58	23.01	9447.0
2023-04-03	AAPD	ETF	23.76	23.76	23.445	23.45	147096.0
2023-04-03	AAPU	ETF	23.15	23.5999	23.15	23.58	151664.0
2023-04-03	AAXJ	ETF	67.76	68.14	67.7	68.1	393600.0
2023-04-03	ABEQ	ETF	28.06	28.22	28.05	28.2	10700.0
2023-04-03	ACES	ETF	46.62	46.62	45.27	45.6	9600.0
2023-04-03	ACIO	ETF	30.06	30.32	30.06	30.285	38000.0
2023-04-03	ACSI	ETF	44.3909	44.4589	44.3909	44.4589	461.0
2023-04-03	ACT	ETF	22.86	23.355	22.81	22.96	112076.0
2023-04-03	ACTV	ETF	29.9	29.9	29.58	29.7256	7896.0
2023-04-03	ACVF	ETF	31.6	31.6	31.452	31.574	1300.0
2023-04-03	ACWF	ETF	33.75	33.83	33.61	33.805	26097.0
2023-04-03	ACWI	ETF	91.13	91.73	91.05	91.69	7711200.0
2023-04-03	ACWV	ETF	96.6	97.4	96.59	97.3	122300.0
2023-04-03	ACWX	ETF	48.85	49.14	48.79	49.12	2508396.0
2023-04-03	ADFI	ETF	8.491	8.56	8.491	8.555	2500.0
2023-04-03	ADIV	ETF	13.798	13.798	13.798	13.798	100.0
2023-04-03	ADME	ETF	34.5	34.88	34.5	34.87	23800.0
2023-04-03	ADPV	ETF	23.45	23.45	23.2532	23.4399	9425.0
2023-04-03	AEMB	ETF	37.82	37.83	37.82	37.83	200.0
2023-04-03	AESR	ETF	12.02	12.1	12.01	12.1	12100.0
2023-04-03	AFIF	ETF	8.77	8.81	8.77	8.8003	10540.0
2023-04-03	AFK	ETF	16.12	16.33	16.05	16.18	9064.0
2023-04-03	AFLG	ETF	24.16	24.16	24.16	24.16	100.0
2023-04-03	AFMC	ETF	23.201	23.201	23.201	23.201	100.0
2023-04-03	AFSM	ETF	23.12	23.28	23.11	23.28	33600.0
2023-04-03	AFTY	ETF	16.301	16.32	16.29	16.313	700.0
2023-04-03	AGG	ETF	99.28	99.86	99.21	99.82	7567100.0
2023-04-03	AGGH	ETF	22.86	22.87	22.8001	22.8394	568.0
2023-04-03	AGGY	ETF	43.64	43.88	43.64	43.87	148800.0
2023-04-03	AGNG	ETF	26.77	26.833	26.71	26.833	1500.0
2023-04-03	AGOV	ETF	76.32	76.32	76.32	76.32	2.0
2023-04-03	AGOX	ETF	21.85	21.895	21.68	21.85	22800.0
2023-04-03	AGQ	ETF	30.78	31.56	30.67	31.01	620500.0
2023-04-03	AGZ	ETF	107.91	108.23	107.91	108.23	15994.0
2023-04-03	AGZD	ETF	21.88	21.88	21.725	21.795	78600.0
2023-04-03	AHYB	ETF	44.09	44.167	44.04	44.167	7400.0
2023-04-03	AIA	ETF	61.58	61.76	61.41	61.65	39966.0
2023-04-03	AIEQ	ETF	29.27	29.39	28.925	29.32	14000.0
2023-04-03	AIQ	ETF	24.42	24.54	24.2	24.49	51523.0
2023-04-03	AIRR	ETF	48.21	48.32	47.44	47.91	17400.0

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

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