PREVIEW / etf_daily / 2023-09-21

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-21.parquet
  size:    109 KB
  rows:    3,048

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-21	SPY	ETF	435.7	435.97	431.23	431.39	103976100.0
2023-09-21	QQQ	ETF	360.8	361.6	357.69	357.86	69734845.0
2023-09-21	IWM	ETF	178.5	178.76	177.07	177.07	31588200.0
2023-09-21	DIA	ETF	343.17	343.65	340.47	340.58	3483700.0
2023-09-21	GLD	ETF	177.86	178.49	177.69	178.05	7571900.0
2023-09-21	TLT	ETF	91.29	91.37	90.69	90.7	59920500.0
2023-09-21	AAA	ETF	24.87	24.9	24.86	24.87	1900.0
2023-09-21	AAAU	ETF	19.0	19.06	18.98	19.03	1235800.0
2023-09-21	AADR	ETF	49.72	49.72	49.35	49.42	2300.0
2023-09-21	AAPB	ETF	23.66	24.07	23.59	23.59	9008.0
2023-09-21	AAPD	ETF	22.22	22.31	22.02	22.29	241865.0
2023-09-21	AAPU	ETF	24.31	24.64	24.155	24.17	140490.0
2023-09-21	AAXJ	ETF	63.51	63.71	63.43	63.43	478700.0
2023-09-21	ABEQ	ETF	28.09	28.09	27.9	27.9	6700.0
2023-09-21	ACES	ETF	38.86	39.03	38.32	38.34	75800.0
2023-09-21	ACIO	ETF	30.89	30.89	30.68	30.72	143600.0
2023-09-21	ACSI	ETF	44.839	44.839	44.839	44.839	100.0
2023-09-21	ACT	ETF	28.02	28.11	27.7	27.72	107858.0
2023-09-21	ACTV	ETF	30.942	31.02	30.8	30.8	10700.0
2023-09-21	ACVF	ETF	33.77	33.77	33.365	33.365	4000.0
2023-09-21	ACWF	ETF	34.86	34.86	34.61	34.634	24933.0
2023-09-21	ACWI	ETF	94.06	94.15	93.25	93.32	2613600.0
2023-09-21	ACWV	ETF	97.58	97.58	96.83	96.84	281600.0
2023-09-21	ACWX	ETF	47.82	47.92	47.51	47.51	991600.0
2023-09-21	ADFI	ETF	8.26	8.29	8.26	8.28	15000.0
2023-09-21	ADIV	ETF	13.327	13.327	13.327	13.327	100.0
2023-09-21	ADME	ETF	35.82	35.899	35.572	35.572	55000.0
2023-09-21	ADPV	ETF	23.8801	24.02	23.8453	23.8453	35878.0
2023-09-21	AEMB	ETF	36.249	36.249	36.249	36.249	100.0
2023-09-21	AESR	ETF	12.3	12.32	12.24	12.24	10300.0
2023-09-21	AFIF	ETF	8.91	8.93	8.9	8.91	11600.0
2023-09-21	AFK	ETF	14.18	14.57	14.07	14.07	6000.0
2023-09-21	AFLG	ETF	24.832	24.832	24.832	24.832	100.0
2023-09-21	AFMC	ETF	23.88	23.88	23.741	23.741	200.0
2023-09-21	AFSM	ETF	23.779	23.779	23.779	23.779	1400.0
2023-09-21	AFTY	ETF	14.589	14.589	14.589	14.589	100.0
2023-09-21	AGG	ETF	94.8	94.81	94.64	94.65	8028900.0
2023-09-21	AGGH	ETF	21.7795	21.785	21.71	21.77	35793.0
2023-09-21	AGGY	ETF	41.95	41.95	41.87	41.89	207800.0
2023-09-21	AGNG	ETF	26.66	26.66	26.343	26.343	1900.0
2023-09-21	AGOV	ETF	72.615	72.615	72.615	72.615	103.0
2023-09-21	AGOX	ETF	22.841	22.87	22.67	22.67	23500.0
2023-09-21	AGQ	ETF	26.49	27.72	26.34	27.53	885200.0
2023-09-21	AGRH	ETF	25.7481	25.75	25.74	25.75	10362.0
2023-09-21	AGZ	ETF	105.82	106.16	105.82	105.91	98300.0
2023-09-21	AGZD	ETF	22.42	22.42	22.23	22.33	89400.0
2023-09-21	AHLT	ETF	26.09	26.09	25.96	25.96	236.0
2023-09-21	AHOY	ETF	19.905	19.92	19.8581	19.8581	1571.0
2023-09-21	AHYB	ETF	43.61	43.61	43.52	43.526	500.0
2023-09-21	AIA	ETF	55.33	55.54	55.18	55.18	70100.0

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

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