select

OWNER,

BALANCE,

row_number() over(partition by owner order by block_timestamp desc) as rank

from solana.core.fact_token_balances

where SUCCEEDED

and mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

),

Holders as (

select owner as Holder_Address,

BALANCE

from address_balance

where balance > 0

and rank = 1

select Top 20

LABEL,

count(DISTINCT tx_id) as N_TXs,

count(DISTINCT signers[0]) as N_Users,

N_Users / (select count(DISTINCT Holder_Address) from Holders) * 100 as PCT_OF_HOLDERS

from solana.core.ez_events_decoded

join solana.core.dim_labels on ez_events_decoded.program_id = dim_labels.ADDRESS

where signers[0] in (select Holder_Address from Holders)

and block_timestamp >= current_timestamp - interval '29 Days'

group by 1

order by N_TXs desc