select
'USDC'as stablecoin,
case when
address_name is null then concat('https://solscan.io/account/',tx_from) else address_name end as sender_address,
sum(amount) as volume,
count(*) as send_outs
from solana.core.fact_transfers left join solana.core.dim_labels on address=tx_from
where block_timestamp >= CURRENT_DATE - interval '2 months' and mint= 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
group by sender_address
order by volume DESC
LIMIT 100