PREVIEW / etf_daily / 2023-08-16

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-16.parquet
  size:    108 KB
  rows:    2,985

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-08-16	SPY	ETF	442.46	444.18	439.53	439.64	80107200.0
2023-08-16	QQQ	ETF	365.87	367.43	362.44	362.54	53190525.0
2023-08-16	IWM	ETF	187.99	189.06	185.81	185.84	27018400.0
2023-08-16	DIA	ETF	349.3	351.52	347.71	347.77	3586800.0
2023-08-16	GLD	ETF	176.62	176.95	175.56	175.57	6559400.0
2023-08-16	TLT	ETF	94.28	94.79	93.72	93.84	23076700.0
2023-08-16	AAA	ETF	24.77	24.821	24.678	24.8	3800.0
2023-08-16	AAAU	ETF	18.86	18.9	18.75	18.75	1064900.0
2023-08-16	AADR	ETF	51.03	51.18	50.6	50.69	800.0
2023-08-16	AAPB	ETF	24.9	25.0	24.541	24.59	6223.0
2023-08-16	AAPD	ETF	22.01	22.11	21.88	22.11	264415.0
2023-08-16	AAPU	ETF	25.16	25.4797	25.0711	25.08	122842.0
2023-08-16	AAXJ	ETF	64.62	64.93	64.46	64.5	808600.0
2023-08-16	ABEQ	ETF	27.9	27.915	27.73	27.84	44500.0
2023-08-16	ACES	ETF	41.25	41.36	40.75	40.76	36300.0
2023-08-16	ACIO	ETF	31.23	31.26	30.99	30.99	93600.0
2023-08-16	ACSI	ETF	46.127	46.127	46.127	46.127	100.0
2023-08-16	ACT	ETF	29.19	29.34	28.45	28.48	127532.0
2023-08-16	ACTV	ETF	31.5	31.828	31.5	31.559	9000.0
2023-08-16	ACVF	ETF	34.16	34.169	33.854	33.854	12600.0
2023-08-16	ACWF	ETF	35.16	35.19	34.9	34.9	1843.0
2023-08-16	ACWI	ETF	94.89	95.27	94.37	94.39	1946600.0
2023-08-16	ACWV	ETF	97.4	97.85	97.19	97.19	178300.0
2023-08-16	ACWX	ETF	48.1	48.32	47.92	47.92	2311900.0
2023-08-16	ADFI	ETF	8.33	8.33	8.295	8.295	34300.0
2023-08-16	ADIV	ETF	13.371	13.4	13.359	13.359	400.0
2023-08-16	ADME	ETF	36.4	36.4	36.07	36.07	48000.0
2023-08-16	ADPV	ETF	24.9301	24.9999	24.57	24.5853	2890.0
2023-08-16	AEMB	ETF	36.95	36.95	36.78	36.78	700.0
2023-08-16	AESR	ETF	12.69	12.71	12.612	12.612	39300.0
2023-08-16	AFIF	ETF	8.86	8.9	8.85	8.85	53500.0
2023-08-16	AFK	ETF	14.7	14.7	14.35	14.54	28200.0
2023-08-16	AFLG	ETF	25.4	25.4	25.243	25.243	200.0
2023-08-16	AFMC	ETF	25.045	25.045	24.797	24.797	300.0
2023-08-16	AFSM	ETF	25.04	25.195	24.817	24.817	1700.0
2023-08-16	AFTY	ETF	14.84	14.84	14.826	14.826	300.0
2023-08-16	AGG	ETF	95.76	95.93	95.45	95.51	8964600.0
2023-08-16	AGGH	ETF	22.06	22.07	21.91	21.91	4828.0
2023-08-16	AGGY	ETF	42.31	42.387	42.19	42.21	83200.0
2023-08-16	AGNG	ETF	27.38	27.47	27.211	27.211	3900.0
2023-08-16	AGOV	ETF	74.28	74.9	73.81	74.55	6500.0
2023-08-16	AGOX	ETF	23.24	23.4	23.13	23.13	10900.0
2023-08-16	AGQ	ETF	26.07	26.28	25.54	25.56	445600.0
2023-08-16	AGZ	ETF	106.4	106.4	106.08	106.12	31600.0
2023-08-16	AGZD	ETF	22.13	22.21	22.13	22.16	18400.0
2023-08-16	AHYB	ETF	43.914	43.914	43.754	43.754	500.0
2023-08-16	AIA	ETF	56.94	57.17	56.66	56.68	15300.0
2023-08-16	AIEQ	ETF	31.24	31.29	31.0	31.057	12900.0
2023-08-16	AIQ	ETF	27.44	27.52	27.161	27.17	250500.0
2023-08-16	AIRR	ETF	54.29	54.673	53.57	53.61	37800.0

> showing 50 of 2,985 rows — these rows as CSV

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