PREVIEW / etf_daily / 2023-09-06

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-06.parquet
  size:    108 KB
  rows:    3,020

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-09-06	SPY	ETF	448.4	448.51	443.81	446.22	70758500.0
2023-09-06	QQQ	ETF	377.28	377.63	372.7	374.74	42998735.0
2023-09-06	IWM	ETF	187.06	188.09	185.09	186.13	26406200.0
2023-09-06	DIA	ETF	346.45	346.51	343.46	345.0	2748400.0
2023-09-06	GLD	ETF	178.33	179.01	177.7	177.83	6427200.0
2023-09-06	TLT	ETF	94.09	94.11	93.46	93.75	23636300.0
2023-09-06	AAA	ETF	24.73	24.75	24.73	24.75	400.0
2023-09-06	AAAU	ETF	19.05	19.12	18.98	18.99	918100.0
2023-09-06	AADR	ETF	51.6	51.6	51.58	51.58	300.0
2023-09-06	AAPB	ETF	27.25	27.25	25.55	25.88	29243.0
2023-09-06	AAPD	ETF	20.78	21.5299	20.75	21.39	324270.0
2023-09-06	AAPU	ETF	27.59	27.59	25.98	26.29	325406.0
2023-09-06	AAXJ	ETF	65.86	66.24	65.59	65.72	507000.0
2023-09-06	ABEQ	ETF	27.865	27.92	27.84	27.87	10700.0
2023-09-06	ACES	ETF	41.47	41.47	40.43	40.69	303100.0
2023-09-06	ACIO	ETF	31.379	31.418	31.17	31.32	43700.0
2023-09-06	ACSI	ETF	45.839	45.839	45.839	45.839	100.0
2023-09-06	ACT	ETF	27.95	28.09	27.76	28.01	171771.0
2023-09-06	ACTV	ETF	31.54	31.714	31.353	31.499	7700.0
2023-09-06	ACTX	ETF	0.0003	0.0003	0.0003	0.0003	1797.0
2023-09-06	ACVF	ETF	34.41	34.51	34.338	34.49	19000.0
2023-09-06	ACWF	ETF	35.61	35.61	35.43	35.4838	4396.0
2023-09-06	ACWI	ETF	96.07	96.15	95.24	95.65	1371400.0
2023-09-06	ACWV	ETF	96.9	97.04	96.71	96.83	108800.0
2023-09-06	ACWX	ETF	48.42	48.61	48.19	48.33	624000.0
2023-09-06	ADFI	ETF	8.34	8.35	8.33	8.335	8500.0
2023-09-06	ADIV	ETF	13.64	13.64	13.64	13.64	100.0
2023-09-06	ADME	ETF	36.578	36.64	36.32	36.491	15800.0
2023-09-06	ADPV	ETF	25.091	25.1382	25.09	25.09	1320.0
2023-09-06	AEMB	ETF	36.61	36.61	36.585	36.585	400.0
2023-09-06	AESR	ETF	12.83	12.83	12.71	12.78	22700.0
2023-09-06	AFIF	ETF	8.88	8.88	8.81	8.82	12900.0
2023-09-06	AFK	ETF	14.65	14.98	14.65	14.68	4600.0
2023-09-06	AFMC	ETF	24.71	24.74	24.686	24.686	26100.0
2023-09-06	AFSM	ETF	24.754	24.754	24.754	24.754	100.0
2023-09-06	AFTY	ETF	15.12	15.12	15.02	15.077	2600.0
2023-09-06	AGG	ETF	95.63	95.64	95.31	95.43	8379200.0
2023-09-06	AGGH	ETF	21.9	21.94	21.854	21.9181	248407.0
2023-09-06	AGGY	ETF	42.25	42.25	42.14	42.18	114000.0
2023-09-06	AGNG	ETF	26.886	27.01	26.886	27.01	1900.0
2023-09-06	AGOV	ETF	73.845	73.845	73.845	73.845	113.0
2023-09-06	AGOX	ETF	23.53	23.675	23.41	23.58	73100.0
2023-09-06	AGQ	ETF	26.89	27.54	26.72	27.1	853100.0
2023-09-06	AGZ	ETF	106.31	106.33	106.0	106.1	48000.0
2023-09-06	AGZD	ETF	22.19	22.39	22.1	22.19	36100.0
2023-09-06	AHYB	ETF	43.78	43.783	43.76	43.783	500.0
2023-09-06	AIA	ETF	58.32	58.65	58.09	58.21	24300.0
2023-09-06	AIEQ	ETF	31.2	31.2	31.02	31.165	7500.0
2023-09-06	AIQ	ETF	28.7	28.81	28.46	28.64	265700.0
2023-09-06	AIRR	ETF	54.06	54.386	53.677	54.0	55300.0

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

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