PREVIEW / etf_daily / 2023-12-26

all etf daily files

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

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-26	SPY	ETF	474.07	476.58	473.99	475.65	55387000.0
2023-12-26	QQQ	ETF	409.25	411.56	409.15	410.88	22722545.0
2023-12-26	IWM	ETF	202.21	204.56	201.69	204.1	26879000.0
2023-12-26	DIA	ETF	373.68	376.09	373.58	375.35	2217800.0
2023-12-26	GLD	ETF	190.97	191.74	190.4	191.72	4502700.0
2023-12-26	TLT	ETF	98.54	98.87	98.48	98.76	24019700.0
2023-12-26	AAA	ETF	25.089	25.09	25.045	25.045	600.0
2023-12-26	AAAU	ETF	20.41	20.49	20.35	20.48	1113300.0
2023-12-26	AADR	ETF	54.97	56.04	54.97	56.04	900.0
2023-12-26	AAPB	ETF	27.49	27.56	27.3799	27.39	14279.0
2023-12-26	AAPD	ETF	20.05	20.119	20.015	20.1	226023.0
2023-12-26	AAPU	ETF	27.63	27.66	27.47	27.51	78638.0
2023-12-26	AAXJ	ETF	65.1	65.52	65.1	65.38	388600.0
2023-12-26	ABCS	ETF	25.445	25.445	25.445	25.445	5.0
2023-12-26	ABEQ	ETF	28.66	28.769	28.65	28.769	5700.0
2023-12-26	ACES	ETF	36.12	36.74	36.12	36.56	67600.0
2023-12-26	ACIO	ETF	33.23	33.305	33.17	33.21	31900.0
2023-12-26	ACSI	ETF	50.09	50.09	50.09	50.09	200.0
2023-12-26	ACT	ETF	29.19	29.27	29.08	29.21	121194.0
2023-12-26	ACTV	ETF	33.28	33.56	33.279	33.466	4100.0
2023-12-26	ACVF	ETF	36.22	36.512	36.22	36.512	6200.0
2023-12-26	ACWF	ETF	37.7853	37.885	37.7105	37.8272	3431.0
2023-12-26	ACWI	ETF	101.4	101.84	101.3	101.67	3021300.0
2023-12-26	ACWV	ETF	99.37	99.41	99.06	99.27	107400.0
2023-12-26	ACWX	ETF	50.46	51.05	50.46	50.74	1062200.0
2023-12-26	ADFI	ETF	8.6	8.6	8.571	8.595	9800.0
2023-12-26	ADIV	ETF	13.78	13.78	13.78	13.78	100.0
2023-12-26	ADME	ETF	38.505	38.58	38.49	38.523	10100.0
2023-12-26	ADPV	ETF	25.005	25.11	25.005	25.0512	293.0
2023-12-26	AEMB	ETF	38.098	38.098	38.098	38.098	100.0
2023-12-26	AESR	ETF	13.85	13.87	13.82	13.85	11500.0
2023-12-26	AETH	ETF	31.61	31.61	30.53	30.7647	3896.0
2023-12-26	AFIF	ETF	9.02	9.05	8.99	9.02	12500.0
2023-12-26	AFK	ETF	13.76	14.12	13.62	14.05	16000.0
2023-12-26	AFLG	ETF	27.23	27.37	27.23	27.289	600.0
2023-12-26	AFMC	ETF	26.933	26.933	26.933	26.933	100.0
2023-12-26	AFSM	ETF	27.771	27.771	27.771	27.771	100.0
2023-12-26	AFTY	ETF	13.43	13.44	13.422	13.44	400.0
2023-12-26	AGG	ETF	98.93	99.08	98.89	99.03	5418500.0
2023-12-26	AGGH	ETF	22.55	22.55	21.92	21.95	26760.0
2023-12-26	AGGY	ETF	43.83	43.89	43.81	43.89	64400.0
2023-12-26	AGNG	ETF	28.21	28.35	28.21	28.35	1200.0
2023-12-26	AGOX	ETF	24.22	24.43	24.22	24.39	41900.0
2023-12-26	AGQ	ETF	28.27	28.32	27.86	28.29	658700.0
2023-12-26	AGQI	ETF	13.15	13.25	13.15	13.225	10812.0
2023-12-26	AGZ	ETF	108.23	108.29	108.19	108.28	23400.0
2023-12-26	AGZD	ETF	21.84	21.86	21.76	21.86	112100.0
2023-12-26	AHLT	ETF	22.365	22.89	22.15	22.2231	79627.0
2023-12-26	AHYB	ETF	45.37	45.46	45.37	45.46	2700.0
2023-12-26	AIA	ETF	56.77	56.96	56.58	56.79	24400.0

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

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