PREVIEW / etf_daily / 2023-08-02

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-02.parquet
  size:    109 KB
  rows:    3,039

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-08-02	SPY	ETF	453.25	453.52	449.35	450.13	93933400.0
2023-08-02	QQQ	ETF	379.26	379.26	373.13	374.39	72687107.0
2023-08-02	IWM	ETF	195.59	196.09	194.09	195.11	28079700.0
2023-08-02	DIA	ETF	354.48	355.2	352.11	352.74	5061000.0
2023-08-02	GLD	ETF	180.57	180.79	179.41	179.6	6339700.0
2023-08-02	TLT	ETF	97.04	97.24	96.41	97.09	38121300.0
2023-08-02	AAA	ETF	24.63	24.689	24.63	24.66	3900.0
2023-08-02	AAAU	ETF	19.28	19.3	19.16	19.18	775500.0
2023-08-02	AADR	ETF	51.52	51.52	51.14	51.14	1900.0
2023-08-02	AAPB	ETF	29.0	29.1	28.6	28.74	11989.0
2023-08-02	AAPD	ETF	20.06	20.378	20.04	20.29	190779.0
2023-08-02	AAPU	ETF	29.11	29.11	28.48	28.64	156359.0
2023-08-02	AAXJ	ETF	68.42	68.93	67.8	67.9	780100.0
2023-08-02	ABEQ	ETF	28.3	28.47	28.3	28.374	26700.0
2023-08-02	ACES	ETF	46.41	46.41	45.02	45.45	42400.0
2023-08-02	ACIO	ETF	31.64	31.64	31.435	31.474	767200.0
2023-08-02	ACSI	ETF	47.528	47.528	47.528	47.528	100.0
2023-08-02	ACT	ETF	28.39	29.74	28.07	28.18	423826.0
2023-08-02	ACTV	ETF	33.08	33.13	32.801	33.06	21400.0
2023-08-02	ACVF	ETF	34.79	34.79	34.27	34.379	25500.0
2023-08-02	ACWF	ETF	35.88	35.88	35.78	35.8104	3390.0
2023-08-02	ACWI	ETF	97.76	97.83	96.92	97.07	5789100.0
2023-08-02	ACWV	ETF	98.37	98.67	98.27	98.35	74500.0
2023-08-02	ACWX	ETF	49.83	49.87	49.43	49.49	1605200.0
2023-08-02	ADFI	ETF	8.39	8.4	8.39	8.395	9000.0
2023-08-02	ADIV	ETF	14.01	14.04	14.005	14.005	1400.0
2023-08-02	ADME	ETF	36.99	36.99	36.77	36.831	71800.0
2023-08-02	ADPV	ETF	25.66	25.7328	25.53	25.7328	820.0
2023-08-02	AEMB	ETF	37.27	37.299	37.27	37.299	100.0
2023-08-02	AESR	ETF	13.03	13.03	12.909	12.96	23200.0
2023-08-02	AFIF	ETF	8.91	8.93	8.89	8.89	20200.0
2023-08-02	AFK	ETF	15.4	15.74	15.1	15.22	12800.0
2023-08-02	AFLG	ETF	25.87	25.87	25.87	25.87	100.0
2023-08-02	AFMC	ETF	25.577	25.65	25.51	25.544	2300.0
2023-08-02	AFSM	ETF	25.845	25.845	25.845	25.845	100.0
2023-08-02	AFTY	ETF	15.68	15.68	15.67	15.679	1000.0
2023-08-02	AGG	ETF	96.48	96.56	96.23	96.54	8551900.0
2023-08-02	AGGH	ETF	22.21	22.21	22.17	22.17	29010.0
2023-08-02	AGGY	ETF	42.61	42.655	42.52	42.64	103400.0
2023-08-02	AGNG	ETF	27.5	27.5	27.281	27.29	2300.0
2023-08-02	AGOV	ETF	75.24	75.38	75.205	75.205	678.0
2023-08-02	AGOX	ETF	24.23	24.23	23.66	23.71	72400.0
2023-08-02	AGQ	ETF	30.02	30.08	28.68	28.83	864400.0
2023-08-02	AGRH	ETF	25.66	25.71	25.585	25.585	14903.0
2023-08-02	AGZ	ETF	106.29	106.39	106.21	106.36	23700.0
2023-08-02	AGZD	ETF	22.14	22.17	22.01	22.11	32400.0
2023-08-02	AHYB	ETF	43.845	43.845	43.845	43.845	100.0
2023-08-02	AIA	ETF	61.37	61.37	60.69	60.8	16700.0
2023-08-02	AIEQ	ETF	32.91	33.01	32.48	32.729	30900.0
2023-08-02	AIQ	ETF	29.01	29.039	28.475	28.62	362700.0

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

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