PREVIEW / etf_daily / 2024-01-23

all etf daily files

  file:    by_date/etf_daily/2024/2024-01-23.parquet
  size:    116 KB
  rows:    3,233

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-23	SPY	ETF	484.01	485.11	482.89	484.86	49945300.0
2024-01-23	QQQ	ETF	422.43	423.7	420.57	423.48	33003806.0
2024-01-23	IWM	ETF	198.22	198.59	194.98	195.97	42471200.0
2024-01-23	DIA	ETF	379.36	379.85	377.98	379.04	3110100.0
2024-01-23	GLD	ETF	187.45	188.15	187.28	187.95	5040800.0
2024-01-23	TLT	ETF	93.89	93.99	93.43	93.9	35786700.0
2024-01-23	AAA	ETF	25.09	25.11	25.08	25.11	4800.0
2024-01-23	AAAU	ETF	20.04	20.11	20.02	20.08	2131200.0
2024-01-23	AADR	ETF	55.3	55.3	54.43	54.43	400.0
2024-01-23	AAPB	ETF	23.35	23.38	23.15	23.36	36800.0
2024-01-23	AAPD	ETF	19.95	20.05	19.87	19.94	118870.0
2024-01-23	AAPU	ETF	27.76	27.89	27.5133	27.79	91144.0
2024-01-23	AAPX	ETF	27.24	27.369	27.119	27.3292	32848.0
2024-01-23	AAXJ	ETF	62.74	63.2	62.64	63.11	815100.0
2024-01-23	ABCS	ETF	24.99	25.02	24.9465	24.988	5316.0
2024-01-23	ABEQ	ETF	28.544	28.624	28.544	28.624	1100.0
2024-01-23	ACES	ETF	30.65	30.972	30.075	30.47	116700.0
2024-01-23	ACIO	ETF	33.71	33.75	33.655	33.75	32300.0
2024-01-23	ACSI	ETF	49.62	49.747	49.62	49.747	1000.0
2024-01-23	ACT	ETF	28.53	28.54	28.3	28.4	171002.0
2024-01-23	ACTV	ETF	32.79	32.79	32.61	32.766	6200.0
2024-01-23	ACVF	ETF	37.33	37.33	37.13	37.3	2900.0
2024-01-23	ACWF	ETF	38.2258	38.43	38.2258	38.3661	1144.0
2024-01-23	ACWI	ETF	101.82	102.07	101.59	102.04	12402400.0
2024-01-23	ACWV	ETF	100.89	101.36	100.89	101.26	248600.0
2024-01-23	ACWX	ETF	49.48	49.71	49.46	49.67	1688000.0
2024-01-23	ADFI	ETF	8.49	8.54	8.49	8.53	27400.0
2024-01-23	ADIV	ETF	13.51	13.58	13.4	13.58	2200.0
2024-01-23	ADME	ETF	39.094	39.16	39.06	39.15	11600.0
2024-01-23	ADPV	ETF	25.13	25.1801	25.05	25.1228	16721.0
2024-01-23	AEMB	ETF	37.378	37.378	37.378	37.378	100.0
2024-01-23	AESR	ETF	14.2	14.24	14.17	14.22	40400.0
2024-01-23	AETH	ETF	30.04	30.52	29.86	30.1205	21975.0
2024-01-23	AFIF	ETF	9.07	9.09	9.06	9.09	23700.0
2024-01-23	AFK	ETF	13.3	13.69	13.2	13.51	13600.0
2024-01-23	AFLG	ETF	27.87	27.906	27.87	27.906	600.0
2024-01-23	AFMC	ETF	26.9	26.98	26.797	26.797	1600.0
2024-01-23	AFSM	ETF	27.06	27.1	27.051	27.051	400.0
2024-01-23	AFTY	ETF	12.924	12.924	12.924	12.924	100.0
2024-01-23	AGG	ETF	97.99	98.0	97.82	97.96	5642800.0
2024-01-23	AGGH	ETF	21.78	21.78	21.68	21.77	55118.0
2024-01-23	AGGY	ETF	43.55	43.58	43.43	43.54	155600.0
2024-01-23	AGNG	ETF	28.27	28.36	28.198	28.32	17300.0
2024-01-23	AGOX	ETF	24.25	24.34	24.121	24.334	69000.0
2024-01-23	AGQ	ETF	23.71	23.95	23.59	23.92	1435100.0
2024-01-23	AGQI	ETF	13.21	13.28	13.21	13.2794	18273.0
2024-01-23	AGZ	ETF	108.1	108.15	108.02	108.09	12600.0
2024-01-23	AGZD	ETF	21.92	21.95	21.81	21.94	18900.0
2024-01-23	AHLT	ETF	22.09	22.19	22.01	22.01	9690.0
2024-01-23	AHYB	ETF	45.22	45.27	45.22	45.27	800.0

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

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