PREVIEW / etf_daily / 2023-05-31

all etf daily files

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

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-31	SPY	ETF	418.28	419.22	416.22	417.85	110811800.0
2023-05-31	QQQ	ETF	348.37	350.6	346.51	347.99	65105378.0
2023-05-31	IWM	ETF	174.69	176.01	172.36	173.77	34598800.0
2023-05-31	DIA	ETF	329.45	330.17	327.7	329.52	3067600.0
2023-05-31	GLD	ETF	182.39	183.45	182.1	182.32	8497900.0
2023-05-31	TLT	ETF	101.99	103.18	101.87	102.99	23787000.0
2023-05-31	AAA	ETF	24.6	24.6	24.5601	24.58	471.0
2023-05-31	AAAU	ETF	19.47	19.58	19.45	19.47	1356500.0
2023-05-31	AADR	ETF	45.87	45.97	45.87	45.97	400.0
2023-05-31	AAPB	ETF	25.35	25.76	25.28	25.345	12140.0
2023-05-31	AAPD	ETF	22.05	22.1343	21.82	22.05	251667.0
2023-05-31	AAPU	ETF	25.74	26.18	25.64	25.78	165019.0
2023-05-31	AAXJ	ETF	64.74	64.83	64.26	64.81	892800.0
2023-05-31	ABEQ	ETF	27.74	27.74	27.59	27.63	15500.0
2023-05-31	ACES	ETF	43.47	43.81	42.57	43.47	213900.0
2023-05-31	ACIO	ETF	30.065	30.12	29.985	30.08	57600.0
2023-05-31	ACSI	ETF	43.8455	43.8455	43.8455	43.8455	26.0
2023-05-31	ACT	ETF	24.9	25.11	24.27	24.34	283271.0
2023-05-31	ACTV	ETF	29.51	29.51	29.06	29.2767	5991.0
2023-05-31	ACVF	ETF	31.85	31.85	31.6	31.701	37800.0
2023-05-31	ACWF	ETF	33.8	33.8476	33.64	33.72	19356.0
2023-05-31	ACWI	ETF	91.68	91.88	91.17	91.62	2274600.0
2023-05-31	ACWV	ETF	96.32	96.57	95.96	96.36	93300.0
2023-05-31	ACWX	ETF	47.91	47.94	47.515	47.82	2478361.0
2023-05-31	ADFI	ETF	8.41	8.44	8.41	8.43	28800.0
2023-05-31	ADIV	ETF	13.085	13.199	13.085	13.199	300.0
2023-05-31	ADME	ETF	34.81	34.81	34.64	34.72	189900.0
2023-05-31	ADPV	ETF	22.51	22.6316	22.51	22.6316	725.0
2023-05-31	AEMB	ETF	37.16	37.235	37.16	37.235	200.0
2023-05-31	AESR	ETF	12.11	12.18	12.06	12.12	44600.0
2023-05-31	AFIF	ETF	8.78	8.8	8.77	8.7853	27150.0
2023-05-31	AFK	ETF	15.0	15.0	14.84	14.84	5305.0
2023-05-31	AFLG	ETF	23.826	23.826	23.77	23.805	400.0
2023-05-31	AFMC	ETF	22.45	22.488	22.45	22.488	200.0
2023-05-31	AFSM	ETF	22.62	22.62	22.62	22.62	100.0
2023-05-31	AFTY	ETF	14.73	14.76	14.64	14.695	12900.0
2023-05-31	AGG	ETF	98.22	98.72	98.21	98.57	10559900.0
2023-05-31	AGGH	ETF	22.75	22.81	22.75	22.765	1585.0
2023-05-31	AGGY	ETF	43.12	43.255	43.099	43.22	291600.0
2023-05-31	AGNG	ETF	26.986	27.124	26.95	27.124	1300.0
2023-05-31	AGOV	ETF	78.43	78.43	75.8268	75.8268	161.0
2023-05-31	AGOX	ETF	22.16	22.19	22.023	22.07	19000.0
2023-05-31	AGQ	ETF	28.53	29.33	27.95	29.12	1037000.0
2023-05-31	AGZ	ETF	107.68	107.83	107.6144	107.78	93976.0
2023-05-31	AGZD	ETF	21.695	21.87	21.695	21.84	54000.0
2023-05-31	AHYB	ETF	43.431	43.485	43.431	43.485	600.0
2023-05-31	AIA	ETF	57.93	57.93	57.3	57.87	44194.0
2023-05-31	AIEQ	ETF	29.86	29.86	29.36	29.41	10100.0
2023-05-31	AIQ	ETF	26.05	26.19	25.87	26.13	422820.0
2023-05-31	AIRR	ETF	48.67	48.67	47.38	47.68	73000.0

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

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