PREVIEW / etf_daily / 2024-04-23

all etf daily files

  file:    by_date/etf_daily/2024/2024-04-23.parquet
  size:    119 KB
  rows:    3,311

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
2024-04-23	SPY	ETF	501.78	506.09	499.53	505.65	64633600.0
2024-04-23	QQQ	ETF	420.77	426.28	418.8715	425.07	44384741.0
2024-04-23	IWM	ETF	195.26	199.32	195.13	198.57	31838300.0
2024-04-23	DIA	ETF	383.69	385.59	382.91	385.02	3126400.0
2024-04-23	GLD	ETF	213.96	215.86	213.87	215.04	10730300.0
2024-04-23	TLT	ETF	88.73	89.54	88.55	89.03	27222700.0
2024-04-23	AAA	ETF	25.23	25.23	25.11	25.13	7600.0
2024-04-23	AAAU	ETF	22.89	23.08	22.87	23.0	3427800.0
2024-04-23	AADR	ETF	61.03	61.09	61.03	61.09	200.0
2024-04-23	AAPB	ETF	16.115	16.45	16.06	16.45	505973.0
2024-04-23	AAPD	ETF	23.56	23.59	23.31	23.31	88047.0
2024-04-23	AAPR	ETF	24.42	24.48	24.33	24.4	77371.0
2024-04-23	AAPU	ETF	20.8	21.2357	20.71	21.19	360019.0
2024-04-23	AAPX	ETF	18.88	19.15	18.84	19.14	7646.0
2024-04-23	AAPY	ETF	23.15	23.23	23.1401	23.1761	525.0
2024-04-23	AAXJ	ETF	66.57	66.97	66.41	66.97	393200.0
2024-04-23	ABCS	ETF	25.84	26.0141	25.73	26.0141	1737.0
2024-04-23	ABEQ	ETF	29.775	29.87	29.76	29.766	1000.0
2024-04-23	ACES	ETF	26.15	26.99	26.07	26.72	23600.0
2024-04-23	ACIO	ETF	34.983	35.25	34.983	35.17	70800.0
2024-04-23	ACSI	ETF	50.704	50.704	50.704	50.704	100.0
2024-04-23	ACT	ETF	29.91	30.03	29.84	30.0	251500.0
2024-04-23	ACTV	ETF	32.63	33.105	32.63	32.964	5100.0
2024-04-23	ACVF	ETF	38.46	38.73	38.46	38.73	22000.0
2024-04-23	ACWF	ETF	39.969	40.21	39.969	40.19	2898.0
2024-04-23	ACWI	ETF	105.94	106.9	105.9	106.78	2936800.0
2024-04-23	ACWV	ETF	102.77	103.12	102.75	102.89	362800.0
2024-04-23	ACWX	ETF	51.85	52.31	51.83	52.26	1019300.0
2024-04-23	ADFI	ETF	8.37	8.39	8.35	8.375	24500.0
2024-04-23	ADIV	ETF	13.81	13.81	13.81	13.81	100.0
2024-04-23	ADME	ETF	40.72	40.72	40.652	40.652	3000.0
2024-04-23	ADPV	ETF	28.3999	28.54	28.3999	28.4952	12687.0
2024-04-23	AEMB	ETF	38.142	38.142	38.142	38.142	100.0
2024-04-23	AESR	ETF	14.864	14.93	14.86	14.901	17000.0
2024-04-23	AETH	ETF	42.18	43.33	42.18	42.5737	2415.0
2024-04-23	AFIF	ETF	9.04	9.07	9.03	9.06	47700.0
2024-04-23	AFK	ETF	14.73	14.84	14.58	14.7	4000.0
2024-04-23	AFLG	ETF	29.649	29.649	29.649	29.649	100.0
2024-04-23	AFMC	ETF	28.71	28.733	28.71	28.733	400.0
2024-04-23	AFSM	ETF	28.05	28.05	27.979	28.047	2000.0
2024-04-23	AFTY	ETF	14.06	14.065	14.06	14.065	100.0
2024-04-23	AGG	ETF	95.38	95.84	95.3	95.64	10837100.0
2024-04-23	AGGH	ETF	20.75	20.8284	20.69	20.7353	16274.0
2024-04-23	AGGY	ETF	42.35	42.539	42.325	42.45	90600.0
2024-04-23	AGNG	ETF	28.71	29.15	28.71	28.95	5200.0
2024-04-23	AGOX	ETF	24.47	24.69	24.47	24.66	26500.0
2024-04-23	AGQ	ETF	33.37	34.36	33.3	34.23	1322100.0
2024-04-23	AGQI	ETF	13.64	13.74	13.64	13.73	18873.0
2024-04-23	AGRH	ETF	25.88	25.88	25.87	25.87	9048.0
2024-04-23	AGZ	ETF	106.67	106.94	106.65	106.85	10900.0

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

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