PREVIEW / etf_daily / 2023-08-23

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-23.parquet
  size:    107 KB
  rows:    2,996

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-23	SPY	ETF	439.25	443.67	439.1	443.03	68441000.0
2023-08-23	QQQ	ETF	364.58	370.22	364.36	369.11	51770603.0
2023-08-23	IWM	ETF	184.0	186.11	183.43	185.79	21231100.0
2023-08-23	DIA	ETF	343.53	345.4	343.25	344.83	2605400.0
2023-08-23	GLD	ETF	177.32	178.22	177.07	177.89	7949100.0
2023-08-23	TLT	ETF	94.3	95.55	94.23	95.54	38294700.0
2023-08-23	AAA	ETF	24.86	24.87	24.86	24.86	3100.0
2023-08-23	AAAU	ETF	18.93	19.03	18.92	19.0	1538600.0
2023-08-23	AADR	ETF	50.0	51.42	50.0	51.42	700.0
2023-08-23	AAPB	ETF	25.1301	25.7	25.1301	25.66	25075.0
2023-08-23	AAPD	ETF	21.91	21.92	21.52	21.56	238210.0
2023-08-23	AAPU	ETF	25.45	26.11	25.4464	26.01	215799.0
2023-08-23	AAXJ	ETF	64.54	65.03	64.45	64.92	417000.0
2023-08-23	ABEQ	ETF	27.84	27.92	27.815	27.92	9400.0
2023-08-23	ACES	ETF	39.86	40.577	39.568	40.39	70100.0
2023-08-23	ACIO	ETF	31.02	31.178	31.0	31.14	88800.0
2023-08-23	ACSI	ETF	45.766	45.766	45.766	45.766	100.0
2023-08-23	ACT	ETF	28.48	28.89	28.445	28.85	109041.0
2023-08-23	ACTV	ETF	31.36	31.53	31.36	31.454	5400.0
2023-08-23	ACVF	ETF	33.72	34.16	33.72	34.062	10600.0
2023-08-23	ACWF	ETF	34.92	35.2	34.92	35.1379	1997.0
2023-08-23	ACWI	ETF	94.35	95.26	94.31	95.12	3203100.0
2023-08-23	ACWV	ETF	97.07	97.31	96.96	97.21	128700.0
2023-08-23	ACWX	ETF	47.82	48.33	47.82	48.25	597200.0
2023-08-23	ADFI	ETF	8.35	8.36	8.33	8.355	4700.0
2023-08-23	ADIV	ETF	13.325	13.35	13.32	13.32	500.0
2023-08-23	ADME	ETF	35.88	36.275	35.88	36.247	4100.0
2023-08-23	ADPV	ETF	24.2898	24.673	24.2898	24.673	454.0
2023-08-23	AEMB	ETF	37.12	37.2	37.12	37.14	2800.0
2023-08-23	AESR	ETF	12.651	12.73	12.64	12.681	8500.0
2023-08-23	AFIF	ETF	8.89	8.91	8.86	8.88	8900.0
2023-08-23	AFK	ETF	14.64	14.82	14.59	14.68	4800.0
2023-08-23	AFMC	ETF	24.7	24.7	24.668	24.68	600.0
2023-08-23	AFSM	ETF	24.663	24.663	24.663	24.663	100.0
2023-08-23	AFTY	ETF	14.695	14.695	14.695	14.695	100.0
2023-08-23	AGG	ETF	95.75	96.15	95.73	96.15	7831600.0
2023-08-23	AGGH	ETF	22.11	22.15	22.09	22.1432	16205.0
2023-08-23	AGGY	ETF	42.29	42.47	42.29	42.47	1743500.0
2023-08-23	AGNG	ETF	27.18	27.18	27.082	27.105	2300.0
2023-08-23	AGOV	ETF	74.75	75.76	74.395	75.76	5360.0
2023-08-23	AGOX	ETF	23.06	23.35	23.06	23.28	15800.0
2023-08-23	AGQ	ETF	29.38	30.12	29.34	29.97	903900.0
2023-08-23	AGRH	ETF	25.72	25.72	25.72	25.72	100.0
2023-08-23	AGZ	ETF	106.38	106.54	106.38	106.49	10300.0
2023-08-23	AGZD	ETF	22.16	22.31	22.16	22.19	29200.0
2023-08-23	AHYB	ETF	43.88	43.98	43.88	43.978	800.0
2023-08-23	AIA	ETF	56.78	57.37	56.78	57.33	32800.0
2023-08-23	AIEQ	ETF	30.53	30.83	30.445	30.756	19700.0
2023-08-23	AIQ	ETF	27.35	27.85	27.3	27.77	306100.0
2023-08-23	AIRR	ETF	53.34	54.07	53.125	53.9	72800.0

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

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