PREVIEW / etf_daily / 2023-06-23

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-23.parquet
  size:    109 KB
  rows:    2,954

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-06-23	SPY	ETF	432.93	435.06	432.47	433.21	92074500.0
2023-06-23	QQQ	ETF	362.21	364.88	360.8227	362.54	48922911.0
2023-06-23	IWM	ETF	180.77	182.41	180.05	180.57	50485400.0
2023-06-23	DIA	ETF	337.12	338.19	336.22	337.16	3720500.0
2023-06-23	GLD	ETF	179.6	179.95	178.09	178.2	5416800.0
2023-06-23	TLT	ETF	103.83	103.95	102.98	103.33	22896800.0
2023-06-23	AAA	ETF	24.66	24.66	24.635	24.635	363.0
2023-06-23	AAAU	ETF	19.18	19.21	19.01	19.02	1119200.0
2023-06-23	AADR	ETF	48.81	48.89	48.77	48.89	1700.0
2023-06-23	AAPB	ETF	27.16	27.6799	27.11	27.4838	13897.0
2023-06-23	AAPD	ETF	20.95	20.9979	20.7273	20.8165	134419.0
2023-06-23	AAPU	ETF	27.31	27.72	27.1802	27.56	76937.0
2023-06-23	AAXJ	ETF	66.13	66.13	65.58	65.8	435600.0
2023-06-23	ABEQ	ETF	28.062	28.1	28.062	28.095	4800.0
2023-06-23	ACES	ETF	43.0	43.05	42.52	42.57	436700.0
2023-06-23	ACIO	ETF	30.75	30.805	30.72	30.72	30600.0
2023-06-23	ACSI	ETF	45.9158	45.9158	45.9158	45.9158	28.0
2023-06-23	ACT	ETF	24.68	24.97	24.57	24.83	488053.0
2023-06-23	ACTV	ETF	30.61	30.66	30.38	30.4117	8794.0
2023-06-23	ACTX	ETF	0.285	0.285	0.285	0.285	500.0
2023-06-23	ACVF	ETF	32.85	33.17	32.85	33.02	16700.0
2023-06-23	ACWF	ETF	34.57	34.5887	34.57	34.5887	224.0
2023-06-23	ACWI	ETF	93.8	94.21	93.76	93.91	1995200.0
2023-06-23	ACWV	ETF	97.32	97.32	96.83	96.88	133800.0
2023-06-23	ACWX	ETF	48.31	48.425	48.23	48.32	2440309.0
2023-06-23	ADFI	ETF	8.43	8.46	8.43	8.445	17800.0
2023-06-23	ADIV	ETF	13.43	13.43	13.4	13.4	400.0
2023-06-23	ADME	ETF	35.79	35.86	35.73	35.73	15300.0
2023-06-23	ADPV	ETF	23.82	23.8266	23.82	23.8266	245.0
2023-06-23	AEMB	ETF	37.7	37.7	37.7	37.7	100.0
2023-06-23	AESR	ETF	12.59	12.635	12.57	12.59	14900.0
2023-06-23	AFIF	ETF	8.76	8.77	8.75	8.7565	5199.0
2023-06-23	AFK	ETF	14.8	14.86	14.53	14.68	16977.0
2023-06-23	AFLG	ETF	24.66	24.7	24.66	24.7	400.0
2023-06-23	AFMC	ETF	24.01	24.02	23.894	23.894	400.0
2023-06-23	AFTY	ETF	14.76	14.76	14.739	14.739	400.0
2023-06-23	AGG	ETF	98.49	98.5	98.1	98.26	4792900.0
2023-06-23	AGGH	ETF	22.77	22.8	22.77	22.8	2385.0
2023-06-23	AGGY	ETF	43.34	43.34	43.208	43.255	69700.0
2023-06-23	AGNG	ETF	27.96	27.96	27.77	27.78	5900.0
2023-06-23	AGOV	ETF	75.245	75.245	75.245	75.245	105.0
2023-06-23	AGOX	ETF	22.925	23.01	22.87	22.87	20300.0
2023-06-23	AGQ	ETF	26.36	26.82	25.87	26.14	704900.0
2023-06-23	AGZ	ETF	107.19	107.38	107.1301	107.237	18502.0
2023-06-23	AGZD	ETF	22.075	22.11	22.065	22.08	29000.0
2023-06-23	AHYB	ETF	43.53	43.53	43.49	43.505	8600.0
2023-06-23	AIA	ETF	59.69	59.69	59.23	59.38	23024.0
2023-06-23	AIEQ	ETF	30.41	30.43	30.18	30.31	20900.0
2023-06-23	AIQ	ETF	27.36	27.5683	27.25	27.43	429987.0
2023-06-23	AIRR	ETF	51.46	51.57	50.88	51.07	50400.0

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

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