PREVIEW / etf_daily / 2023-05-25

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-25.parquet
  size:    110 KB
  rows:    2,964

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-05-25	SPY	ETF	414.74	416.16	412.41	414.65	90961600.0
2023-05-25	QQQ	ETF	339.14	341.01	336.665	339.72	66862773.0
2023-05-25	IWM	ETF	175.25	175.53	172.7	174.17	36202600.0
2023-05-25	DIA	ETF	328.07	328.73	325.82	327.75	3499900.0
2023-05-25	GLD	ETF	181.18	181.31	180.1	180.2	6919200.0
2023-05-25	TLT	ETF	100.7	100.8	100.03	100.28	22492800.0
2023-05-25	AAA	ETF	24.5855	24.5855	24.565	24.565	515.0
2023-05-25	AAAU	ETF	19.33	19.36	19.22	19.24	1332500.0
2023-05-25	AADR	ETF	46.5	46.5	46.5	46.5	100.0
2023-05-25	AAPB	ETF	24.075	24.4	24.075	24.2734	7925.0
2023-05-25	AAPD	ETF	22.65	22.76	22.51	22.6157	102334.0
2023-05-25	AAPU	ETF	24.72	25.0	24.57	24.84	152035.0
2023-05-25	AAXJ	ETF	65.09	65.16	64.79	64.91	1274900.0
2023-05-25	ABEQ	ETF	27.79	27.83	27.716	27.769	4900.0
2023-05-25	ACES	ETF	43.01	43.01	42.21	42.62	64900.0
2023-05-25	ACIO	ETF	30.13	30.13	29.861	29.95	36400.0
2023-05-25	ACSI	ETF	43.562	43.562	43.562	43.562	31.0
2023-05-25	ACT	ETF	24.26	24.4	24.02	24.23	132700.0
2023-05-25	ACTV	ETF	29.53	29.53	29.15	29.288	6976.0
2023-05-25	ACTX	ETF	0.06	0.06	0.06	0.06	333.0
2023-05-25	ACVF	ETF	31.425	31.59	31.425	31.529	26900.0
2023-05-25	ACWF	ETF	33.76	33.81	33.65	33.7715	5541.0
2023-05-25	ACWI	ETF	91.59	91.72	91.07	91.46	1838200.0
2023-05-25	ACWV	ETF	97.31	97.51	96.53	96.86	107200.0
2023-05-25	ACWX	ETF	48.37	48.38	48.1	48.26	1016415.0
2023-05-25	ADFI	ETF	8.36	8.38	8.35	8.365	5300.0
2023-05-25	ADIV	ETF	13.24	13.26	13.22	13.26	3700.0
2023-05-25	ADME	ETF	34.58	34.72	34.48	34.6	9600.0
2023-05-25	ADPV	ETF	22.69	22.69	22.6538	22.6538	961.0
2023-05-25	AEMB	ETF	36.871	36.871	36.871	36.871	100.0
2023-05-25	AESR	ETF	11.92	11.99	11.9	11.973	13100.0
2023-05-25	AFIF	ETF	8.7835	8.7835	8.7	8.7452	25378.0
2023-05-25	AFK	ETF	14.81	14.84	14.72	14.72	2653.0
2023-05-25	AFSM	ETF	22.89	22.89	22.86	22.86	300.0
2023-05-25	AFTY	ETF	15.038	15.038	15.038	15.038	100.0
2023-05-25	AGG	ETF	97.74	97.8	97.44	97.49	5941300.0
2023-05-25	AGGH	ETF	22.55	22.55	22.499	22.499	722.0
2023-05-25	AGGY	ETF	42.89	42.92	42.77	42.79	83200.0
2023-05-25	AGNG	ETF	27.5	27.5	27.11	27.21	3500.0
2023-05-25	AGOV	ETF	75.26	76.17	75.26	75.5	1305.0
2023-05-25	AGOX	ETF	21.895	22.06	21.85	21.96	16800.0
2023-05-25	AGQ	ETF	27.94	28.01	27.1	27.16	841500.0
2023-05-25	AGZ	ETF	107.48	107.52	107.23	107.243	38628.0
2023-05-25	AGZD	ETF	21.8	21.82	21.705	21.82	51400.0
2023-05-25	AHOY	ETF	19.22	19.22	19.1695	19.1695	280.0
2023-05-25	AHYB	ETF	43.241	43.241	43.18	43.18	600.0
2023-05-25	AIA	ETF	58.18	58.3	57.82	57.94	43036.0
2023-05-25	AIEQ	ETF	28.9	29.25	28.75	29.162	14100.0
2023-05-25	AIQ	ETF	25.36	25.41	25.1	25.3	584989.0
2023-05-25	AIRR	ETF	47.67	48.29	47.5	48.14	20000.0

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

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