PREVIEW / etf_daily / 2023-04-26

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-26.parquet
  size:    109 KB
  rows:    2,950

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-04-26	SPY	ETF	406.72	407.84	403.78	404.36	80447000.0
2023-04-26	QQQ	ETF	313.44	314.935	311.34	311.87	55400496.0
2023-04-26	IWM	ETF	172.23	173.4	171.0	171.39	30309800.0
2023-04-26	DIA	ETF	335.6	336.46	332.31	332.95	3588400.0
2023-04-26	GLD	ETF	186.63	186.65	184.3	184.74	8203600.0
2023-04-26	TLT	ETF	106.79	107.24	105.67	105.82	19610400.0
2023-04-26	AAA	ETF	24.65	24.65	24.58	24.615	1602.0
2023-04-26	AAAU	ETF	19.92	19.92	19.68	19.72	1368400.0
2023-04-26	AADR	ETF	47.33	47.65	47.3	47.3	1000.0
2023-04-26	AAPB	ETF	22.2197	22.44	22.16	22.25	2673.0
2023-04-26	AAPD	ETF	23.99	23.99	23.665	23.89	123845.0
2023-04-26	AAPU	ETF	22.84	23.27	22.84	22.94	53354.0
2023-04-26	AAXJ	ETF	65.83	66.06	65.49	65.53	348000.0
2023-04-26	ABEQ	ETF	28.45	28.45	28.28	28.33	13700.0
2023-04-26	ACES	ETF	42.3	42.3	41.23	41.41	135800.0
2023-04-26	ACIO	ETF	29.991	30.01	29.86	29.91	37500.0
2023-04-26	ACSI	ETF	43.1754	43.1754	43.1754	43.1754	67.0
2023-04-26	ACT	ETF	23.84	24.09	23.56	23.62	134705.0
2023-04-26	ACTV	ETF	28.94	29.03	28.8656	28.8656	4162.0
2023-04-26	ACVF	ETF	31.22	31.22	30.821	30.821	3300.0
2023-04-26	ACWF	ETF	33.56	33.62	33.39	33.3986	4240.0
2023-04-26	ACWI	ETF	91.12	91.19	90.4	90.5	8732000.0
2023-04-26	ACWV	ETF	98.68	98.72	98.04	98.13	106900.0
2023-04-26	ACWX	ETF	49.28	49.32	48.95	48.99	959358.0
2023-04-26	ADFI	ETF	8.53	8.54	8.51	8.515	21800.0
2023-04-26	ADIV	ETF	13.41	13.41	13.379	13.379	100.0
2023-04-26	ADME	ETF	34.58	34.58	34.31	34.376	227400.0
2023-04-26	ADPV	ETF	22.54	22.54	22.31	22.3529	730.0
2023-04-26	AEMB	ETF	37.705	37.705	37.705	37.705	100.0
2023-04-26	AESR	ETF	11.96	11.99	11.9	11.92	43400.0
2023-04-26	AFIF	ETF	8.85	8.85	8.81	8.8164	78738.0
2023-04-26	AFK	ETF	15.65	15.785	15.6149	15.6149	4031.0
2023-04-26	AFLG	ETF	23.8	23.8	23.59	23.594	13900.0
2023-04-26	AFMC	ETF	22.61	22.61	22.46	22.46	500.0
2023-04-26	AFSM	ETF	22.4	22.428	22.4	22.428	200.0
2023-04-26	AFTY	ETF	15.776	15.776	15.776	15.776	100.0
2023-04-26	AGG	ETF	100.16	100.22	99.72	99.81	3723600.0
2023-04-26	AGGH	ETF	22.8701	22.97	22.87	22.9641	527.0
2023-04-26	AGGY	ETF	43.94	43.94	43.758	43.8	94400.0
2023-04-26	AGNG	ETF	27.96	27.96	27.82	27.93	1900.0
2023-04-26	AGOV	ETF	77.85	79.3	76.625	76.8	1550.0
2023-04-26	AGOX	ETF	21.33	21.41	21.19	21.265	8300.0
2023-04-26	AGQ	ETF	33.87	33.87	32.69	33.05	597000.0
2023-04-26	AGZ	ETF	108.85	108.85	108.48	108.58	46009.0
2023-04-26	AGZD	ETF	21.595	21.845	21.595	21.725	109400.0
2023-04-26	AHYB	ETF	43.91	43.91	43.84	43.84	600.0
2023-04-26	AIA	ETF	58.11	58.11	57.5401	57.69	79743.0
2023-04-26	AIEQ	ETF	27.27	27.27	26.86	26.86	19500.0
2023-04-26	AIQ	ETF	23.25	23.35	22.94	23.11	87116.0
2023-04-26	AIRR	ETF	44.67	44.67	44.068	44.19	37200.0

> showing 50 of 2,950 rows — these rows as CSV

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