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

date_trunc(day, block_timestamp) as date,

case when Program_id = 'zF2vSz6V9g1YHGmfrzsY497NJzbRr84QUrPry4bLQ25' then 'Mango'

when Program_id = 'abfcSQac2vK2Pa6UAJb37DzarVxF15bDTdphJzAqYYp' then 'abfcS...qYYp'

else Label end as Project,

count(DISTINCT tx_id) as N_TXs,

count(DISTINCT signers[0]) as N_Users

from solana.core.ez_events_decoded join Holders on ez_events_decoded.signers[0] = Holders.Holder_Address

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

where 1=1

and block_timestamp >= current_timestamp - interval '29 Days'

and SUCCEEDED

and EVENT_TYPE in (

'depositReserveLiquidityAndObligationCollateral',

'withdrawObligationCollateralAndRedeemReserveCollateral',

'lendingAccountWithdraw',

'lendingAccountDeposit',

'lendingAccountWithdrawEmissions',

'lendingAccountBorrow',