PREVIEW / etf_daily / 2023-09-18

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-18.parquet
  size:    109 KB
  rows:    3,045

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-09-18	SPY	ETF	443.05	444.97	442.56	443.63	55752200.0
2023-09-18	QQQ	ETF	369.32	371.79	369.03	370.66	36903545.0
2023-09-18	IWM	ETF	183.7	183.76	182.37	182.39	19287800.0
2023-09-18	DIA	ETF	346.28	347.13	345.31	346.15	2122800.0
2023-09-18	GLD	ETF	178.82	179.41	178.38	179.39	5049300.0
2023-09-18	TLT	ETF	92.85	93.53	92.82	93.49	17963400.0
2023-09-18	AAA	ETF	24.815	24.815	24.815	24.815	400.0
2023-09-18	AAAU	ETF	19.11	19.16	19.06	19.16	1187800.0
2023-09-18	AADR	ETF	50.79	50.79	50.79	50.79	100.0
2023-09-18	AAPB	ETF	24.3	24.859	24.2799	24.62	36262.0
2023-09-18	AAPD	ETF	22.2	22.2	21.82	21.97	222416.0
2023-09-18	AAPU	ETF	24.86	25.47	24.86	25.19	213155.0
2023-09-18	AAXJ	ETF	65.13	65.44	65.08	65.43	223600.0
2023-09-18	ABEQ	ETF	28.28	28.414	28.28	28.32	20100.0
2023-09-18	ACES	ETF	41.04	41.04	40.2	40.21	17400.0
2023-09-18	ACIO	ETF	31.22	31.361	31.22	31.286	151400.0
2023-09-18	ACSI	ETF	45.89	46.04	45.89	45.911	1100.0
2023-09-18	ACT	ETF	27.67	28.19	27.67	28.16	134261.0
2023-09-18	ACTV	ETF	31.28	31.32	31.23	31.233	6000.0
2023-09-18	ACVF	ETF	34.32	34.38	34.243	34.272	11600.0
2023-09-18	ACWF	ETF	35.35	35.44	35.35	35.3771	10338.0
2023-09-18	ACWI	ETF	95.6	95.92	95.48	95.72	616000.0
2023-09-18	ACWV	ETF	98.04	98.18	97.72	97.99	72600.0
2023-09-18	ACWX	ETF	48.57	48.62	48.38	48.59	721700.0
2023-09-18	ADFI	ETF	8.31	8.36	8.31	8.33	52700.0
2023-09-18	ADIV	ETF	13.625	13.625	13.625	13.625	100.0
2023-09-18	ADME	ETF	36.51	36.582	36.45	36.46	22500.0
2023-09-18	ADPV	ETF	24.82	24.92	24.82	24.8275	3256.0
2023-09-18	AEMB	ETF	36.59	36.695	36.59	36.695	300.0
2023-09-18	AESR	ETF	12.63	12.69	12.6	12.6	46200.0
2023-09-18	AFIF	ETF	8.88	8.93	8.88	8.91	8300.0
2023-09-18	AFK	ETF	14.7	14.83	14.6	14.65	5100.0
2023-09-18	AFLG	ETF	25.379	25.379	25.379	25.379	100.0
2023-09-18	AFMC	ETF	24.22	24.39	24.22	24.39	2500.0
2023-09-18	AFSM	ETF	24.335	24.335	24.335	24.335	100.0
2023-09-18	AFTY	ETF	14.85	14.899	14.85	14.877	800.0
2023-09-18	AGG	ETF	95.37	95.64	95.36	95.63	6066200.0
2023-09-18	AGGH	ETF	21.92	21.99	21.92	21.9603	77559.0
2023-09-18	AGGY	ETF	42.15	42.26	42.15	42.26	72100.0
2023-09-18	AGNG	ETF	26.96	26.96	26.87	26.87	2500.0
2023-09-18	AGOV	ETF	72.76	72.76	72.76	72.76	3.0
2023-09-18	AGOX	ETF	23.28	23.4	23.24	23.326	21000.0
2023-09-18	AGQ	ETF	27.02	27.19	26.53	27.17	668900.0
2023-09-18	AGRH	ETF	25.7	25.7	25.6895	25.6895	3800.0
2023-09-18	AGZ	ETF	106.26	106.26	106.17	106.22	18500.0
2023-09-18	AGZD	ETF	22.28	22.32	22.24	22.29	10500.0
2023-09-18	AHLT	ETF	26.05	26.09	25.9	25.9712	144709.0
2023-09-18	AHYB	ETF	43.932	43.935	43.921	43.921	400.0
2023-09-18	AIA	ETF	57.31	57.47	57.04	57.47	21300.0
2023-09-18	AIEQ	ETF	30.87	30.9	30.74	30.819	5500.0

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

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