PREVIEW / etf_daily / 2023-09-28

all etf daily files

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

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-28	SPY	ETF	425.48	430.25	424.87	428.52	92258300.0
2023-09-28	QQQ	ETF	354.11	360.17	353.24	358.01	56453312.0
2023-09-28	IWM	ETF	176.09	178.57	175.97	177.58	31372400.0
2023-09-28	DIA	ETF	335.32	337.67	334.57	336.62	4053600.0
2023-09-28	GLD	ETF	173.91	174.14	172.32	173.23	10061900.0
2023-09-28	TLT	ETF	87.62	88.73	87.1	88.68	60238000.0
2023-09-28	AAA	ETF	24.88	24.924	24.784	24.9	4200.0
2023-09-28	AAAU	ETF	18.58	18.6	18.41	18.5	2026900.0
2023-09-28	AADR	ETF	49.27	49.27	49.27	49.27	100.0
2023-09-28	AAPB	ETF	22.25	23.002	22.209	22.8	8597.0
2023-09-28	AAPD	ETF	22.89	23.14	22.57	22.73	269530.0
2023-09-28	AAPU	ETF	23.23	23.71	22.85	23.47	112432.0
2023-09-28	AAXJ	ETF	62.98	63.5	62.88	63.41	315500.0
2023-09-28	ABEQ	ETF	27.52	27.56	27.495	27.55	8600.0
2023-09-28	ACES	ETF	36.94	37.0	35.92	36.55	98300.0
2023-09-28	ACIO	ETF	30.405	30.55	30.4	30.5	90900.0
2023-09-28	ACSI	ETF	44.237	44.237	44.237	44.237	100.0
2023-09-28	ACT	ETF	27.7	28.01	27.68	27.85	220435.0
2023-09-28	ACTV	ETF	30.38	30.67	30.31	30.52	16200.0
2023-09-28	ACTX	ETF	0.0003	0.0003	0.0003	0.0003	1009.0
2023-09-28	ACVF	ETF	32.83	33.21	32.83	33.136	1700.0
2023-09-28	ACWF	ETF	34.14	34.5	34.08	34.4337	10049.0
2023-09-28	ACWI	ETF	91.99	92.94	91.82	92.63	2619000.0
2023-09-28	ACWV	ETF	95.45	95.94	95.45	95.8	153200.0
2023-09-28	ACWX	ETF	46.79	47.23	46.72	47.1	1647200.0
2023-09-28	ADFI	ETF	8.18	8.232	8.18	8.232	26900.0
2023-09-28	ADME	ETF	35.02	35.27	35.02	35.15	27600.0
2023-09-28	ADPV	ETF	24.28	24.46	24.28	24.4077	21988.0
2023-09-28	AEMB	ETF	35.839	35.839	35.839	35.839	100.0
2023-09-28	AESR	ETF	12.11	12.32	12.11	12.27	33600.0
2023-09-28	AFIF	ETF	8.88	8.9	8.88	8.89	9900.0
2023-09-28	AFK	ETF	13.95	14.0	13.81	13.94	22600.0
2023-09-28	AFLG	ETF	24.815	24.815	24.815	24.815	100.0
2023-09-28	AFSM	ETF	24.298	24.298	24.298	24.298	100.0
2023-09-28	AGG	ETF	93.7	94.16	93.53	94.13	13334200.0
2023-09-28	AGGH	ETF	21.35	21.41	21.24	21.41	185543.0
2023-09-28	AGGY	ETF	41.36	41.55	41.295	41.55	129900.0
2023-09-28	AGNG	ETF	26.168	26.2	26.155	26.2	1100.0
2023-09-28	AGOV	ETF	72.485	72.485	72.485	72.485	3.0
2023-09-28	AGOX	ETF	22.55	22.875	22.55	22.74	21900.0
2023-09-28	AGQ	ETF	25.42	25.87	25.12	25.64	884800.0
2023-09-28	AGZ	ETF	105.67	105.97	105.38	105.93	30000.0
2023-09-28	AGZD	ETF	22.18	22.29	22.16	22.21	26200.0
2023-09-28	AHLT	ETF	26.97	26.97	26.8	26.8376	838.0
2023-09-28	AHOY	ETF	19.66	19.66	19.6143	19.6143	1792.0
2023-09-28	AHYB	ETF	43.295	43.49	43.295	43.476	200.0
2023-09-28	AIA	ETF	54.65	55.27	54.6	55.19	25000.0
2023-09-28	AIEQ	ETF	29.785	29.929	29.785	29.83	2800.0
2023-09-28	AIQ	ETF	26.5	26.96	26.415	26.82	269200.0
2023-09-28	AIRR	ETF	51.78	52.54	51.78	52.19	253600.0

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

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