PREVIEW / etf_daily / 2023-10-30

all etf daily files

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

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-30	SPY	ETF	413.56	416.68	412.22	415.59	86562700.0
2023-10-30	QQQ	ETF	347.83	350.54	346.45	349.2	55298536.0
2023-10-30	IWM	ETF	163.79	164.81	161.94	163.11	35156300.0
2023-10-30	DIA	ETF	326.39	330.02	326.37	329.23	4617200.0
2023-10-30	GLD	ETF	185.54	185.7	184.73	185.1	8756400.0
2023-10-30	TLT	ETF	83.81	84.5	83.24	83.99	45026900.0
2023-10-30	AAA	ETF	24.91	24.92	24.87	24.87	3400.0
2023-10-30	AAAU	ETF	19.83	19.83	19.74	19.77	739300.0
2023-10-30	AADR	ETF	47.53	47.69	47.38	47.47	3700.0
2023-10-30	AAPB	ETF	22.539	22.55	22.19	22.43	3139.0
2023-10-30	AAPD	ETF	23.09	23.09	22.801	22.92	172355.0
2023-10-30	AAPU	ETF	22.98	23.38	22.96	23.23	98600.0
2023-10-30	AAXJ	ETF	62.14	62.33	61.8	62.06	365600.0
2023-10-30	ABEQ	ETF	26.829	26.875	26.78	26.84	495800.0
2023-10-30	ACES	ETF	29.81	29.838	28.865	29.29	170100.0
2023-10-30	ACIO	ETF	29.923	30.06	29.87	30.02	83900.0
2023-10-30	ACSI	ETF	43.627	43.627	43.627	43.627	100.0
2023-10-30	ACT	ETF	26.97	27.3	26.97	27.2	307493.0
2023-10-30	ACTV	ETF	27.64	27.73	27.39	27.626	17000.0
2023-10-30	ACVF	ETF	31.82	31.95	31.66	31.892	5600.0
2023-10-30	ACWF	ETF	33.25	33.39	33.2003	33.3765	24830.0
2023-10-30	ACWI	ETF	89.35	89.81	89.04	89.62	2524900.0
2023-10-30	ACWV	ETF	93.46	93.87	93.36	93.85	397300.0
2023-10-30	ACWX	ETF	45.56	45.62	45.31	45.54	2052200.0
2023-10-30	ADFI	ETF	8.06	8.11	8.06	8.09	38000.0
2023-10-30	ADIV	ETF	12.91	12.975	12.91	12.975	600.0
2023-10-30	ADME	ETF	34.171	34.33	34.065	34.31	29300.0
2023-10-30	ADPV	ETF	22.44	22.68	22.44	22.61	25503.0
2023-10-30	AEMB	ETF	35.18	35.18	35.18	35.18	100.0
2023-10-30	AESR	ETF	11.68	11.77	11.66	11.72	25300.0
2023-10-30	AETH	ETF	27.27	27.4267	27.14	27.1408	2069.0
2023-10-30	AFIF	ETF	8.85	8.89	8.85	8.88	6800.0
2023-10-30	AFK	ETF	13.14	13.5	13.14	13.48	7700.0
2023-10-30	AFMC	ETF	22.36	22.422	22.36	22.422	300.0
2023-10-30	AFSM	ETF	22.58	22.58	22.53	22.56	2800.0
2023-10-30	AFTY	ETF	14.085	14.085	14.085	14.085	100.0
2023-10-30	AGG	ETF	92.29	92.51	92.15	92.37	8166700.0
2023-10-30	AGGH	ETF	21.09	21.09	20.7999	20.8398	110546.0
2023-10-30	AGGY	ETF	40.81	40.87	40.73	40.78	101400.0
2023-10-30	AGNG	ETF	24.69	24.81	24.67	24.76	7200.0
2023-10-30	AGOV	ETF	74.49	74.49	69.9223	72.141	1142.0
2023-10-30	AGOX	ETF	22.19	22.19	21.87	22.005	29100.0
2023-10-30	AGQ	ETF	27.46	27.5	26.54	26.86	1014200.0
2023-10-30	AGRH	ETF	25.505	25.505	25.505	25.505	124.0
2023-10-30	AGZ	ETF	105.32	105.45	105.3	105.41	20700.0
2023-10-30	AGZD	ETF	22.1	22.12	22.02	22.09	48300.0
2023-10-30	AHLT	ETF	26.84	26.84	26.5301	26.5301	1043.0
2023-10-30	AHYB	ETF	42.685	42.72	42.685	42.685	600.0
2023-10-30	AIA	ETF	54.86	54.86	54.35	54.56	19100.0
2023-10-30	AIEQ	ETF	28.3	28.37	28.13	28.29	5800.0

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

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