PREVIEW / etf_daily / 2024-01-04

all etf daily files

  file:    by_date/etf_daily/2024/2024-01-04.parquet
  size:    117 KB
  rows:    3,246

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-01-04	SPY	ETF	468.3	470.96	467.05	467.28	84232200.0
2024-01-04	QQQ	ETF	396.44	399.59	396.06	396.28	39432797.0
2024-01-04	IWM	ETF	194.06	195.49	193.69	193.82	43114200.0
2024-01-04	DIA	ETF	374.84	377.22	374.4	374.54	4251900.0
2024-01-04	GLD	ETF	189.08	189.75	188.69	189.32	4416700.0
2024-01-04	TLT	ETF	97.42	97.64	97.07	97.22	52604500.0
2024-01-04	AAA	ETF	25.035	25.085	24.981	25.035	2900.0
2024-01-04	AAAU	ETF	20.21	20.28	20.17	20.24	1076900.0
2024-01-04	AADR	ETF	55.04	55.04	54.66	54.81	900.0
2024-01-04	AAPB	ETF	20.76	20.95	20.5299	20.74	54651.0
2024-01-04	AAPD	ETF	21.33	21.461	21.22	21.34	495682.0
2024-01-04	AAPU	ETF	25.18	25.3467	24.89	25.1	183348.0
2024-01-04	AAXJ	ETF	65.1	65.22	64.83	64.84	963400.0
2024-01-04	ABCS	ETF	24.9517	24.97	24.7947	24.7947	22264.0
2024-01-04	ABEQ	ETF	28.65	28.67	28.528	28.528	8300.0
2024-01-04	ACES	ETF	34.07	34.07	33.44	33.44	58800.0
2024-01-04	ACIO	ETF	32.861	32.974	32.77	32.79	57200.0
2024-01-04	ACSI	ETF	48.964	48.964	48.964	48.964	100.0
2024-01-04	ACT	ETF	28.59	28.7	28.36	28.5	194748.0
2024-01-04	ACTV	ETF	32.68	32.71	32.601	32.641	9800.0
2024-01-04	ACVF	ETF	36.04	36.23	35.936	35.936	5800.0
2024-01-04	ACWF	ETF	37.4458	37.4458	37.2614	37.2614	4653.0
2024-01-04	ACWI	ETF	99.98	100.62	99.92	99.99	2677000.0
2024-01-04	ACWV	ETF	100.32	100.83	100.31	100.31	111900.0
2024-01-04	ACWX	ETF	50.02	50.39	50.02	50.15	1164400.0
2024-01-04	ADFI	ETF	8.53	8.53	8.47	8.49	25800.0
2024-01-04	ADIV	ETF	13.57	13.59	13.551	13.551	2100.0
2024-01-04	ADME	ETF	38.03	38.14	37.877	37.877	10800.0
2024-01-04	ADPV	ETF	23.81	23.91	23.7506	23.7506	8145.0
2024-01-04	AEMB	ETF	37.56	37.56	37.51	37.51	800.0
2024-01-04	AESR	ETF	13.46	13.52	13.42	13.42	32300.0
2024-01-04	AETH	ETF	31.15	31.64	31.15	31.4654	6382.0
2024-01-04	AFIF	ETF	9.04	9.05	9.04	9.05	15600.0
2024-01-04	AFK	ETF	13.83	14.07	13.83	13.98	9800.0
2024-01-04	AFLG	ETF	26.831	26.831	26.831	26.831	200.0
2024-01-04	AFMC	ETF	26.068	26.068	26.068	26.068	100.0
2024-01-04	AFTY	ETF	13.15	13.15	13.07	13.07	2200.0
2024-01-04	AGG	ETF	98.42	98.55	98.33	98.43	9896600.0
2024-01-04	AGGH	ETF	21.97	21.98	21.8812	21.98	55279.0
2024-01-04	AGGY	ETF	43.62	43.66	43.57	43.62	112400.0
2024-01-04	AGIH	ETF	24.44	24.44	24.44	24.44	100.0
2024-01-04	AGNG	ETF	28.6	28.62	28.45	28.495	1600.0
2024-01-04	AGOX	ETF	24.19	24.27	24.06	24.081	65700.0
2024-01-04	AGQ	ETF	24.98	25.38	24.61	25.34	1630600.0
2024-01-04	AGQI	ETF	13.16	13.22	13.15	13.15	56756.0
2024-01-04	AGRH	ETF	25.71	25.74	25.71	25.715	770.0
2024-01-04	AGZ	ETF	108.4	108.4	108.05	108.05	24400.0
2024-01-04	AGZD	ETF	21.86	21.89	21.8	21.86	35500.0
2024-01-04	AHLT	ETF	21.75	21.8	21.7	21.7157	2043.0
2024-01-04	AHYB	ETF	45.04	45.14	44.916	44.916	7200.0

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

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