PREVIEW / etf_daily / 2023-08-24

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-24.parquet
  size:    108 KB
  rows:    3,003

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-24	SPY	ETF	444.69	445.22	436.86	436.89	88517300.0
2023-08-24	QQQ	ETF	372.64	372.74	361.01	361.22	66842491.0
2023-08-24	IWM	ETF	185.25	186.34	183.2	183.22	26582300.0
2023-08-24	DIA	ETF	344.32	346.97	340.97	341.03	3840800.0
2023-08-24	GLD	ETF	177.66	178.49	177.41	177.85	5526400.0
2023-08-24	TLT	ETF	95.13	95.55	94.89	94.91	22300800.0
2023-08-24	AAA	ETF	24.86	24.87	24.84	24.84	2500.0
2023-08-24	AAAU	ETF	18.97	19.06	18.95	19.0	983800.0
2023-08-24	AADR	ETF	51.68	51.68	51.05	51.05	1000.0
2023-08-24	AAPB	ETF	25.56	25.57	24.35	24.44	35659.0
2023-08-24	AAPD	ETF	21.61	22.19	21.61	22.17	169286.0
2023-08-24	AAPU	ETF	25.95	25.99	24.91	24.99	190358.0
2023-08-24	AAXJ	ETF	65.31	65.42	64.7	64.7	567600.0
2023-08-24	ABEQ	ETF	27.95	27.95	27.76	27.76	12600.0
2023-08-24	ACES	ETF	40.39	40.39	39.51	39.519	23100.0
2023-08-24	ACIO	ETF	31.09	31.3	30.86	30.88	106500.0
2023-08-24	ACSI	ETF	45.302	45.302	45.302	45.302	100.0
2023-08-24	ACT	ETF	28.78	29.11	28.78	28.87	115061.0
2023-08-24	ACTV	ETF	31.43	31.43	31.31	31.31	2700.0
2023-08-24	ACVF	ETF	34.31	34.31	33.709	33.709	2100.0
2023-08-24	ACWF	ETF	35.125	35.125	34.7305	34.7305	4813.0
2023-08-24	ACWI	ETF	95.22	95.38	93.89	93.91	1937400.0
2023-08-24	ACWV	ETF	97.23	97.47	96.53	96.62	220800.0
2023-08-24	ACWX	ETF	48.17	48.27	47.74	47.74	590700.0
2023-08-24	ADFI	ETF	8.351	8.37	8.35	8.37	12300.0
2023-08-24	ADIV	ETF	13.2	13.2	13.18	13.182	700.0
2023-08-24	ADME	ETF	36.35	36.435	35.868	35.868	26600.0
2023-08-24	ADPV	ETF	24.44	24.4801	24.27	24.3057	3058.0
2023-08-24	AESR	ETF	12.64	12.64	12.495	12.495	423500.0
2023-08-24	AFIF	ETF	8.88	8.92	8.87	8.89	442300.0
2023-08-24	AFK	ETF	14.7	14.71	14.45	14.46	6100.0
2023-08-24	AFLG	ETF	25.052	25.052	25.052	25.052	100.0
2023-08-24	AFMC	ETF	24.65	24.65	24.416	24.416	1300.0
2023-08-24	AFSM	ETF	24.383	24.383	24.383	24.383	100.0
2023-08-24	AGG	ETF	95.99	96.12	95.85	95.93	8247700.0
2023-08-24	AGGH	ETF	22.1199	22.1199	22.0719	22.0719	30694.0
2023-08-24	AGGY	ETF	42.41	42.47	42.37	42.39	165100.0
2023-08-24	AGNG	ETF	26.88	26.921	26.78	26.85	1700.0
2023-08-24	AGOV	ETF	75.8402	75.8402	75.8402	75.8402	56.0
2023-08-24	AGOX	ETF	23.37	23.37	22.99	22.99	98600.0
2023-08-24	AGQ	ETF	29.75	30.08	29.41	29.6	452900.0
2023-08-24	AGZ	ETF	106.4	106.49	106.39	106.46	11700.0
2023-08-24	AGZD	ETF	22.21	22.26	22.15	22.26	13200.0
2023-08-24	AHYB	ETF	43.82	43.82	43.722	43.722	500.0
2023-08-24	AIA	ETF	57.83	58.0	57.24	57.37	24600.0
2023-08-24	AIEQ	ETF	30.81	30.865	30.47	30.5	26600.0
2023-08-24	AIQ	ETF	28.16	28.16	27.27	27.29	294900.0
2023-08-24	AIRR	ETF	53.8	54.18	52.98	53.07	123100.0
2023-08-24	AIVI	ETF	38.09	38.22	37.9	37.9	10400.0
2023-08-24	AIVL	ETF	92.86	93.04	92.41	92.41	2600.0

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

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