PREVIEW / etf_daily / 2023-12-28

all etf daily files

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

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-28	SPY	ETF	476.88	477.55	476.26	476.69	77158100.0
2023-12-28	QQQ	ETF	412.67	412.92	410.94	411.3	27029152.0
2023-12-28	IWM	ETF	203.79	205.17	203.28	204.04	28930100.0
2023-12-28	DIA	ETF	376.52	377.69	376.52	377.03	2620400.0
2023-12-28	GLD	ETF	192.34	192.89	191.44	191.47	6171500.0
2023-12-28	TLT	ETF	100.09	100.57	99.56	99.78	36213000.0
2023-12-28	AAA	ETF	25.13	25.13	24.95	25.005	19000.0
2023-12-28	AAAU	ETF	20.16	20.62	20.16	20.47	1487500.0
2023-12-28	AADR	ETF	56.05	56.09	55.97	56.06	1100.0
2023-12-28	AAPB	ETF	23.33	23.3899	23.131	23.21	30972.0
2023-12-28	AAPD	ETF	20.0004	20.09	19.9401	20.07	103171.0
2023-12-28	AAPU	ETF	27.72	27.8477	27.54	27.63	98219.0
2023-12-28	AAXJ	ETF	66.41	66.78	66.41	66.5	406000.0
2023-12-28	ABCS	ETF	25.4781	25.49	25.4781	25.4788	11026.0
2023-12-28	ABEQ	ETF	28.52	28.52	28.383	28.44	13900.0
2023-12-28	ACES	ETF	36.38	36.717	36.234	36.41	49700.0
2023-12-28	ACIO	ETF	33.18	33.53	33.18	33.23	67300.0
2023-12-28	ACSI	ETF	50.24	50.24	50.153	50.153	600.0
2023-12-28	ACT	ETF	29.42	29.42	29.07	29.23	105384.0
2023-12-28	ACTV	ETF	33.56	33.633	33.55	33.633	27200.0
2023-12-28	ACVF	ETF	36.65	36.68	36.615	36.63	6000.0
2023-12-28	ACWF	ETF	37.95	38.0277	37.9149	37.9149	8809.0
2023-12-28	ACWI	ETF	102.13	102.28	101.91	101.96	3909100.0
2023-12-28	ACWV	ETF	99.76	100.27	99.76	100.07	105600.0
2023-12-28	ACWX	ETF	51.13	51.27	50.98	50.98	899000.0
2023-12-28	ADFI	ETF	8.65	8.65	8.63	8.644	15400.0
2023-12-28	ADIV	ETF	13.97	13.97	13.948	13.948	1300.0
2023-12-28	ADME	ETF	38.45	38.6	38.45	38.55	7200.0
2023-12-28	ADPV	ETF	25.09	25.18	25.09	25.1632	7018.0
2023-12-28	ADVE	ETF	31.68	31.68	31.6557	31.6557	326.0
2023-12-28	AEMB	ETF	38.32	38.32	38.11	38.24	400.0
2023-12-28	AESR	ETF	13.92	13.92	13.86	13.86	30600.0
2023-12-28	AETH	ETF	33.48	33.48	32.74	32.7847	3806.0
2023-12-28	AFIF	ETF	9.06	9.06	9.01	9.03	21900.0
2023-12-28	AFK	ETF	13.99	13.99	13.67	13.82	15100.0
2023-12-28	AFLG	ETF	27.4	27.4	27.314	27.314	300.0
2023-12-28	AFMC	ETF	26.96	26.96	26.878	26.878	300.0
2023-12-28	AFSM	ETF	27.75	27.75	27.675	27.675	500.0
2023-12-28	AFTY	ETF	13.55	13.55	13.49	13.505	1700.0
2023-12-28	AGG	ETF	99.54	99.65	99.31	99.44	7172200.0
2023-12-28	AGGH	ETF	22.39	22.39	22.06	22.13	73470.0
2023-12-28	AGGY	ETF	44.12	44.15	44.03	44.06	99600.0
2023-12-28	AGNG	ETF	28.51	28.53	28.48	28.48	1000.0
2023-12-28	AGOX	ETF	24.26	24.38	24.235	24.355	29800.0
2023-12-28	AGQ	ETF	28.15	28.34	27.61	27.65	1631300.0
2023-12-28	AGQI	ETF	13.2811	13.295	13.25	13.26	126534.0
2023-12-28	AGZ	ETF	108.55	108.57	108.42	108.5	16100.0
2023-12-28	AGZD	ETF	21.96	21.96	21.73	21.88	100200.0
2023-12-28	AHLT	ETF	22.27	22.64	22.218	22.218	4677.0
2023-12-28	AHYB	ETF	45.53	45.53	45.442	45.479	400.0

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

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