PREVIEW / etf_daily / 2023-08-25

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-25.parquet
  size:    108 KB
  rows:    3,011

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-25	SPY	ETF	438.68	441.3	435.0	439.97	102325100.0
2023-08-25	QQQ	ETF	362.07	365.74	358.58	364.02	69960465.0
2023-08-25	IWM	ETF	184.06	185.0	181.61	184.0	29340400.0
2023-08-25	DIA	ETF	342.46	344.55	340.35	343.5	3868500.0
2023-08-25	GLD	ETF	177.58	178.38	176.63	177.62	6132800.0
2023-08-25	TLT	ETF	94.66	95.51	94.51	95.22	23865200.0
2023-08-25	AAA	ETF	24.81	24.861	24.81	24.81	1200.0
2023-08-25	AAAU	ETF	18.96	19.04	18.86	18.97	1929200.0
2023-08-25	AADR	ETF	51.29	51.55	51.29	51.55	400.0
2023-08-25	AAPB	ETF	24.57	25.08	24.3008	24.93	19066.0
2023-08-25	AAPD	ETF	22.03	22.22	21.8233	21.87	78332.0
2023-08-25	AAPU	ETF	25.26	25.56	24.8707	25.47	117541.0
2023-08-25	AAXJ	ETF	64.75	64.87	64.24	64.8	353600.0
2023-08-25	ABEQ	ETF	27.81	27.88	27.81	27.852	8000.0
2023-08-25	ACES	ETF	39.8	40.22	39.4	40.01	366400.0
2023-08-25	ACIO	ETF	30.97	31.089	30.777	31.029	31400.0
2023-08-25	ACSI	ETF	45.479	45.479	45.479	45.479	100.0
2023-08-25	ACT	ETF	28.9	29.0	28.49	28.91	153900.0
2023-08-25	ACTV	ETF	31.3	31.485	31.3	31.41	15900.0
2023-08-25	ACVF	ETF	33.87	33.99	33.7	33.912	3500.0
2023-08-25	ACWF	ETF	34.83	34.96	34.72	34.9218	8382.0
2023-08-25	ACWI	ETF	94.26	94.77	93.49	94.48	2030800.0
2023-08-25	ACWV	ETF	96.79	97.15	96.46	96.99	144700.0
2023-08-25	ACWX	ETF	47.96	48.13	47.55	47.98	1208800.0
2023-08-25	ADFI	ETF	8.35	8.35	8.32	8.345	18400.0
2023-08-25	ADIV	ETF	13.254	13.254	13.254	13.254	100.0
2023-08-25	ADME	ETF	35.995	36.144	35.746	36.079	7900.0
2023-08-25	ADPV	ETF	24.44	24.63	24.43	24.5214	618.0
2023-08-25	AEMB	ETF	36.97	36.995	36.93	36.995	900.0
2023-08-25	AESR	ETF	12.51	12.58	12.46	12.56	46000.0
2023-08-25	AFIF	ETF	8.87	8.9	8.87	8.9	8000.0
2023-08-25	AFK	ETF	14.66	14.96	14.66	14.67	3400.0
2023-08-25	AFMC	ETF	24.456	24.456	24.456	24.456	100.0
2023-08-25	AFSM	ETF	24.409	24.409	24.409	24.409	100.0
2023-08-25	AFTY	ETF	14.79	14.816	14.79	14.816	500.0
2023-08-25	AGG	ETF	95.82	96.08	95.6	95.87	7917900.0
2023-08-25	AGGH	ETF	22.05	22.08	22.0201	22.0772	7811.0
2023-08-25	AGGY	ETF	42.21	42.31	42.14	42.25	89900.0
2023-08-25	AGNG	ETF	26.9	26.991	26.83	26.991	101800.0
2023-08-25	AGOV	ETF	74.98	75.9508	74.35	75.9508	5035.0
2023-08-25	AGOX	ETF	23.14	23.24	22.97	23.11	108700.0
2023-08-25	AGQ	ETF	29.58	30.24	29.05	29.87	902300.0
2023-08-25	AGZ	ETF	106.44	106.44	106.24	106.34	14500.0
2023-08-25	AGZD	ETF	22.17	22.32	22.11	22.17	30000.0
2023-08-25	AHYB	ETF	43.829	43.912	43.829	43.912	600.0
2023-08-25	AIA	ETF	57.22	57.29	56.77	57.22	34900.0
2023-08-25	AIEQ	ETF	30.6	30.661	30.19	30.58	18000.0
2023-08-25	AIQ	ETF	27.34	27.6	27.03	27.52	284800.0
2023-08-25	AIRR	ETF	53.33	53.63	52.734	53.42	30300.0
2023-08-25	AIVI	ETF	37.91	38.09	37.91	38.09	2800.0

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

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