PREVIEW / etf_daily / 2023-12-19

all etf daily files

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

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-19	SPY	ETF	472.53	474.92	472.45	474.84	55761800.0
2023-12-19	QQQ	ETF	407.54	409.28	407.345	409.16	35711855.0
2023-12-19	IWM	ETF	198.48	201.3	198.02	200.93	52156200.0
2023-12-19	DIA	ETF	373.24	375.56	373.12	375.5	3749200.0
2023-12-19	GLD	ETF	188.23	189.72	188.13	189.13	6025600.0
2023-12-19	TLT	ETF	98.86	99.26	98.66	98.89	30018400.0
2023-12-19	AAA	ETF	25.01	25.11	25.0	25.09	4500.0
2023-12-19	AAAU	ETF	20.12	20.27	20.11	20.2	1353600.0
2023-12-19	AADR	ETF	55.83	56.22	55.83	56.22	400.0
2023-12-19	AAPB	ETF	28.33	28.45	28.21	28.45	22443.0
2023-12-19	AAPD	ETF	20.03	20.03	19.93	19.93	57394.0
2023-12-19	AAPU	ETF	28.47	28.65	28.46	28.65	79966.0
2023-12-19	AAPY	ETF	27.2	27.2	27.16	27.196	287.0
2023-12-19	AAXJ	ETF	65.94	66.41	65.94	66.35	698000.0
2023-12-19	ABEQ	ETF	28.49	28.7	28.49	28.626	5300.0
2023-12-19	ACES	ETF	36.15	36.82	36.08	36.73	75100.0
2023-12-19	ACIO	ETF	33.19	33.28	33.145	33.28	45800.0
2023-12-19	ACSI	ETF	50.19	50.585	50.19	50.585	500.0
2023-12-19	ACT	ETF	28.6	29.08	28.6	28.95	307932.0
2023-12-19	ACTV	ETF	33.39	33.594	33.38	33.558	5300.0
2023-12-19	ACVF	ETF	36.484	36.512	36.446	36.512	2700.0
2023-12-19	ACWF	ETF	38.1396	38.21	38.1106	38.1725	2073.0
2023-12-19	ACWI	ETF	101.74	102.17	101.67	102.15	8803800.0
2023-12-19	ACWV	ETF	100.14	100.42	100.14	100.37	104700.0
2023-12-19	ACWX	ETF	50.79	51.0	50.78	51.0	1655700.0
2023-12-19	ADFI	ETF	8.565	8.58	8.558	8.56	14600.0
2023-12-19	ADIV	ETF	13.724	13.724	13.724	13.724	100.0
2023-12-19	ADME	ETF	38.385	38.518	38.385	38.518	5000.0
2023-12-19	ADPV	ETF	24.89	24.89	24.8755	24.8755	488.0
2023-12-19	AEMB	ETF	38.043	38.043	38.043	38.043	100.0
2023-12-19	AESR	ETF	13.78	13.8	13.75	13.8	25000.0
2023-12-19	AETH	ETF	32.82	32.82	31.72	32.2046	5188.0
2023-12-19	AFIF	ETF	8.99	9.03	8.96	9.0	74200.0
2023-12-19	AFK	ETF	13.58	13.79	13.58	13.75	9200.0
2023-12-19	AFLG	ETF	27.547	27.547	27.547	27.547	100.0
2023-12-19	AFSM	ETF	27.37	27.478	27.295	27.478	1400.0
2023-12-19	AFTY	ETF	13.45	13.48	13.45	13.458	300.0
2023-12-19	AGG	ETF	98.63	98.78	98.59	98.61	13787100.0
2023-12-19	AGGH	ETF	22.145	22.19	22.1015	22.19	38882.0
2023-12-19	AGGY	ETF	43.9	43.97	43.87	43.87	106400.0
2023-12-19	AGNG	ETF	27.92	28.12	27.92	28.12	1300.0
2023-12-19	AGOX	ETF	24.58	24.58	24.24	24.421	27600.0
2023-12-19	AGQ	ETF	27.64	28.17	27.57	27.93	1123400.0
2023-12-19	AGQI	ETF	13.05	13.105	13.05	13.07	11992.0
2023-12-19	AGZ	ETF	108.06	108.07	107.9	107.98	37000.0
2023-12-19	AGZD	ETF	21.92	21.97	21.8	21.92	84000.0
2023-12-19	AHLT	ETF	23.75	24.06	23.75	23.9535	15463.0
2023-12-19	AHYB	ETF	45.26	45.272	45.26	45.272	700.0
2023-12-19	AIA	ETF	57.18	57.7	57.18	57.53	17200.0
2023-12-19	AIEQ	ETF	35.11	35.846	35.11	35.73	71300.0

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

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