PREVIEW / etf_daily / 2023-11-24

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-24.parquet
  size:    106 KB
  rows:    3,005

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-11-24	SPY	ETF	455.07	455.5	454.73	455.3	29737400.0
2023-11-24	QQQ	ETF	389.65	390.25	388.5	389.51	15718832.0
2023-11-24	IWM	ETF	178.05	179.73	177.8	179.33	13846900.0
2023-11-24	DIA	ETF	353.16	353.95	353.04	353.8	1245100.0
2023-11-24	GLD	ETF	185.47	185.75	185.16	185.52	2445100.0
2023-11-24	TLT	ETF	90.1	90.26	89.79	89.8	20199600.0
2023-11-24	AAA	ETF	24.92	25.01	24.92	24.955	1000.0
2023-11-24	AAAU	ETF	19.81	19.85	19.78	19.83	724500.0
2023-11-24	AADR	ETF	53.26	53.55	53.26	53.55	200.0
2023-11-24	AAPB	ETF	27.05	27.05	26.78	26.95	9851.0
2023-11-24	AAPD	ETF	20.48	20.65	20.48	20.5931	61426.0
2023-11-24	AAPU	ETF	27.45	27.45	27.1258	27.26	57596.0
2023-11-24	AAXJ	ETF	65.45	65.74	65.2	65.74	204200.0
2023-11-24	ABEQ	ETF	27.84	27.84	27.825	27.825	400.0
2023-11-24	ACES	ETF	30.5	30.775	30.25	30.61	543200.0
2023-11-24	ACIO	ETF	32.25	32.27	32.24	32.24	171800.0
2023-11-24	ACT	ETF	27.82	27.94	27.75	27.81	59558.0
2023-11-24	ACTV	ETF	29.67	29.83	29.67	29.815	1900.0
2023-11-24	ACVF	ETF	34.81	34.81	34.75	34.786	2800.0
2023-11-24	ACWF	ETF	36.4	36.51	36.4	36.5068	2223.0
2023-11-24	ACWI	ETF	97.72	97.9	97.65	97.88	774500.0
2023-11-24	ACWV	ETF	98.35	98.48	98.2	98.45	53300.0
2023-11-24	ACWX	ETF	49.12	49.38	49.12	49.38	787200.0
2023-11-24	ADFI	ETF	8.31	8.31	8.305	8.305	6000.0
2023-11-24	ADME	ETF	37.13	37.14	37.1	37.14	4500.0
2023-11-24	AEMB	ETF	36.715	36.715	36.715	36.715	100.0
2023-11-24	AESR	ETF	13.05	13.08	13.04	13.08	10400.0
2023-11-24	AETH	ETF	32.2299	32.2299	31.6251	31.8274	1725.0
2023-11-24	AFIF	ETF	8.92	8.94	8.92	8.94	600.0
2023-11-24	AFK	ETF	13.94	14.31	13.94	14.01	2400.0
2023-11-24	AFMC	ETF	24.598	24.598	24.598	24.598	100.0
2023-11-24	AFTY	ETF	14.23	14.295	14.22	14.295	4600.0
2023-11-24	AGG	ETF	95.24	95.32	95.12	95.15	2944300.0
2023-11-24	AGGH	ETF	21.64	21.64	21.37	21.4166	5037.0
2023-11-24	AGGY	ETF	42.15	42.205	42.135	42.135	38300.0
2023-11-24	AGNG	ETF	26.7	26.75	26.7	26.75	1400.0
2023-11-24	AGOX	ETF	23.72	23.75	23.657	23.75	8800.0
2023-11-24	AGQ	ETF	28.24	28.94	28.24	28.92	675400.0
2023-11-24	AGQI	ETF	12.75	12.8	12.74	12.7829	1860716.0
2023-11-24	AGZ	ETF	106.43	106.43	106.38	106.42	6800.0
2023-11-24	AGZD	ETF	22.38	22.41	22.24	22.27	57300.0
2023-11-24	AHLT	ETF	24.61	24.61	24.5699	24.5699	244.0
2023-11-24	AHYB	ETF	44.179	44.179	44.145	44.172	700.0
2023-11-24	AIA	ETF	58.05	58.42	58.05	58.3	14400.0
2023-11-24	AIEQ	ETF	30.88	31.0	30.862	30.955	3400.0
2023-11-24	AIQ	ETF	29.52	29.57	29.47	29.56	167400.0
2023-11-24	AIRR	ETF	51.24	51.5	51.1	51.27	20200.0
2023-11-24	AIVI	ETF	38.94	39.14	38.94	39.14	300.0
2023-11-24	AIVL	ETF	90.81	91.27	90.81	91.13	2700.0
2023-11-24	ALTL	ETF	32.87	32.96	32.85	32.96	26300.0

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

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