PREVIEW / etf_daily / 2023-08-29

all etf daily files

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

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-29	SPY	ETF	442.65	449.45	442.46	449.16	83081900.0
2023-08-29	QQQ	ETF	366.56	375.13	366.231	374.77	58492371.0
2023-08-29	IWM	ETF	185.54	188.37	184.57	188.23	22986000.0
2023-08-29	DIA	ETF	345.56	348.75	345.4	348.62	3107700.0
2023-08-29	GLD	ETF	178.03	179.88	177.9	179.87	7576600.0
2023-08-29	TLT	ETF	94.97	96.51	94.94	96.31	28478100.0
2023-08-29	AAA	ETF	24.83	24.86	24.83	24.85	2000.0
2023-08-29	AAAU	ETF	19.01	19.21	19.0	19.2	1139200.0
2023-08-29	AADR	ETF	52.29	52.62	52.29	52.61	3000.0
2023-08-29	AAPB	ETF	25.21	26.4	25.21	26.26	21940.0
2023-08-29	AAPD	ETF	21.72	21.755	21.13	21.21	85020.0
2023-08-29	AAPU	ETF	25.78	26.79	25.7	26.65	213542.0
2023-08-29	AAXJ	ETF	65.7	66.5	65.55	66.48	766800.0
2023-08-29	ABEQ	ETF	28.024	28.17	28.024	28.16	7800.0
2023-08-29	ACES	ETF	40.28	41.99	40.04	41.9	122800.0
2023-08-29	ACIO	ETF	31.141	31.48	31.13	31.46	96100.0
2023-08-29	ACSI	ETF	46.39	46.431	46.39	46.431	100.0
2023-08-29	ACT	ETF	29.15	29.15	28.815	28.86	119823.0
2023-08-29	ACTV	ETF	31.73	32.02	31.73	31.991	5900.0
2023-08-29	ACTX	ETF	0.0003	0.0003	0.0003	0.0003	1100.0
2023-08-29	ACVF	ETF	34.16	34.63	34.16	34.614	2500.0
2023-08-29	ACWF	ETF	35.17	35.6985	35.17	35.6985	7172.0
2023-08-29	ACWI	ETF	95.11	96.61	95.1	96.56	2711500.0
2023-08-29	ACWV	ETF	97.47	98.19	97.47	98.12	154200.0
2023-08-29	ACWX	ETF	48.44	49.14	48.37	49.12	1481100.0
2023-08-29	ADFI	ETF	8.41	8.41	8.39	8.395	6700.0
2023-08-29	ADIV	ETF	13.38	13.55	13.38	13.55	500.0
2023-08-29	ADME	ETF	36.27	36.75	36.27	36.729	23300.0
2023-08-29	ADPV	ETF	24.81	25.1089	24.81	25.1089	88475.0
2023-08-29	AEMB	ETF	37.39	37.39	37.39	37.39	100.0
2023-08-29	AESR	ETF	12.72	12.89	12.7	12.89	104700.0
2023-08-29	AFIF	ETF	8.93	8.98	8.91	8.95	44300.0
2023-08-29	AFK	ETF	14.6	14.82	14.55	14.8	5900.0
2023-08-29	AFMC	ETF	25.02	25.15	24.88	25.083	51700.0
2023-08-29	AFSM	ETF	24.968	24.968	24.968	24.968	100.0
2023-08-29	AFTY	ETF	15.1	15.125	15.09	15.125	1100.0
2023-08-29	AGG	ETF	95.91	96.71	95.91	96.7	7386300.0
2023-08-29	AGGH	ETF	22.11	22.11	22.04	22.085	1042.0
2023-08-29	AGGY	ETF	42.29	42.575	42.29	42.57	106800.0
2023-08-29	AGNG	ETF	27.236	27.51	27.236	27.51	102200.0
2023-08-29	AGOV	ETF	74.44	75.1504	74.335	74.9	4482.0
2023-08-29	AGOX	ETF	23.43	23.68	23.376	23.62	15900.0
2023-08-29	AGQ	ETF	29.92	31.22	29.8	31.12	1212300.0
2023-08-29	AGZ	ETF	106.27	106.8	106.27	106.78	133200.0
2023-08-29	AGZD	ETF	22.23	22.31	22.11	22.19	28900.0
2023-08-29	AHOY	ETF	20.51	20.67	20.51	20.636	1318.0
2023-08-29	AHYB	ETF	44.319	44.319	44.319	44.319	400.0
2023-08-29	AIA	ETF	58.41	59.0	58.26	59.0	25100.0
2023-08-29	AIEQ	ETF	30.78	31.37	30.78	31.316	15800.0
2023-08-29	AIQ	ETF	27.78	28.4	27.746	28.39	554500.0

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

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