PREVIEW / etf_daily / 2023-09-29

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-29.parquet
  size:    109 KB
  rows:    3,025

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-29	SPY	ETF	431.67	431.85	425.91	427.48	115078500.0
2023-09-29	QQQ	ETF	361.54	362.95	357.02	358.27	64829616.0
2023-09-29	IWM	ETF	178.97	179.16	176.15	176.74	36682900.0
2023-09-29	DIA	ETF	338.78	338.83	333.91	334.95	3785800.0
2023-09-29	GLD	ETF	173.92	174.03	171.27	171.45	10424900.0
2023-09-29	TLT	ETF	89.27	89.49	88.13	88.69	48989800.0
2023-09-29	AAA	ETF	24.857	24.88	24.857	24.88	1500.0
2023-09-29	AAAU	ETF	18.57	18.58	18.29	18.31	1571500.0
2023-09-29	AADR	ETF	49.02	49.02	49.02	49.02	100.0
2023-09-29	AAPB	ETF	23.08	23.26	22.77	22.84	8388.0
2023-09-29	AAPD	ETF	22.57	22.79	22.4495	22.67	282321.0
2023-09-29	AAPU	ETF	23.84	23.9	23.4	23.57	95543.0
2023-09-29	AAXJ	ETF	64.07	64.13	63.42	63.5	865200.0
2023-09-29	ABEQ	ETF	27.48	27.5	27.31	27.355	3400.0
2023-09-29	ACES	ETF	37.03	37.55	36.29	36.57	66000.0
2023-09-29	ACIO	ETF	30.55	30.615	30.357	30.43	70700.0
2023-09-29	ACSI	ETF	44.268	44.268	44.268	44.268	100.0
2023-09-29	ACT	ETF	27.89	27.905	27.2	27.23	201817.0
2023-09-29	ACTV	ETF	30.6	30.75	30.44	30.514	22200.0
2023-09-29	ACVF	ETF	33.37	33.37	32.986	33.038	16600.0
2023-09-29	ACWF	ETF	34.74	34.74	34.3205	34.3665	4107.0
2023-09-29	ACWI	ETF	93.45	93.45	92.16	92.37	2476000.0
2023-09-29	ACWV	ETF	96.31	96.31	95.22	95.42	112800.0
2023-09-29	ACWX	ETF	47.6	47.6	46.92	47.01	1255900.0
2023-09-29	ADFI	ETF	8.25	8.26	8.23	8.23	9000.0
2023-09-29	ADIV	ETF	13.257	13.257	13.257	13.257	100.0
2023-09-29	ADME	ETF	35.311	35.353	35.03	35.05	20100.0
2023-09-29	ADPV	ETF	24.61	24.6101	24.25	24.25	5124.0
2023-09-29	AESR	ETF	12.35	12.35	12.16	12.221	24900.0
2023-09-29	AFIF	ETF	8.92	8.92	8.9	8.9	42200.0
2023-09-29	AFK	ETF	14.2	14.3	14.08	14.11	2400.0
2023-09-29	AFLG	ETF	24.623	24.697	24.623	24.697	200.0
2023-09-29	AFMC	ETF	23.951	23.951	23.951	23.951	100.0
2023-09-29	AFSM	ETF	24.076	24.076	24.076	24.076	100.0
2023-09-29	AFTY	ETF	14.751	14.751	14.751	14.751	500.0
2023-09-29	AGG	ETF	94.5	94.57	93.97	94.04	13483500.0
2023-09-29	AGGH	ETF	21.5	21.51	21.33	21.33	330066.0
2023-09-29	AGGY	ETF	41.64	41.69	41.456	41.51	187400.0
2023-09-29	AGNG	ETF	26.3	26.3	25.98	26.012	1800.0
2023-09-29	AGOV	ETF	73.05	73.75	73.05	73.75	977.0
2023-09-29	AGOX	ETF	22.89	22.91	22.61	22.672	18100.0
2023-09-29	AGQ	ETF	27.32	27.37	24.49	24.61	2706800.0
2023-09-29	AGRH	ETF	25.68	25.68	25.68	25.68	100.0
2023-09-29	AGZ	ETF	106.08	106.1	105.79	105.8	44800.0
2023-09-29	AGZD	ETF	22.17	22.32	22.12	22.16	31500.0
2023-09-29	AHLT	ETF	26.37	26.64	26.37	26.5926	2460.0
2023-09-29	AHYB	ETF	43.65	43.65	43.424	43.424	400.0
2023-09-29	AIA	ETF	55.95	56.01	55.32	55.45	15900.0
2023-09-29	AIEQ	ETF	30.04	30.072	29.72	29.77	6900.0
2023-09-29	AIQ	ETF	27.16	27.29	26.86	26.91	218100.0

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

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