WITH received AS (

SELECT

tx_to AS wallet,

SUM(amount) AS amnt

FROM

solana.core.fact_transfers

WHERE

mint = '{{Token_Address}}'

AND block_timestamp::date >= '2020-01-01'

GROUP BY

wallet

),

sent AS (

SELECT

tx_from AS wallet,

SUM(amount) AS amnt

FROM

solana.core.fact_transfers

WHERE

mint = '{{Token_Address}}'

AND block_timestamp >= '2020-01-01'

GROUP BY

wallet

SELECT

COALESCE(s.wallet, r.wallet) AS wallet,

l.address_name,

COALESCE(r.amnt, 0) - COALESCE(s.amnt, 0) AS balance,

((COALESCE(r.amnt, 0) - COALESCE(s.amnt, 0)) / '{{Circulating_Supply}}') * 100 || '%' as "%_of Supply_Held",

RANK() OVER (ORDER BY balance DESC) AS rank

FROM

sent s