PREVIEW / etf_daily / 2023-10-27

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-27.parquet
  size:    111 KB
  rows:    3,091

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-10-27	SPY	ETF	414.19	414.6	409.21	410.68	107367700.0
2023-10-27	QQQ	ETF	346.43	348.84	344.08	345.31	63476707.0
2023-10-27	IWM	ETF	164.52	164.83	161.67	162.21	46017100.0
2023-10-27	DIA	ETF	327.84	327.88	323.21	324.19	4757300.0
2023-10-27	GLD	ETF	183.76	186.36	183.47	186.15	14102800.0
2023-10-27	TLT	ETF	84.19	84.97	83.74	84.37	32362300.0
2023-10-27	AAA	ETF	24.841	24.88	24.841	24.87	900.0
2023-10-27	AAAU	ETF	19.64	19.91	19.6	19.88	1433900.0
2023-10-27	AADR	ETF	47.24	47.24	47.24	47.24	100.0
2023-10-27	AAPB	ETF	21.76	22.095	21.6715	21.98	13706.0
2023-10-27	AAPD	ETF	23.29	23.37	23.0999	23.19	218771.0
2023-10-27	AAPU	ETF	22.55	22.9418	22.54	22.84	52989.0
2023-10-27	AAPY	ETF	25.02	25.05	25.01	25.01	10310.0
2023-10-27	AAXJ	ETF	61.78	61.9	61.19	61.27	630500.0
2023-10-27	ABEQ	ETF	26.718	26.79	26.718	26.79	2500.0
2023-10-27	ACES	ETF	30.4	30.4	29.45	29.51	67000.0
2023-10-27	ACIO	ETF	29.97	29.97	29.67	29.77	130600.0
2023-10-27	ACSI	ETF	42.919	42.919	42.919	42.919	100.0
2023-10-27	ACT	ETF	27.0	27.0	26.675	26.85	117880.0
2023-10-27	ACTV	ETF	27.76	27.76	27.29	27.327	6800.0
2023-10-27	ACVF	ETF	31.85	31.85	31.418	31.56	3700.0
2023-10-27	ACWF	ETF	33.185	33.235	32.86	32.9531	52966.0
2023-10-27	ACWI	ETF	89.42	89.47	88.34	88.59	2660100.0
2023-10-27	ACWV	ETF	93.73	93.93	92.81	93.0	567400.0
2023-10-27	ACWX	ETF	45.44	45.45	44.89	44.98	2334100.0
2023-10-27	ADFI	ETF	8.085	8.09	8.07	8.07	11000.0
2023-10-27	ADIV	ETF	12.815	12.815	12.815	12.815	100.0
2023-10-27	ADME	ETF	34.06	34.07	33.91	33.92	20900.0
2023-10-27	ADPV	ETF	22.36	22.36	22.2077	22.2077	9612.0
2023-10-27	ADVE	ETF	28.68	28.68	28.68	28.68	28745.0
2023-10-27	AESR	ETF	11.67	11.73	11.565	11.61	19400.0
2023-10-27	AETH	ETF	26.92	26.92	26.601	26.75	1177.0
2023-10-27	AFIF	ETF	8.89	8.9	8.85	8.85	37600.0
2023-10-27	AFK	ETF	13.06	13.1	12.96	13.07	14600.0
2023-10-27	AFLG	ETF	23.83	23.835	23.78	23.835	400.0
2023-10-27	AFMC	ETF	22.46	22.46	22.296	22.296	200.0
2023-10-27	AFTY	ETF	13.93	13.93	13.91	13.91	400.0
2023-10-27	AGG	ETF	92.56	92.64	92.37	92.59	7650000.0
2023-10-27	AGGH	ETF	20.8526	20.94	20.83	20.94	54298.0
2023-10-27	AGGY	ETF	40.87	40.92	40.8	40.89	97900.0
2023-10-27	AGNG	ETF	24.84	24.84	24.41	24.49	5800.0
2023-10-27	AGOV	ETF	71.9768	71.9768	71.9768	71.9768	44.0
2023-10-27	AGOX	ETF	21.89	22.1	21.86	21.93	23000.0
2023-10-27	AGQ	ETF	25.77	26.41	25.37	26.36	1176100.0
2023-10-27	AGRH	ETF	25.52	25.5249	25.52	25.5249	253.0
2023-10-27	AGZ	ETF	105.5	105.55	105.43	105.55	18200.0
2023-10-27	AGZD	ETF	22.09	22.14	21.95	22.02	262200.0
2023-10-27	AHLT	ETF	26.79	26.93	26.7297	26.813	2450.0
2023-10-27	AHOY	ETF	18.89	18.89	18.6842	18.6842	762.0
2023-10-27	AHYB	ETF	42.765	42.765	42.652	42.652	400.0

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

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