WITH t0 AS (

SELECT tx_from AS address

, SUM(-amount) AS net_amt

FROM solana.core.fact_transfers

WHERE block_timestamp >= '2022-12-14'

AND mint = 'HeqCcMjmuV5s25J49YiJyT6bD5qWLkP88YPajBySniaV'

GROUP BY 1

UNION

SELECT tx_to AS address

, SUM(amount) AS net_amt

FROM solana.core.fact_transfers

WHERE block_timestamp >= '2022-12-14'

AND mint = 'HeqCcMjmuV5s25J49YiJyT6bD5qWLkP88YPajBySniaV'

GROUP BY 1

), t1 AS (

SELECT address

, SUM(net_amt) AS net_amt

FROM t0

GROUP BY 1

SELECT address as "Address",

to_varchar(net_amt, '999,999,999,999,999') AS "Total amount"

, CONCAT(ROUND(100 * net_amt / SUM(net_amt) OVER (), 4), '%') AS "Percent"

FROM t1

WHERE net_amt >= 1

and address not in ('GwdP8WUaLQuPoKsHK7YNfjuRCTJtGw7htV61gAr6zDNy')

ORDER BY net_amt DESC

LIMIT 100