PREVIEW / etf_daily / 2023-05-26

all etf daily files

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

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-26	SPY	ETF	415.33	420.77	415.25	420.02	93830000.0
2023-05-26	QQQ	ETF	340.76	349.245	340.66	348.4	63006952.0
2023-05-26	IWM	ETF	174.3	176.38	174.02	176.15	29841300.0
2023-05-26	DIA	ETF	328.13	331.62	327.92	330.84	3580000.0
2023-05-26	GLD	ETF	181.01	181.3	180.09	180.92	5823700.0
2023-05-26	TLT	ETF	100.12	101.17	100.0	101.09	17030300.0
2023-05-26	AAA	ETF	24.575	24.575	24.575	24.575	0.0
2023-05-26	AAAU	ETF	19.32	19.35	19.22	19.31	718100.0
2023-05-26	AADR	ETF	46.93	47.13	46.93	47.13	700.0
2023-05-26	AAPB	ETF	24.53	24.85	24.53	24.85	6236.0
2023-05-26	AAPD	ETF	22.56	22.57	22.2769	22.314	172625.0
2023-05-26	AAPU	ETF	24.87	25.3981	24.87	25.31	84137.0
2023-05-26	AAXJ	ETF	65.4	66.18	65.4	66.1	1255100.0
2023-05-26	ABEQ	ETF	27.872	27.872	27.74	27.8	11300.0
2023-05-26	ACES	ETF	42.73	43.12	42.477	42.99	46500.0
2023-05-26	ACIO	ETF	30.08	30.23	30.08	30.15	27800.0
2023-05-26	ACSI	ETF	43.9599	43.9599	43.9599	43.9599	0.0
2023-05-26	ACT	ETF	24.3	25.0	24.0	24.77	298890.0
2023-05-26	ACTV	ETF	29.7393	29.7393	29.7393	29.7393	48.0
2023-05-26	ACTX	ETF	0.2568	0.2568	0.2568	0.2568	200.0
2023-05-26	ACVF	ETF	33.95	33.95	31.8	31.971	87400.0
2023-05-26	ACWF	ETF	33.84	34.23	33.84	34.1981	7495.0
2023-05-26	ACWI	ETF	91.74	92.79	91.74	92.66	2216500.0
2023-05-26	ACWV	ETF	96.88	97.36	96.85	97.08	109400.0
2023-05-26	ACWX	ETF	48.83	48.85	48.805	48.85	120503.0
2023-05-26	ADFI	ETF	8.35	8.39	8.35	8.389	24600.0
2023-05-26	ADIV	ETF	13.44	13.44	13.44	13.44	100.0
2023-05-26	ADME	ETF	34.88	34.98	34.88	34.91	5000.0
2023-05-26	ADPV	ETF	22.7447	22.92	22.7447	22.9042	1634.0
2023-05-26	AEMB	ETF	36.87	36.935	36.85	36.935	200.0
2023-05-26	AESR	ETF	12.1	12.15	12.1	12.121	18400.0
2023-05-26	AFIF	ETF	8.77	8.77	8.77	8.77	2.0
2023-05-26	AFK	ETF	14.9	14.91	14.84	14.84	4740.0
2023-05-26	AFLG	ETF	24.048	24.048	24.048	24.048	100.0
2023-05-26	AFMC	ETF	22.888	22.888	22.888	22.888	100.0
2023-05-26	AFSM	ETF	23.028	23.028	23.028	23.028	100.0
2023-05-26	AFTY	ETF	15.136	15.136	15.136	15.136	200.0
2023-05-26	AGG	ETF	97.36	97.59	97.24	97.57	3889800.0
2023-05-26	AGGH	ETF	22.5399	22.5557	22.5399	22.5557	903.0
2023-05-26	AGGY	ETF	42.73	42.84	42.69	42.84	120600.0
2023-05-26	AGNG	ETF	27.09	27.23	27.09	27.23	301900.0
2023-05-26	AGOV	ETF	76.6	76.8235	76.05	76.8235	506.0
2023-05-26	AGOX	ETF	22.13	22.324	22.11	22.26	13200.0
2023-05-26	AGQ	ETF	28.21	28.65	27.88	28.56	661700.0
2023-05-26	AGZ	ETF	107.2484	107.2597	107.17	107.17	1179.0
2023-05-26	AGZD	ETF	21.74	21.835	21.74	21.82	70800.0
2023-05-26	AHOY	ETF	19.3399	19.3553	19.3399	19.3553	223.0
2023-05-26	AHYB	ETF	43.34	43.434	43.313	43.434	800.0
2023-05-26	AIA	ETF	59.34	59.37	59.29	59.33	1422.0
2023-05-26	AIEQ	ETF	29.53	30.324	29.53	30.27	41500.0

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

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