PREVIEW / etf_daily / 2023-03-29

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-29.parquet
  size:    110 KB
  rows:    2,954

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-03-29	SPY	ETF	399.93	401.6	398.68	401.35	77497900.0
2023-03-29	QQQ	ETF	310.88	313.35	310.05	312.72	53274266.0
2023-03-29	IWM	ETF	175.34	175.55	173.57	175.42	25564800.0
2023-03-29	DIA	ETF	326.58	327.17	325.29	327.08	2531700.0
2023-03-29	GLD	ETF	182.49	183.27	182.24	182.53	4996500.0
2023-03-29	TLT	ETF	103.7	104.45	103.6	104.32	16804400.0
2023-03-29	AAA	ETF	24.535	24.535	24.535	24.535	88.0
2023-03-29	AAAU	ETF	19.48	19.56	19.45	19.47	1057700.0
2023-03-29	AADR	ETF	47.41	47.54	47.24	47.54	1200.0
2023-03-29	AAPB	ETF	21.52	21.7063	21.47	21.7063	1642.0
2023-03-29	AAPD	ETF	24.47	24.47	24.2	24.2443	213809.0
2023-03-29	AAPU	ETF	22.16	22.5	22.16	22.45	119378.0
2023-03-29	AAXJ	ETF	67.28	67.5	67.06	67.37	343300.0
2023-03-29	ABEQ	ETF	27.7	27.74	27.641	27.723	14900.0
2023-03-29	ACES	ETF	44.15	44.88	43.712	44.78	127000.0
2023-03-29	ACIO	ETF	29.86	29.86	29.613	29.75	70300.0
2023-03-29	ACSI	ETF	43.5523	43.5523	43.5523	43.5523	64.0
2023-03-29	ACT	ETF	22.61	22.7	22.49	22.65	47579.0
2023-03-29	ACTV	ETF	29.002	29.1	28.88	29.0471	9951.0
2023-03-29	ACVF	ETF	30.75	30.834	30.72	30.834	2900.0
2023-03-29	ACWF	ETF	32.9499	33.0261	32.945	33.0261	4217.0
2023-03-29	ACWI	ETF	89.29	89.6	89.07	89.53	5193800.0
2023-03-29	ACWV	ETF	95.62	95.84	95.62	95.78	158500.0
2023-03-29	ACWX	ETF	47.99	48.11	47.9	48.06	1185566.0
2023-03-29	ADFI	ETF	8.44	8.475	8.44	8.475	7400.0
2023-03-29	ADIV	ETF	13.697	13.697	13.697	13.697	100.0
2023-03-29	ADME	ETF	33.89	34.1	33.89	34.02	46300.0
2023-03-29	ADPV	ETF	22.85	23.03	22.85	22.986	101727.0
2023-03-29	ADRE	ETF	38.12	38.14	38.06	38.14	110481.0
2023-03-29	AEMB	ETF	37.405	37.405	37.405	37.405	100.0
2023-03-29	AESR	ETF	11.73	11.763	11.72	11.763	12000.0
2023-03-29	AFIF	ETF	8.73	8.775	8.71	8.74	21573.0
2023-03-29	AFK	ETF	15.63	15.84	15.605	15.7358	20235.0
2023-03-29	AFLG	ETF	23.49	23.572	23.49	23.572	100.0
2023-03-29	AFMC	ETF	22.61	22.71	22.61	22.71	100.0
2023-03-29	AFSM	ETF	22.84	22.896	22.84	22.896	1100.0
2023-03-29	AFTY	ETF	16.15	16.15	16.07	16.103	500.0
2023-03-29	AGG	ETF	98.74	99.11	98.72	99.05	5111300.0
2023-03-29	AGGH	ETF	22.834	22.8549	22.834	22.8549	362.0
2023-03-29	AGGY	ETF	43.29	43.45	43.29	43.38	185400.0
2023-03-29	AGNG	ETF	26.491	26.491	26.467	26.467	300.0
2023-03-29	AGOV	ETF	76.12	79.3	76.03	78.205	2796.0
2023-03-29	AGOX	ETF	21.47	21.47	21.3	21.4	82600.0
2023-03-29	AGQ	ETF	29.08	29.58	29.0	29.34	421600.0
2023-03-29	AGZ	ETF	107.83	108.1582	107.83	107.98	56546.0
2023-03-29	AGZD	ETF	21.75	21.815	21.645	21.76	140200.0
2023-03-29	AHHX	ETF	8.3101	8.4	8.27	8.3346	8666.0
2023-03-29	AHYB	ETF	43.452	43.635	43.452	43.635	1600.0
2023-03-29	AIA	ETF	61.17	61.62	61.05	61.44	35227.0
2023-03-29	AIEQ	ETF	28.1	28.348	28.031	28.3	30000.0

> showing 50 of 2,954 rows — these rows as CSV

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