xrpl.token_holders_daily

The ‘xrpl.token_holders_daily’ table is a daily snapshot of token holder metrics for all IOU and MPT tokens on the XRP Ledger.

Table Description

Daily snapshot of token holder metrics for all IOU and MPT tokens on the XRP Ledger, including AMM LP tokens (which are a type of IOU). Each row represents one token and captures holder count, supply distribution, and concentration metrics as of the current date.

Column Descriptions

Column	type	Description
ledger_close_date	date	Date of the most recent ledger state available in the data, derived from the latest trustline timestamp; may lag the current calendar date
token_id	bigint	Surrogate key for the token (→ tokens)
token_currency	string	Raw currency code of the token as stored on the ledger
token_issuer	string	XRPL address of the account that issued this token
token_mpt_id	string	Unique issuance identifier for Multi-Purpose Tokens (MPTs); null for traditional IOU trust-line tokens
total_supply	double	Total outstanding supply of the token as reported by the issuer’s ledger state
total_issued	double	Sum of all positive holder balances at this snapshot date; may differ from total_supply if supply has been burned or not fully distributed
total_holders	bigint	Number of distinct accounts holding a non-zero balance of this token
top_10_holders_percent	double	Percentage of total supply held by the 10 largest holders; a measure of concentration risk
whale_accounts_count	bigint	Number of accounts each holding more than 1% of the total outstanding supply

Table Sample