PREVIEW / etf_daily / 2023-09-26

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-26.parquet
  size:    108 KB
  rows:    3,030

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-26	SPY	ETF	429.09	429.82	425.02	425.88	96168400.0
2023-09-26	QQQ	ETF	356.99	357.54	353.2101	354.21	53657748.0
2023-09-26	IWM	ETF	175.5	177.02	174.29	174.36	30476000.0
2023-09-26	DIA	ETF	337.87	338.74	335.55	336.04	4657300.0
2023-09-26	GLD	ETF	176.83	177.14	176.16	176.28	7181100.0
2023-09-26	TLT	ETF	89.43	89.62	88.71	88.87	38104100.0
2023-09-26	AAA	ETF	24.916	24.916	24.89	24.89	2600.0
2023-09-26	AAAU	ETF	18.89	18.92	18.82	18.83	1470800.0
2023-09-26	AADR	ETF	48.7	48.81	48.02	48.02	700.0
2023-09-26	AAPB	ETF	23.679	23.679	23.04	23.09	14161.0
2023-09-26	AAPD	ETF	22.2	22.6	22.2	22.58	291379.0
2023-09-26	AAPU	ETF	24.48	24.48	23.69	23.73	122022.0
2023-09-26	AAXJ	ETF	63.46	63.57	63.08	63.13	353300.0
2023-09-26	ABEQ	ETF	27.81	27.81	27.54	27.58	21900.0
2023-09-26	ACES	ETF	37.62	38.222	37.47	37.52	109100.0
2023-09-26	ACIO	ETF	30.57	30.57	30.46	30.5	53500.0
2023-09-26	ACSI	ETF	43.98	43.98	43.98	43.98	100.0
2023-09-26	ACT	ETF	27.4	27.64	27.33	27.37	334758.0
2023-09-26	ACTV	ETF	30.33	30.51	30.14	30.159	16100.0
2023-09-26	ACVF	ETF	33.15	33.15	32.85	32.866	6400.0
2023-09-26	ACWF	ETF	34.34	34.34	34.15	34.1823	9790.0
2023-09-26	ACWI	ETF	92.7	92.88	91.9	92.02	4868200.0
2023-09-26	ACWV	ETF	96.45	96.56	95.96	95.96	164100.0
2023-09-26	ACWX	ETF	47.14	47.25	46.84	46.86	931500.0
2023-09-26	ADFI	ETF	8.23	8.24	8.23	8.24	14400.0
2023-09-26	ADIV	ETF	13.35	13.35	13.35	13.35	100.0
2023-09-26	ADME	ETF	35.216	35.27	35.11	35.176	14300.0
2023-09-26	ADPV	ETF	23.8	23.8401	23.6976	23.6976	1625.0
2023-09-26	AEMB	ETF	35.99	35.99	35.99	35.99	100.0
2023-09-26	AESR	ETF	12.15	12.169	12.04	12.12	28900.0
2023-09-26	AFIF	ETF	8.9	8.94	8.9	8.93	21200.0
2023-09-26	AFK	ETF	14.0	14.15	13.9	13.9	9300.0
2023-09-26	AFMC	ETF	23.67	23.67	23.575	23.575	300.0
2023-09-26	AFTY	ETF	14.7	14.721	14.7	14.721	400.0
2023-09-26	AGG	ETF	94.47	94.51	94.15	94.18	15549200.0
2023-09-26	AGGH	ETF	21.5	21.69	21.5	21.67	60809.0
2023-09-26	AGGY	ETF	41.67	41.71	41.558	41.59	105200.0
2023-09-26	AGNG	ETF	26.17	26.17	26.09	26.09	800.0
2023-09-26	AGOV	ETF	73.3	74.29	73.25	73.82	9277.0
2023-09-26	AGOX	ETF	22.52	22.61	22.44	22.53	35000.0
2023-09-26	AGQ	ETF	26.4	26.79	26.24	26.28	687400.0
2023-09-26	AGZ	ETF	105.87	105.95	105.84	105.95	17400.0
2023-09-26	AGZD	ETF	22.2	22.23	22.15	22.18	35400.0
2023-09-26	AHLT	ETF	26.2953	26.4524	26.28	26.4524	418.0
2023-09-26	AHYB	ETF	43.47	43.47	43.359	43.359	2300.0
2023-09-26	AIA	ETF	55.12	55.29	54.77	54.81	34900.0
2023-09-26	AIEQ	ETF	29.9	29.931	29.64	29.682	14500.0
2023-09-26	AIQ	ETF	26.82	26.84	26.46	26.53	354300.0
2023-09-26	AIRR	ETF	51.48	51.75	51.05	51.09	64800.0
2023-09-26	AIVI	ETF	37.8	37.86	37.6	37.6	2400.0

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

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