PREVIEW / etf_daily / 2023-10-13

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-13.parquet
  size:    110 KB
  rows:    3,088

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-10-13	SPY	ETF	435.21	436.45	429.88	431.5	95143100.0
2023-10-13	QQQ	ETF	370.57	371.16	363.86	365.28	52519876.0
2023-10-13	IWM	ETF	172.35	172.7	169.69	170.27	33955600.0
2023-10-13	DIA	ETF	337.48	339.61	335.52	336.68	5154600.0
2023-10-13	GLD	ETF	176.89	179.1	176.72	178.83	18796500.0
2023-10-13	TLT	ETF	87.6	87.83	87.17	87.61	44183800.0
2023-10-13	AAA	ETF	24.84	24.84	24.825	24.825	3300.0
2023-10-13	AAAU	ETF	18.9	19.13	18.88	19.11	1582900.0
2023-10-13	AADR	ETF	49.43	49.43	49.4	49.43	1200.0
2023-10-13	AAPB	ETF	25.111	25.111	24.51	24.6	5727.0
2023-10-13	AAPD	ETF	21.43	21.8477	21.4	21.77	164367.0
2023-10-13	AAPU	ETF	25.65	25.73	24.94	25.09	101501.0
2023-10-13	AAXJ	ETF	63.92	64.14	63.63	63.78	551200.0
2023-10-13	ABEQ	ETF	27.38	27.41	27.34	27.41	5700.0
2023-10-13	ACES	ETF	34.21	34.38	33.53	33.72	237900.0
2023-10-13	ACIO	ETF	30.89	30.94	30.6	30.69	99300.0
2023-10-13	ACT	ETF	28.31	28.43	27.625	27.82	136327.0
2023-10-13	ACTV	ETF	28.96	28.96	28.57	28.658	11300.0
2023-10-13	ACVF	ETF	33.44	33.44	33.183	33.183	1100.0
2023-10-13	ACWF	ETF	34.84	34.84	34.51	34.5157	10584.0
2023-10-13	ACWI	ETF	93.46	93.69	92.42	92.77	5099400.0
2023-10-13	ACWV	ETF	95.53	95.88	95.3	95.62	358900.0
2023-10-13	ACWX	ETF	46.98	47.15	46.66	46.77	1625800.0
2023-10-13	ADFI	ETF	8.17	8.19	8.17	8.185	2600.0
2023-10-13	ADIV	ETF	13.225	13.225	13.225	13.225	100.0
2023-10-13	ADME	ETF	35.75	35.75	35.45	35.458	16900.0
2023-10-13	ADPV	ETF	24.01	24.0101	23.7	23.7	1339.0
2023-10-13	ADVE	ETF	29.57	29.57	29.4593	29.4593	222.0
2023-10-13	AEMB	ETF	35.31	35.31	35.31	35.31	100.0
2023-10-13	AESR	ETF	12.47	12.47	12.31	12.31	7900.0
2023-10-13	AETH	ETF	23.21	23.21	23.0287	23.0287	965.0
2023-10-13	AFIF	ETF	8.94	8.94	8.88	8.89	11900.0
2023-10-13	AFK	ETF	13.92	13.92	13.78	13.85	3200.0
2023-10-13	AFLG	ETF	24.904	24.904	24.904	24.904	100.0
2023-10-13	AFMC	ETF	23.308	23.308	23.308	23.308	100.0
2023-10-13	AFSM	ETF	23.39	23.4	23.303	23.303	1000.0
2023-10-13	AFTY	ETF	14.392	14.392	14.392	14.392	100.0
2023-10-13	AGG	ETF	93.68	93.79	93.52	93.64	7515500.0
2023-10-13	AGGH	ETF	21.35	21.35	21.25	21.317	104791.0
2023-10-13	AGGY	ETF	41.45	41.47	41.38	41.419	56900.0
2023-10-13	AGNG	ETF	25.747	25.79	25.696	25.79	2600.0
2023-10-13	AGOV	ETF	72.6	73.495	72.6	73.495	397.0
2023-10-13	AGOX	ETF	23.0	23.0	22.525	22.566	22500.0
2023-10-13	AGQ	ETF	24.83	25.82	24.77	25.52	1832800.0
2023-10-13	AGRH	ETF	25.56	25.65	25.5	25.57	9176.0
2023-10-13	AGZ	ETF	105.68	105.71	105.6	105.6	12400.0
2023-10-13	AGZD	ETF	22.17	22.22	22.11	22.12	44900.0
2023-10-13	AHLT	ETF	26.5	26.5	26.4428	26.4428	2681.0
2023-10-13	AHYB	ETF	42.969	42.969	42.885	42.885	700.0
2023-10-13	AIA	ETF	56.27	56.62	55.95	56.1	14400.0

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

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