PREVIEW / etf_daily / 2023-12-05

all etf daily files

  file:    by_date/etf_daily/2023/2023-12-05.parquet
  size:    114 KB
  rows:    3,164

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-12-05	SPY	ETF	455.26	457.59	454.87	456.6	69793500.0
2023-12-05	QQQ	ETF	384.39	388.5	384.21	387.29	42932956.0
2023-12-05	IWM	ETF	186.05	186.05	183.98	184.39	36873500.0
2023-12-05	DIA	ETF	361.86	362.26	360.7	361.91	5372700.0
2023-12-05	GLD	ETF	187.55	187.88	186.3	187.15	7027700.0
2023-12-05	TLT	ETF	93.63	94.62	93.57	94.61	73588600.0
2023-12-05	AAA	ETF	24.94	24.94	24.88	24.895	6400.0
2023-12-05	AAAU	ETF	20.05	20.07	19.91	20.0	1954400.0
2023-12-05	AADR	ETF	53.63	53.74	53.56	53.74	1800.0
2023-12-05	AAPB	ETF	26.89	27.91	26.89	27.69	15344.0
2023-12-05	AAPD	ETF	20.57	20.57	20.15	20.23	213210.0
2023-12-05	AAPU	ETF	27.28	28.18	27.28	28.0	121281.0
2023-12-05	AAXJ	ETF	64.23	64.41	64.02	64.35	424700.0
2023-12-05	ABEQ	ETF	28.03	28.103	28.03	28.059	5300.0
2023-12-05	ACES	ETF	32.31	32.54	31.84	31.84	78000.0
2023-12-05	ACIO	ETF	32.21	32.28	32.15	32.25	45600.0
2023-12-05	ACSI	ETF	48.321	48.321	48.321	48.321	100.0
2023-12-05	ACT	ETF	27.97	28.1072	27.535	27.55	317644.0
2023-12-05	ACTV	ETF	31.09	31.09	30.91	30.923	10900.0
2023-12-05	ACVF	ETF	34.87	34.91	34.671	34.794	7400.0
2023-12-05	ACWF	ETF	36.56	36.68	36.56	36.6394	4806.0
2023-12-05	ACWI	ETF	97.8	98.18	97.66	97.95	2374800.0
2023-12-05	ACWV	ETF	98.9	99.04	98.74	98.9	65800.0
2023-12-05	ACWX	ETF	49.1	49.25	49.0	49.13	1518000.0
2023-12-05	ADFI	ETF	8.47	8.47	8.44	8.455	11200.0
2023-12-05	ADIV	ETF	13.561	13.561	13.561	13.561	100.0
2023-12-05	ADME	ETF	37.12	37.12	36.97	37.071	14800.0
2023-12-05	ADPV	ETF	23.62	23.64	23.6007	23.6007	2740.0
2023-12-05	AEMB	ETF	37.23	37.23	37.23	37.23	100.0
2023-12-05	AESR	ETF	12.98	13.07	12.97	13.0	70200.0
2023-12-05	AETH	ETF	33.19	34.45	33.065	33.8776	5725.0
2023-12-05	AFIF	ETF	9.0	9.04	9.0	9.04	32700.0
2023-12-05	AFK	ETF	13.94	13.96	13.7	13.92	12300.0
2023-12-05	AFLG	ETF	26.365	26.365	26.365	26.365	100.0
2023-12-05	AFMC	ETF	25.119	25.119	25.119	25.119	100.0
2023-12-05	AFSM	ETF	25.285	25.285	25.285	25.285	100.0
2023-12-05	AFTY	ETF	13.581	13.605	13.58	13.605	1100.0
2023-12-05	AGG	ETF	96.85	97.15	96.79	97.1	8850600.0
2023-12-05	AGGH	ETF	21.77	21.77	21.575	21.65	10626.0
2023-12-05	AGGY	ETF	42.94	43.09	42.94	43.06	394400.0
2023-12-05	AGNG	ETF	26.9	26.9	26.83	26.866	800.0
2023-12-05	AGOX	ETF	23.74	23.869	23.69	23.85	154600.0
2023-12-05	AGQ	ETF	28.87	29.03	27.92	28.35	1283500.0
2023-12-05	AGQI	ETF	12.73	12.76	12.71	12.74	32031.0
2023-12-05	AGZ	ETF	107.14	107.36	107.14	107.27	13000.0
2023-12-05	AGZD	ETF	22.4	22.4	22.32	22.36	34700.0
2023-12-05	AHLT	ETF	23.84	23.9268	23.84	23.904	4999.0
2023-12-05	AHYB	ETF	44.46	44.577	44.46	44.577	1200.0
2023-12-05	AIA	ETF	55.35	55.68	55.31	55.59	46700.0
2023-12-05	AIEQ	ETF	32.35	32.35	31.88	31.945	51900.0

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

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