select
from_address as Address, 'https://arbiscan.io/address/' || from_address as "Arbiscan Link",
count(*) as num_of_txns
from arbitrum.core.fact_transactions
where block_timestamp > CURRENT_TIMESTAMP - interval '7 days'
group by 1
order by num_of_txns desc
limit 50