contract_address as address,

count(distinct(tx_hash)) as n_calls

from optimism.core.fact_event_logs

group by contract_address),

final as (select * from active_contracts

left join optimism.core.dim_labels using (address))

select

address,

n_calls,

address_name,

case

when address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607' then 'hop protocol: usdc token'

when address = '0x4200000000000000000000000000000000000006' then 'hop protocol: eth token'

when address = '0xc84da6c8ec7a57cd10b939e79eaf9d2d17834e04' then 'vesper finance: vusd token'

when address = '0x4200000000000000000000000000000000000042' then 'optimism: op token'

when address = '0xbd7a3b7dbeb096f0b832cf467b94b091f30c34ec' then 'vesper finance: vbnb token'

when address = '0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9' then 'synthetix: susd token'

when address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then 'hop protocol: dai token'

when address = '0xfa14e1157f35e1dad95dc3f822a9d18c40e360e2' then 'optimism quest sbt'

when address = '0x2e42f214467f647fe687fd9a2bf3baddfa737465' then 'project galaxy: general contract'

when address = '0x85149247691df622eaf1a8bd0cafd40bc45154a9' then 'genesis weth/usdc pool'

when address = '0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' then 'hop protocol: usdt token'

when address = '0x3c8b650257cfb5f272f799f5e2b4e65093a11a05' then 'velodrome finance: velo token'

when address = '0x794a61358d6845594f94dc1db02a252b5b4814ad' then 'aave: pool v3'

when address = '0x8700daec35af8ff88c16bdf0418774cb3d7599b4' then 'synthetix: snx token'

when address = '0x47029bc8f5cbe3b464004e87ef9c9419a48018cd' then 'volatilev1 amm - op/usdc'

when address = '0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d' then 'volatilev1 amm - velo/usdc'

else concat(substr(address, 0, 14), '...') end as label

from final