PREVIEW / etf_daily / 2023-07-26

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-26.parquet
  size:    107 KB
  rows:    2,981

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-07-26	SPY	ETF	454.47	456.99	453.38	455.51	71052900.0
2023-07-26	QQQ	ETF	377.72	379.24	375.18	377.52	47075710.0
2023-07-26	IWM	ETF	194.77	197.16	194.71	196.46	20377900.0
2023-07-26	DIA	ETF	353.14	356.28	353.12	355.25	3084700.0
2023-07-26	GLD	ETF	182.66	183.64	182.31	183.3	6158400.0
2023-07-26	TLT	ETF	101.68	101.69	100.93	101.27	19310700.0
2023-07-26	AAA	ETF	24.74	24.74	24.74	24.74	100.0
2023-07-26	AAAU	ETF	19.5	19.61	19.47	19.57	1183100.0
2023-07-26	AADR	ETF	51.87	52.11	51.87	52.11	800.0
2023-07-26	AAPB	ETF	29.05	29.31	28.96	29.26	6852.0
2023-07-26	AAPD	ETF	20.13	20.19	19.971	20.09	68209.0
2023-07-26	AAPU	ETF	28.93	29.35	28.87	29.14	82845.0
2023-07-26	AAXJ	ETF	68.54	69.54	68.54	69.34	503300.0
2023-07-26	ABEQ	ETF	28.665	28.675	28.63	28.662	1300.0
2023-07-26	ACES	ETF	47.28	48.18	47.17	48.09	7400.0
2023-07-26	ACIO	ETF	31.63	31.69	31.58	31.66	66600.0
2023-07-26	ACSI	ETF	47.967	47.967	47.967	47.967	100.0
2023-07-26	ACT	ETF	27.21	27.85	27.21	27.59	403387.0
2023-07-26	ACTV	ETF	33.18	33.215	33.0	33.215	11100.0
2023-07-26	ACVF	ETF	34.84	34.84	34.62	34.713	11300.0
2023-07-26	ACWF	ETF	36.26	36.52	36.26	36.42	3204.0
2023-07-26	ACWI	ETF	98.3	99.06	98.3	98.79	3511300.0
2023-07-26	ACWV	ETF	99.85	100.69	99.82	100.13	115000.0
2023-07-26	ACWX	ETF	50.39	50.96	50.39	50.81	883600.0
2023-07-26	ADFI	ETF	8.455	8.48	8.455	8.46	22400.0
2023-07-26	ADIV	ETF	14.02	14.02	14.02	14.02	100.0
2023-07-26	ADME	ETF	37.13	37.16	37.0	37.16	54300.0
2023-07-26	ADPV	ETF	25.61	25.75	25.61	25.7008	10460.0
2023-07-26	AEMB	ETF	37.98	37.98	37.895	37.905	600.0
2023-07-26	AESR	ETF	13.0	13.11	13.0	13.07	40600.0
2023-07-26	AFIF	ETF	8.81	8.88	8.81	8.86	17000.0
2023-07-26	AFK	ETF	15.82	15.82	15.6	15.72	5800.0
2023-07-26	AFLG	ETF	25.99	26.034	25.98	26.034	1700.0
2023-07-26	AFMC	ETF	25.583	25.635	25.583	25.635	1500.0
2023-07-26	AFTY	ETF	15.62	15.676	15.62	15.676	2200.0
2023-07-26	AGG	ETF	97.93	98.07	97.68	98.02	5907400.0
2023-07-26	AGGH	ETF	22.45	22.45	22.3755	22.4	15246.0
2023-07-26	AGGY	ETF	43.04	43.11	42.97	43.08	58500.0
2023-07-26	AGNG	ETF	27.78	27.97	27.76	27.958	6700.0
2023-07-26	AGOV	ETF	76.01	77.815	75.71	77.815	7220.0
2023-07-26	AGOX	ETF	24.012	24.05	23.88	23.94	58800.0
2023-07-26	AGQ	ETF	31.22	32.35	31.0	32.14	917300.0
2023-07-26	AGRH	ETF	25.75	25.76	25.72	25.72	1512.0
2023-07-26	AGZ	ETF	106.86	107.02	106.72	107.0	23900.0
2023-07-26	AGZD	ETF	22.15	22.165	22.1	22.16	49800.0
2023-07-26	AHYB	ETF	44.218	44.35	44.2	44.35	1000.0
2023-07-26	AIA	ETF	61.11	62.07	61.11	61.94	46200.0
2023-07-26	AIEQ	ETF	32.6	32.89	32.6	32.84	10200.0
2023-07-26	AIQ	ETF	28.83	29.01	28.64	28.9	290600.0
2023-07-26	AIRR	ETF	54.31	54.72	54.155	54.4	113300.0

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

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