PREVIEW / etf_daily / 2023-08-30

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-30.parquet
  size:    107 KB
  rows:    2,993

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-30	SPY	ETF	449.51	451.67	448.78	451.01	69053900.0
2023-08-30	QQQ	ETF	374.88	377.4467	373.86	376.86	41731511.0
2023-08-30	IWM	ETF	187.73	189.61	187.33	188.94	19869900.0
2023-08-30	DIA	ETF	349.1	350.73	348.52	349.4	2792900.0
2023-08-30	GLD	ETF	180.58	180.88	180.29	180.32	6593700.0
2023-08-30	TLT	ETF	96.16	96.4	95.88	96.21	17550100.0
2023-08-30	AAA	ETF	24.84	24.87	24.84	24.87	300.0
2023-08-30	AAAU	ETF	19.28	19.31	19.25	19.26	596100.0
2023-08-30	AADR	ETF	52.98	52.98	52.58	52.58	1200.0
2023-08-30	AAPB	ETF	26.57	27.2	26.47	27.2	28130.0
2023-08-30	AAPD	ETF	21.14	21.14	20.805	20.81	67388.0
2023-08-30	AAPU	ETF	26.78	27.43	26.78	27.41	237113.0
2023-08-30	AAXJ	ETF	65.95	66.32	65.95	66.2	747300.0
2023-08-30	ABEQ	ETF	28.34	28.34	28.22	28.23	4900.0
2023-08-30	ACES	ETF	41.86	42.06	41.635	41.81	14900.0
2023-08-30	ACIO	ETF	31.55	31.63	31.55	31.58	53400.0
2023-08-30	ACSI	ETF	46.592	46.592	46.592	46.592	100.0
2023-08-30	ACT	ETF	28.74	28.98	28.15	28.69	1413973.0
2023-08-30	ACTV	ETF	32.02	32.2	31.939	32.065	7100.0
2023-08-30	ACTX	ETF	0.0003	0.0003	0.0003	0.0003	808.0
2023-08-30	ACVF	ETF	34.56	34.75	34.56	34.709	2200.0
2023-08-30	ACWF	ETF	35.7	35.82	35.691	35.8023	10531.0
2023-08-30	ACWI	ETF	96.63	96.97	96.43	96.8	1707600.0
2023-08-30	ACWV	ETF	98.27	98.43	97.92	98.04	245100.0
2023-08-30	ACWX	ETF	49.1	49.24	48.97	49.07	924900.0
2023-08-30	ADFI	ETF	8.41	8.414	8.4	8.41	12000.0
2023-08-30	ADIV	ETF	13.615	13.636	13.604	13.604	500.0
2023-08-30	ADME	ETF	36.89	36.914	36.88	36.88	5800.0
2023-08-30	ADPV	ETF	25.26	25.4099	25.26	25.3414	2854.0
2023-08-30	AEMB	ETF	37.365	37.365	37.365	37.365	100.0
2023-08-30	AESR	ETF	12.87	12.93	12.79	12.92	43600.0
2023-08-30	AFIF	ETF	8.89	8.99	8.89	8.94	36500.0
2023-08-30	AFK	ETF	14.69	14.79	14.6	14.6	7900.0
2023-08-30	AFMC	ETF	25.15	25.21	25.123	25.123	1100.0
2023-08-30	AFSM	ETF	25.08	25.092	25.08	25.092	200.0
2023-08-30	AFTY	ETF	14.99	14.99	14.96	14.979	700.0
2023-08-30	AGG	ETF	96.78	96.83	96.62	96.66	8752300.0
2023-08-30	AGGH	ETF	22.25	22.25	22.0632	22.0632	5440.0
2023-08-30	AGGY	ETF	42.61	42.622	42.57	42.59	70000.0
2023-08-30	AGNG	ETF	27.45	27.62	27.45	27.467	5800.0
2023-08-30	AGOV	ETF	75.53	75.53	73.475	73.475	3162.0
2023-08-30	AGOX	ETF	23.74	23.82	23.647	23.73	25600.0
2023-08-30	AGQ	ETF	31.57	31.78	30.73	30.78	699600.0
2023-08-30	AGZ	ETF	106.82	106.87	106.8	106.87	30600.0
2023-08-30	AGZD	ETF	22.22	22.25	22.11	22.13	28000.0
2023-08-30	AHYB	ETF	44.32	44.32	44.29	44.293	500.0
2023-08-30	AIA	ETF	58.5	58.75	58.48	58.64	64100.0
2023-08-30	AIEQ	ETF	31.25	31.483	31.25	31.473	6300.0
2023-08-30	AIQ	ETF	28.26	28.5	28.2	28.48	337400.0
2023-08-30	AIRR	ETF	54.7	55.19	54.59	54.83	64200.0

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

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