PREVIEW / etf_daily / 2023-12-22

all etf daily files

  file:    by_date/etf_daily/2023/2023-12-22.parquet
  size:    115 KB
  rows:    3,212

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-22	SPY	ETF	473.86	475.38	471.7	473.65	67126600.0
2023-12-22	QQQ	ETF	409.0	409.97	406.4787	408.38	34314003.0
2023-12-22	IWM	ETF	200.88	202.81	200.19	201.48	39156100.0
2023-12-22	DIA	ETF	373.64	375.31	372.58	373.8	3330400.0
2023-12-22	GLD	ETF	191.6	191.88	190.07	190.27	7175400.0
2023-12-22	TLT	ETF	99.38	99.38	98.24	98.48	29237200.0
2023-12-22	AAA	ETF	24.96	25.062	24.96	25.055	1800.0
2023-12-22	AAAU	ETF	20.48	20.51	20.32	20.34	1429700.0
2023-12-22	AADR	ETF	55.9	56.12	55.87	55.88	1900.0
2023-12-22	AAPB	ETF	27.9216	27.9301	27.45	27.55	6953.0
2023-12-22	AAPD	ETF	19.87	20.09	19.85	20.04	213447.0
2023-12-22	AAPU	ETF	27.82	28.01	27.51	27.66	103854.0
2023-12-22	AAXJ	ETF	64.62	65.04	64.62	64.92	547800.0
2023-12-22	ABCS	ETF	25.3	25.3	25.2676	25.2676	10006.0
2023-12-22	ABEQ	ETF	28.52	28.7	28.52	28.62	5100.0
2023-12-22	ACES	ETF	36.0	36.32	35.745	35.95	67600.0
2023-12-22	ACIO	ETF	33.23	33.27	33.09	33.149	49100.0
2023-12-22	ACSI	ETF	49.937	49.937	49.937	49.937	100.0
2023-12-22	ACT	ETF	29.39	29.48	28.8101	29.17	220288.0
2023-12-22	ACTV	ETF	33.12	33.38	33.0	33.15	24900.0
2023-12-22	ACVF	ETF	36.47	36.48	36.34	36.428	13700.0
2023-12-22	ACWF	ETF	37.74	37.77	37.59	37.6613	4202.0
2023-12-22	ACWI	ETF	101.15	101.47	100.8	101.18	3520000.0
2023-12-22	ACWV	ETF	98.98	99.28	98.84	99.07	119100.0
2023-12-22	ACWX	ETF	50.38	50.57	50.3	50.45	2406000.0
2023-12-22	ADFI	ETF	8.6	8.6	8.58	8.585	11600.0
2023-12-22	ADIV	ETF	13.695	13.701	13.695	13.701	400.0
2023-12-22	ADME	ETF	38.47	38.48	38.38	38.38	6500.0
2023-12-22	AEMB	ETF	38.28	38.28	38.095	38.095	2000.0
2023-12-22	AESR	ETF	13.8	13.83	13.755	13.76	21100.0
2023-12-22	AETH	ETF	32.21	32.65	32.21	32.5008	3546.0
2023-12-22	AFIF	ETF	9.03	9.05	8.99	9.01	9700.0
2023-12-22	AFK	ETF	13.86	14.08	13.79	13.96	20300.0
2023-12-22	AFLG	ETF	27.199	27.199	27.199	27.199	100.0
2023-12-22	AFMC	ETF	26.759	26.759	26.759	26.759	100.0
2023-12-22	AFSM	ETF	27.66	27.66	27.502	27.502	400.0
2023-12-22	AFTY	ETF	13.4	13.49	13.4	13.465	1900.0
2023-12-22	AGG	ETF	99.13	99.14	98.81	98.83	13234700.0
2023-12-22	AGGH	ETF	23.62	23.62	22.14	22.24	12571.0
2023-12-22	AGGY	ETF	43.89	43.89	43.78	43.82	64700.0
2023-12-22	AGNG	ETF	28.15	28.26	28.14	28.174	3800.0
2023-12-22	AGOX	ETF	24.15	24.41	24.035	24.242	132000.0
2023-12-22	AGQ	ETF	28.9	29.16	27.93	28.07	1888100.0
2023-12-22	AGQI	ETF	13.13	13.1895	13.13	13.142	14623.0
2023-12-22	AGZ	ETF	108.39	108.39	108.17	108.21	67300.0
2023-12-22	AGZD	ETF	21.8	21.88	21.68	21.86	180000.0
2023-12-22	AHLT	ETF	22.25	22.25	22.0965	22.11	7539.0
2023-12-22	AHOY	ETF	21.66	21.66	21.5822	21.5822	618.0
2023-12-22	AHYB	ETF	45.51	45.51	45.39	45.39	87600.0
2023-12-22	AIA	ETF	55.88	56.34	55.88	56.2	36100.0

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

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