PREVIEW / etf_daily / 2023-10-20

all etf daily files

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

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-20	SPY	ETF	425.98	426.54	421.08	421.19	123845800.0
2023-10-20	QQQ	ETF	359.46	360.04	354.37	354.6	72559723.0
2023-10-20	IWM	ETF	168.66	169.03	166.43	166.44	54405700.0
2023-10-20	DIA	ETF	333.38	334.23	331.13	331.19	3959000.0
2023-10-20	GLD	ETF	183.43	185.23	183.09	183.59	12782800.0
2023-10-20	TLT	ETF	82.99	83.54	82.77	83.24	52162600.0
2023-10-20	AAA	ETF	24.883	25.17	24.8	24.857	14900.0
2023-10-20	AAAU	ETF	19.6	19.79	19.56	19.61	2151100.0
2023-10-20	AADR	ETF	47.51	47.61	47.51	47.61	300.0
2023-10-20	AAPB	ETF	23.6	23.6	23.1	23.1	15462.0
2023-10-20	AAPD	ETF	22.22	22.58	22.22	22.54	167709.0
2023-10-20	AAPU	ETF	24.2126	24.312	23.75	23.81	82917.0
2023-10-20	AAXJ	ETF	61.96	62.16	61.69	61.7	579600.0
2023-10-20	ABEQ	ETF	27.27	27.27	27.15	27.16	8700.0
2023-10-20	ACES	ETF	30.96	31.307	30.55	30.58	85900.0
2023-10-20	ACIO	ETF	30.46	30.51	30.23	30.26	113500.0
2023-10-20	ACSI	ETF	43.719	43.719	43.719	43.719	100.0
2023-10-20	ACT	ETF	27.28	27.395	27.06	27.16	145324.0
2023-10-20	ACTV	ETF	28.47	28.48	28.229	28.229	2300.0
2023-10-20	ACVF	ETF	32.66	32.66	32.337	32.337	4000.0
2023-10-20	ACWF	ETF	33.755	33.78	33.6689	33.6689	1950.0
2023-10-20	ACWI	ETF	91.28	91.39	90.39	90.4	3277000.0
2023-10-20	ACWV	ETF	94.46	94.58	93.82	93.82	228200.0
2023-10-20	ACWX	ETF	45.7	45.83	45.45	45.48	1734600.0
2023-10-20	ADFI	ETF	8.04	8.06	8.04	8.06	12700.0
2023-10-20	ADIV	ETF	12.775	12.775	12.775	12.775	100.0
2023-10-20	ADME	ETF	35.13	35.13	34.78	34.788	24600.0
2023-10-20	ADPV	ETF	22.7839	23.0985	22.7839	22.9511	4950.0
2023-10-20	AEMB	ETF	34.67	34.745	34.67	34.745	100.0
2023-10-20	AESR	ETF	12.14	12.14	11.98	11.98	26100.0
2023-10-20	AETH	ETF	24.03	24.045	24.02	24.0357	753.0
2023-10-20	AFIF	ETF	8.85	8.89	8.85	8.87	30200.0
2023-10-20	AFK	ETF	14.07	14.07	13.8	13.91	2600.0
2023-10-20	AFSM	ETF	22.776	22.776	22.776	22.776	100.0
2023-10-20	AFTY	ETF	13.72	13.72	13.711	13.711	100.0
2023-10-20	AGG	ETF	91.94	92.14	91.9	92.0	6629800.0
2023-10-20	AGGH	ETF	20.98	20.98	20.82	20.95	93470.0
2023-10-20	AGGY	ETF	40.71	40.82	40.71	40.81	133600.0
2023-10-20	AGNG	ETF	25.39	25.43	25.26	25.26	1000.0
2023-10-20	AGOV	ETF	72.02	72.02	72.02	72.02	4.0
2023-10-20	AGOX	ETF	22.47	22.47	22.265	22.318	35800.0
2023-10-20	AGQ	ETF	26.43	27.84	26.4	27.03	1487300.0
2023-10-20	AGRH	ETF	25.51	25.51	25.4787	25.4787	193.0
2023-10-20	AGZ	ETF	105.03	105.2	105.03	105.18	14800.0
2023-10-20	AGZD	ETF	22.09	22.17	22.05	22.11	128400.0
2023-10-20	AHLT	ETF	27.0199	27.0699	27.0199	27.0248	3859.0
2023-10-20	AHYB	ETF	42.46	42.46	42.434	42.434	400.0
2023-10-20	AIA	ETF	54.74	54.92	54.35	54.35	22200.0
2023-10-20	AIEQ	ETF	29.1	29.12	28.761	28.834	9500.0
2023-10-20	AIQ	ETF	26.7	26.73	26.26	26.28	268200.0

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

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