PREVIEW / etf_daily / 2023-10-31

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-31.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-31	SPY	ETF	416.18	418.53	414.21	418.2	79665200.0
2023-10-31	QQQ	ETF	349.23	351.25	346.62	350.87	47671906.0
2023-10-31	IWM	ETF	163.4	164.99	162.83	164.52	31533200.0
2023-10-31	DIA	ETF	329.18	330.68	327.84	330.48	3645800.0
2023-10-31	GLD	ETF	185.08	186.21	183.5	184.09	10104600.0
2023-10-31	TLT	ETF	84.37	84.77	83.55	83.58	37269200.0
2023-10-31	AAA	ETF	24.93	24.94	24.905	24.905	2200.0
2023-10-31	AAAU	ETF	19.77	19.89	19.61	19.67	1635100.0
2023-10-31	AADR	ETF	47.15	47.17	47.15	47.17	200.0
2023-10-31	AAPB	ETF	22.08	22.55	21.851	22.55	3586.0
2023-10-31	AAPD	ETF	23.05	23.23	22.8377	22.86	122584.0
2023-10-31	AAPU	ETF	23.04	23.34	22.7401	23.33	64768.0
2023-10-31	AAXJ	ETF	61.29	61.43	60.92	61.41	520600.0
2023-10-31	ABEQ	ETF	26.939	26.989	26.93	26.989	3900.0
2023-10-31	ACES	ETF	29.32	29.64	29.25	29.53	215700.0
2023-10-31	ACIO	ETF	29.9	30.14	29.9	30.14	61300.0
2023-10-31	ACSI	ETF	43.977	43.977	43.977	43.977	100.0
2023-10-31	ACT	ETF	27.15	27.6686	27.02	27.56	243262.0
2023-10-31	ACTV	ETF	27.76	27.84	27.69	27.81	10400.0
2023-10-31	ACVF	ETF	31.99	32.17	31.85	32.17	3400.0
2023-10-31	ACWF	ETF	33.37	33.5018	33.311	33.5018	14101.0
2023-10-31	ACWI	ETF	89.77	90.06	89.3	90.02	3220000.0
2023-10-31	ACWV	ETF	93.94	94.11	93.56	94.0	456200.0
2023-10-31	ACWX	ETF	45.46	45.57	45.27	45.54	1755400.0
2023-10-31	ADFI	ETF	8.08	8.09	8.05	8.07	13900.0
2023-10-31	ADIV	ETF	12.9	12.9	12.9	12.9	100.0
2023-10-31	ADME	ETF	34.26	34.42	34.13	34.42	12100.0
2023-10-31	ADPV	ETF	22.58	22.63	22.57	22.6	23723.0
2023-10-31	AEMB	ETF	35.18	35.18	35.18	35.18	100.0
2023-10-31	AESR	ETF	11.72	11.79	11.67	11.78	21500.0
2023-10-31	AETH	ETF	27.28	27.3	27.1	27.2952	2453.0
2023-10-31	AFIF	ETF	8.89	8.9	8.87	8.88	14700.0
2023-10-31	AFK	ETF	13.22	13.52	13.22	13.25	3900.0
2023-10-31	AFLG	ETF	24.24	24.273	24.24	24.273	300.0
2023-10-31	AFMC	ETF	22.59	22.59	22.575	22.575	100.0
2023-10-31	AFSM	ETF	22.67	22.692	22.67	22.692	500.0
2023-10-31	AFTY	ETF	14.12	14.12	14.12	14.12	100.0
2023-10-31	AGG	ETF	92.45	92.63	92.31	92.31	12343600.0
2023-10-31	AGGH	ETF	20.8899	20.8899	20.8362	20.8362	59900.0
2023-10-31	AGGY	ETF	40.83	40.91	40.79	40.79	83600.0
2023-10-31	AGNG	ETF	24.75	24.97	24.729	24.92	4000.0
2023-10-31	AGOV	ETF	72.0	72.0	72.0	72.0	104.0
2023-10-31	AGOX	ETF	22.085	22.22	22.085	22.15	26700.0
2023-10-31	AGQ	ETF	26.32	26.85	25.49	25.84	1327800.0
2023-10-31	AGRH	ETF	25.53	25.53	25.5258	25.5258	310.0
2023-10-31	AGZ	ETF	105.37	105.46	105.37	105.4	25700.0
2023-10-31	AGZD	ETF	22.08	22.1	22.02	22.09	50000.0
2023-10-31	AHLT	ETF	26.76	26.8	26.74	26.7728	4909.0
2023-10-31	AHYB	ETF	42.876	42.88	42.864	42.864	800.0
2023-10-31	AIA	ETF	53.88	54.05	53.52	53.95	24900.0

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

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