PREVIEW / etf_daily / 2023-10-24

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-24.parquet
  size:    110 KB
  rows:    3,071

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-24	SPY	ETF	422.65	424.82	420.74	423.63	78564200.0
2023-10-24	QQQ	ETF	357.51	359.91	355.79	359.13	47082078.0
2023-10-24	IWM	ETF	166.45	167.62	165.41	166.47	32666300.0
2023-10-24	DIA	ETF	331.0	332.7	329.85	331.44	3583900.0
2023-10-24	GLD	ETF	182.07	183.4	181.68	182.95	6594000.0
2023-10-24	TLT	ETF	84.44	85.35	84.09	85.35	46267700.0
2023-10-24	AAA	ETF	24.855	24.855	24.855	24.855	1100.0
2023-10-24	AAAU	ETF	19.44	19.59	19.42	19.54	983300.0
2023-10-24	AADR	ETF	46.37	48.25	46.37	47.88	3800.0
2023-10-24	AAPB	ETF	22.951	23.21	22.87	23.21	9650.0
2023-10-24	AAPD	ETF	22.5	22.7354	22.4601	22.51	124367.0
2023-10-24	AAPU	ETF	23.85	23.9449	23.5	23.91	61632.0
2023-10-24	AAXJ	ETF	62.06	62.73	61.96	62.65	716500.0
2023-10-24	ABEQ	ETF	27.2	27.24	27.2	27.23	3900.0
2023-10-24	ACES	ETF	30.79	31.444	30.79	31.01	34400.0
2023-10-24	ACIO	ETF	30.4	30.4	30.19	30.28	73400.0
2023-10-24	ACSI	ETF	44.055	44.055	44.055	44.055	100.0
2023-10-24	ACT	ETF	27.02	27.27	26.9075	27.08	130861.0
2023-10-24	ACTV	ETF	28.09	28.14	28.03	28.12	2000.0
2023-10-24	ACVF	ETF	32.36	32.53	32.36	32.494	5000.0
2023-10-24	ACWF	ETF	33.73	33.83	33.64	33.8079	9439.0
2023-10-24	ACWI	ETF	90.71	91.2	90.45	90.99	1578300.0
2023-10-24	ACWV	ETF	93.74	94.34	93.74	94.27	130900.0
2023-10-24	ACWX	ETF	45.57	45.86	45.55	45.81	1681900.0
2023-10-24	ADFI	ETF	8.1	8.1	8.08	8.1	6800.0
2023-10-24	ADIV	ETF	13.0	13.0	13.0	13.0	100.0
2023-10-24	ADME	ETF	34.91	34.91	34.67	34.833	36600.0
2023-10-24	ADPV	ETF	23.22	23.22	23.07	23.1391	2602.0
2023-10-24	AEMB	ETF	35.136	35.215	35.136	35.215	200.0
2023-10-24	AESR	ETF	12.06	12.14	12.03	12.14	10200.0
2023-10-24	AETH	ETF	27.59	27.59	26.4801	26.6441	5774.0
2023-10-24	AFIF	ETF	8.84	8.9	8.84	8.86	37000.0
2023-10-24	AFK	ETF	13.96	14.01	13.74	13.97	5000.0
2023-10-24	AFLG	ETF	24.35	24.494	24.35	24.494	500.0
2023-10-24	AFMC	ETF	22.684	22.684	22.684	22.684	100.0
2023-10-24	AFSM	ETF	22.82	22.82	22.82	22.82	100.0
2023-10-24	AFTY	ETF	13.93	13.94	13.93	13.94	400.0
2023-10-24	AGG	ETF	92.43	92.69	92.28	92.69	9165100.0
2023-10-24	AGGH	ETF	21.0	21.08	20.97	20.98	84001.0
2023-10-24	AGGY	ETF	40.96	41.09	40.92	41.085	142400.0
2023-10-24	AGNG	ETF	25.2	25.47	25.2	25.45	4900.0
2023-10-24	AGOV	ETF	72.35	72.5114	72.13	72.5114	457.0
2023-10-24	AGOX	ETF	22.345	22.41	22.22	22.33	24800.0
2023-10-24	AGQ	ETF	25.8	26.22	25.63	26.06	668200.0
2023-10-24	AGRH	ETF	25.56	25.57	25.56	25.57	2134.0
2023-10-24	AGZ	ETF	105.34	105.44	105.24	105.42	10500.0
2023-10-24	AGZD	ETF	22.13	22.21	22.01	22.15	50400.0
2023-10-24	AHLT	ETF	26.67	26.67	26.5168	26.5168	1993.0
2023-10-24	AHYB	ETF	42.73	42.78	42.73	42.78	400.0
2023-10-24	AIA	ETF	54.84	55.59	54.84	55.42	31000.0

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

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