PREVIEW / etf_daily / 2023-10-02

all etf daily files

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

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-02	SPY	ETF	426.62	428.6	424.46	427.31	83798600.0
2023-10-02	QQQ	ETF	358.54	362.68	357.92	361.26	51625054.0
2023-10-02	IWM	ETF	176.33	176.73	173.15	174.07	42139300.0
2023-10-02	DIA	ETF	334.29	335.02	332.08	334.09	4192600.0
2023-10-02	GLD	ETF	170.23	170.46	169.5	169.65	12706000.0
2023-10-02	TLT	ETF	87.82	87.93	86.71	86.93	44704300.0
2023-10-02	AAA	ETF	24.676	24.765	24.676	24.765	1100.0
2023-10-02	AAAU	ETF	18.18	18.2	18.11	18.12	1312700.0
2023-10-02	AADR	ETF	48.77	48.77	48.77	48.77	300.0
2023-10-02	AAPB	ETF	23.295	23.495	23.1972	23.46	8336.0
2023-10-02	AAPD	ETF	22.68	22.7	22.31	22.33	138065.0
2023-10-02	AAPU	ETF	23.58	24.13	23.54	24.09	44463.0
2023-10-02	AAXJ	ETF	63.5	63.52	63.1	63.26	329300.0
2023-10-02	ABEQ	ETF	26.95	26.99	26.935	26.99	12200.0
2023-10-02	ACES	ETF	36.39	36.39	34.72	34.95	26400.0
2023-10-02	ACIO	ETF	30.43	30.47	30.274	30.4	191800.0
2023-10-02	ACSI	ETF	44.229	44.229	44.229	44.229	100.0
2023-10-02	ACT	ETF	27.27	27.63	27.09	27.54	273458.0
2023-10-02	ACTV	ETF	30.34	30.34	29.86	29.975	15800.0
2023-10-02	ACVF	ETF	33.06	33.1	32.62	32.984	19200.0
2023-10-02	ACWF	ETF	34.31	34.36	34.125	34.2184	24434.0
2023-10-02	ACWI	ETF	92.15	92.29	91.49	91.96	1748700.0
2023-10-02	ACWV	ETF	95.35	95.35	94.22	94.6	424700.0
2023-10-02	ACWX	ETF	46.79	46.81	46.28	46.42	1107600.0
2023-10-02	ADFI	ETF	8.19	8.195	8.18	8.195	4200.0
2023-10-02	ADIV	ETF	13.18	13.18	13.18	13.18	100.0
2023-10-02	ADME	ETF	35.04	35.12	34.87	35.12	63900.0
2023-10-02	ADPV	ETF	23.99	24.0199	23.89	23.94	5285.0
2023-10-02	AEMB	ETF	35.4	35.4	35.4	35.4	100.0
2023-10-02	AESR	ETF	12.25	12.28	12.19	12.24	24300.0
2023-10-02	AETH	ETF	25.9	25.9	24.86	25.0655	2931.0
2023-10-02	AFIF	ETF	8.92	8.93	8.9	8.9	24900.0
2023-10-02	AFK	ETF	14.17	14.17	13.81	13.99	5500.0
2023-10-02	AFLG	ETF	24.649	24.649	24.649	24.649	100.0
2023-10-02	AFMC	ETF	23.705	23.712	23.55	23.671	165600.0
2023-10-02	AFTY	ETF	14.66	14.66	14.656	14.656	700.0
2023-10-02	AGG	ETF	93.43	93.51	93.1	93.13	8880000.0
2023-10-02	AGGH	ETF	21.4	21.4	21.19	21.19	390532.0
2023-10-02	AGGY	ETF	41.38	41.405	41.24	41.26	349500.0
2023-10-02	AGNG	ETF	25.7	25.75	25.6	25.75	100800.0
2023-10-02	AGOV	ETF	73.25	73.75	72.32	72.32	33892.0
2023-10-02	AGOX	ETF	22.72	22.72	22.48	22.61	21000.0
2023-10-02	AGQ	ETF	23.05	23.29	22.33	22.38	2257900.0
2023-10-02	AGRH	ETF	25.66	25.66	25.66	25.66	105.0
2023-10-02	AGZ	ETF	105.27	105.36	105.2	105.2	17300.0
2023-10-02	AGZD	ETF	22.17	22.23	22.14	22.18	288000.0
2023-10-02	AHLT	ETF	26.94	27.3175	26.94	27.3175	1836.0
2023-10-02	AHYB	ETF	43.056	43.056	42.963	42.963	500.0
2023-10-02	AIA	ETF	55.27	55.42	55.03	55.13	22200.0
2023-10-02	AIEQ	ETF	29.68	29.68	29.28	29.31	11300.0

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

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