PREVIEW / etf_daily / 2023-12-21

all etf daily files

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

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-21	SPY	ETF	471.33	472.98	468.84	472.7	86667500.0
2023-12-21	QQQ	ETF	407.06	408.14	404.47	407.77	45568914.0
2023-12-21	IWM	ETF	198.5	199.82	197.52	199.62	38613400.0
2023-12-21	DIA	ETF	372.89	374.13	371.16	373.88	3837500.0
2023-12-21	GLD	ETF	189.21	189.62	188.75	189.43	4620000.0
2023-12-21	TLT	ETF	99.74	99.84	98.75	98.93	65231200.0
2023-12-21	AAA	ETF	25.12	25.13	24.95	25.045	10500.0
2023-12-21	AAAU	ETF	20.23	20.26	20.17	20.24	2053900.0
2023-12-21	AADR	ETF	55.83	55.97	54.91	55.78	3000.0
2023-12-21	AAPB	ETF	28.011	28.011	27.63	27.88	15971.0
2023-12-21	AAPD	ETF	19.78	20.03	19.674	19.93	138815.0
2023-12-21	AAPU	ETF	28.19	28.38	27.65	27.89	146171.0
2023-12-21	AAPY	ETF	26.73	26.8083	26.73	26.8083	316.0
2023-12-21	AAXJ	ETF	64.59	65.33	64.59	65.33	744300.0
2023-12-21	ABCS	ETF	25.1801	25.1801	25.1801	25.1801	5.0
2023-12-21	ABEQ	ETF	28.4	28.466	28.4	28.466	2700.0
2023-12-21	ACES	ETF	35.38	35.95	35.34	35.86	97400.0
2023-12-21	ACIO	ETF	32.98	33.1	32.949	33.1	53800.0
2023-12-21	ACSI	ETF	50.361	50.361	50.361	50.361	100.0
2023-12-21	ACT	ETF	29.04	29.24	28.91	29.18	249353.0
2023-12-21	ACTV	ETF	32.78	32.99	32.66	32.99	40500.0
2023-12-21	ACTX	ETF	0.0001	0.0001	0.0001	0.0001	42100.0
2023-12-21	ACVF	ETF	36.27	36.34	36.101	36.323	7700.0
2023-12-21	ACWF	ETF	37.47	37.64	37.4234	37.6026	7157.0
2023-12-21	ACWI	ETF	100.6	101.07	100.27	101.03	4268500.0
2023-12-21	ACWV	ETF	98.43	98.6	98.08	98.53	308700.0
2023-12-21	ACWX	ETF	50.2	50.46	50.09	50.46	1821400.0
2023-12-21	ADFI	ETF	8.61	8.61	8.57	8.585	7800.0
2023-12-21	ADIV	ETF	13.76	13.76	13.74	13.74	400.0
2023-12-21	ADME	ETF	38.225	38.35	38.13	38.35	3200.0
2023-12-21	ADPV	ETF	24.63	24.7649	24.6	24.7649	1500.0
2023-12-21	ADVE	ETF	31.12	31.2114	31.051	31.2114	4458.0
2023-12-21	AEMB	ETF	38.07	38.138	38.07	38.138	200.0
2023-12-21	AESR	ETF	13.74	13.76	13.655	13.75	29400.0
2023-12-21	AETH	ETF	33.3	33.3	32.95	33.2068	5766.0
2023-12-21	AFIF	ETF	9.03	9.04	8.98	9.0	25600.0
2023-12-21	AFK	ETF	13.7	13.77	13.64	13.73	21400.0
2023-12-21	AFMC	ETF	26.836	26.836	26.836	26.836	100.0
2023-12-21	AFSM	ETF	27.4	27.47	27.4	27.47	600.0
2023-12-21	AFTY	ETF	13.431	13.48	13.42	13.48	2400.0
2023-12-21	AGG	ETF	99.22	99.26	98.83	98.96	9099100.0
2023-12-21	AGGH	ETF	22.34	22.34	22.14	22.14	65507.0
2023-12-21	AGGY	ETF	44.14	44.14	43.99	44.06	171200.0
2023-12-21	AGNG	ETF	27.71	28.04	27.71	27.98	2300.0
2023-12-21	AGOX	ETF	24.27	24.27	24.08	24.19	47600.0
2023-12-21	AGQ	ETF	28.56	28.89	28.3	28.64	1031400.0
2023-12-21	AGQI	ETF	13.05	13.115	12.94	13.115	50520.0
2023-12-21	AGZ	ETF	108.26	108.36	108.19	108.22	24500.0
2023-12-21	AGZD	ETF	21.98	21.98	21.86	21.97	50600.0
2023-12-21	AHLT	ETF	22.02	22.13	21.9966	22.1029	4540.0

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

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