(SELECT contract_address, count(DISTINCT tx_hash) as total_calls from arbitrum.core.fact_event_logs

where date(block_timestamp) >= CURRENT_DATE -90

GROUP by 1

order by 2 desc

LIMIT 10 )

SELECT *,

case when contract_address = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' then 'WETH token'

when contract_address = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' then 'USDC'

when contract_address = '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' then 'USDT'

when contract_address = '0xc31e54c7a869b9fcbecc14363cf510d1c41fa443' then 'ETH/USDC UNiswap Pair'

when contract_address = '0x9e6ef7f75ad88d4edb4c9925c94b769c5b0d6281' then 'Galxe Space Station'

when contract_address = '0x3d6ba331e3d9702c5e8a8d254e5d8a285f223aba' then 'Position Router'

when contract_address = '0xda7c0de432a9346bb6e96ac74e3b61a36d8a77eb' then 'ETH HOP Token'

when contract_address = '0x652d27c0f72771ce5c76fd400edd61b406ac6d97' then 'Hop DAI token'

when contract_address = '0x3749c4f034022c39ecaffaba182555d4508caccc' then 'Arbitrum Brdge'

when contract_address = '0x489ee077994b6658eafa855c308275ead8097c4a' then 'USD Gambit'

end as contract_name

from top

limit 100