PREVIEW / etf_daily / 2023-11-02

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-02.parquet
  size:    111 KB
  rows:    3,112

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-11-02	SPY	ETF	426.58	430.92	426.56	430.76	94938900.0
2023-11-02	QQQ	ETF	361.54	363.68	360.3	363.44	58162442.0
2023-11-02	IWM	ETF	167.75	170.0	167.33	169.87	50458100.0
2023-11-02	DIA	ETF	334.78	338.52	334.41	338.39	5356300.0
2023-11-02	GLD	ETF	184.13	184.28	183.5	184.12	7343700.0
2023-11-02	TLT	ETF	86.68	87.31	86.22	87.04	69739400.0
2023-11-02	AAA	ETF	24.87	24.91	24.84	24.84	1400.0
2023-11-02	AAAU	ETF	19.67	19.68	19.6	19.67	1041100.0
2023-11-02	AADR	ETF	48.79	49.06	48.79	49.06	400.0
2023-11-02	AAPB	ETF	23.62	24.1	23.62	24.1	39474.0
2023-11-02	AAPD	ETF	22.1	22.22	21.94	21.96	860490.0
2023-11-02	AAPU	ETF	24.32	24.77	24.29	24.77	451664.0
2023-11-02	AAPY	ETF	25.9317	25.9317	25.9181	25.9181	402.0
2023-11-02	AAXJ	ETF	62.67	62.84	62.52	62.79	723200.0
2023-11-02	ABEQ	ETF	27.07	27.285	27.07	27.285	4400.0
2023-11-02	ACES	ETF	29.99	31.4	29.98	31.33	90000.0
2023-11-02	ACIO	ETF	30.72	30.89	30.64	30.88	82200.0
2023-11-02	ACSI	ETF	45.11	45.11	45.11	45.11	100.0
2023-11-02	ACT	ETF	28.69	28.89	27.29	27.89	176600.0
2023-11-02	ACTV	ETF	28.19	28.51	28.19	28.51	13200.0
2023-11-02	ACVF	ETF	32.6	33.1	32.6	33.069	10400.0
2023-11-02	ACWF	ETF	34.22	34.45	34.22	34.4227	7831.0
2023-11-02	ACWI	ETF	92.07	92.77	91.98	92.72	2577500.0
2023-11-02	ACWV	ETF	95.1	95.83	95.1	95.75	157900.0
2023-11-02	ACWX	ETF	46.76	46.97	46.64	46.94	2319000.0
2023-11-02	ADFI	ETF	8.17	8.21	8.17	8.18	12500.0
2023-11-02	ADIV	ETF	13.285	13.285	13.285	13.285	100.0
2023-11-02	ADME	ETF	35.14	35.425	35.14	35.375	21000.0
2023-11-02	ADPV	ETF	22.418	22.418	22.37	22.395	13263.0
2023-11-02	AEMB	ETF	35.55	35.685	35.55	35.685	100.0
2023-11-02	AESR	ETF	12.12	12.205	12.12	12.195	24800.0
2023-11-02	AETH	ETF	27.5492	27.5492	27.13	27.2863	722.0
2023-11-02	AFIF	ETF	8.92	8.92	8.89	8.9	17700.0
2023-11-02	AFK	ETF	13.55	13.72	13.55	13.64	3300.0
2023-11-02	AFLG	ETF	24.905	24.905	24.905	24.905	100.0
2023-11-02	AFMC	ETF	23.253	23.253	23.253	23.253	100.0
2023-11-02	AFSM	ETF	23.17	23.392	23.17	23.392	200.0
2023-11-02	AFTY	ETF	14.202	14.202	14.202	14.202	100.0
2023-11-02	AGG	ETF	93.68	93.76	93.37	93.61	11166700.0
2023-11-02	AGGH	ETF	20.96	21.2	20.96	21.19	5286.0
2023-11-02	AGGY	ETF	41.44	41.48	41.334	41.45	191200.0
2023-11-02	AGNG	ETF	25.46	25.61	25.46	25.61	1700.0
2023-11-02	AGOV	ETF	74.08	74.08	72.3616	72.3616	924.0
2023-11-02	AGOX	ETF	22.55	22.68	22.52	22.68	38300.0
2023-11-02	AGQ	ETF	26.05	26.15	25.32	25.56	816800.0
2023-11-02	AGZ	ETF	105.88	105.88	105.66	105.78	114500.0
2023-11-02	AGZD	ETF	22.14	22.2	22.05	22.15	175100.0
2023-11-02	AHLT	ETF	25.89	25.92	25.7583	25.8703	6552.0
2023-11-02	AHOY	ETF	19.52	19.5572	19.511	19.5572	5523.0
2023-11-02	AHYB	ETF	43.45	43.457	43.381	43.457	1100.0

> showing 50 of 3,112 rows — these rows as CSV

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