SELECT

owner,

balance

FROM solana.core.fact_token_balances

WHERE mint = '2DMMamkkxQ6zDMBtkFp8KH7FoWzBMBA1CGTYwom4QH6Z'

AND block_timestamp >= DATEADD('day', -30, CURRENT_TIMESTAMP)

AND succeeded = TRUE

QUALIFY ROW_NUMBER() OVER (PARTITION BY account_address ORDER BY block_timestamp DESC) = 1

SELECT

COUNT(DISTINCT(owner)) AS owner,

COUNT(balance) as token_balance

FROM latest_balances

WHERE balance > 0

ORDER BY balance DESC;