picasotop contract
    Updated 2025-05-01
    SELECT
    contract_address,
    COUNT(DISTINCT tx_hash) AS distinct_transactions,
    COUNT(DISTINCT origin_from_address) AS unique_users,
    CASE
    WHEN LOWER(contract_address) = '0x637e22a1ebbca50ea2d34027c238317fd10003eb' THEN 'Mezo USD (MUSD)'
    WHEN LOWER(contract_address) = '0x9c55214751472788a06797d88f38af1e79eee018' THEN 'MUSD Proxy'
    WHEN LOWER(contract_address) = '0x7ec27d448c6437b4dc3561b3b33512680a179c3f' THEN 'tBTC Token'
    WHEN LOWER(contract_address) = '0xd6626dcca8aa760b227e02b2391aaaecf9371c5d' THEN 'tBTC Proxy'
    WHEN LOWER(contract_address) = '0xd54700ad42fc49a829dcd3c377ad7b9ed176656a' THEN 'SortedTroves'
    WHEN LOWER(contract_address) = '0xb1dc6a437a2b96ac3ae61db110fe5be43deb09ad' THEN 'ActivePool'
    WHEN LOWER(contract_address) = '0x20faea18b6a1d0fcdbccfffe3d164314744baf30' THEN 'BorrowerOperations'
    WHEN LOWER(contract_address) = '0xd374631405613990d62984a08663a28248678975' THEN 'TroveManager'
    WHEN LOWER(contract_address) = '0x5eaa741552d6af40c7bf46467eaf79eea08eea9f' THEN 'WBTC Token'
    WHEN LOWER(contract_address) = '0xd68308efbe8330a7bf58276edef51d91316e90b4' THEN 'USDT Token'
    WHEN LOWER(contract_address) = '0xf08085ed33c0619113ee706fdb4b1b2c96137bee' THEN 'USDC Token'
    WHEN LOWER(contract_address) = '0xac10cd8486f92fa55d9549203fb7fdf6afdc5a77' THEN 'DefaultPool'
    WHEN LOWER(contract_address) = '0x987e7b0f6d89f3779b7e4d90df2476da2f2d32c9' THEN 'Blend tBTC'
    WHEN LOWER(contract_address) = '0xa4e1aef86111d214755c46a5053169405c7703ce' THEN 'Blend WBTC'
    WHEN LOWER(contract_address) = '0x9889b2375b88a761e217e3ee177f005a384ab5ca' THEN 'Blend Variable Debt MUSD'
    WHEN LOWER(contract_address) = '0xc259ab589c9db37140f917756e0035662b32afd8' THEN 'Blend USDT'
    WHEN LOWER(contract_address) = '0x2b4dc822f9e316342bffe97071113c887292c434' THEN 'Blend Variable Debt tBTC'
    WHEN LOWER(contract_address) = '0x936a17172d13a4a784cbd4a53d259631fe4575e8' THEN 'Blend MUSD'
    WHEN LOWER(contract_address) = '0x7e80bd5a2e8fca0b160254d43ac9f43ac2cc1052' THEN 'Unlabeled Contract B'
    WHEN LOWER(contract_address) = '0x215da05e3695e54d013477ec5c501e0b0deafcb5' THEN 'Unlabeled Contract A'
    ELSE 'Unknown'
    END AS contract_name
    FROM mezo.testnet.fact_event_logs
    WHERE
    tx_succeeded = TRUE
    AND contract_address IS NOT NULL
    GROUP BY contract_address, contract_name
    ORDER BY distinct_transactions DESC
    LIMIT 20;
    Last run: about 1 month ago
    CONTRACT_ADDRESS
    DISTINCT_TRANSACTIONS
    UNIQUE_USERS
    CONTRACT_NAME
    1
    0x637e22a1ebbca50ea2d34027c238317fd10003eb10253419761Mezo USD (MUSD)
    2
    0x7ec27d448c6437b4dc3561b3b33512680a179c3f975339457tBTC Token
    3
    0x5eaa741552d6af40c7bf46467eaf79eea08eea9f802699503WBTC Token
    4
    0x9c55214751472788a06797d88f38af1e79eee0186561814088MUSD Proxy
    5
    0xd68308efbe8330a7bf58276edef51d91316e90b4527428239USDT Token
    6
    0xf08085ed33c0619113ee706fdb4b1b2c96137bee444047513USDC Token
    7
    0xd374631405613990d62984a08663a282486789752795318930TroveManager
    8
    0xd54700ad42fc49a829dcd3c377ad7b9ed176656a2795318930SortedTroves
    9
    0x20faea18b6a1d0fcdbccfffe3d164314744baf302795318930BorrowerOperations
    10
    0xb1dc6a437a2b96ac3ae61db110fe5be43deb09ad2795318930ActivePool
    11
    0xd6626dcca8aa760b227e02b2391aaaecf9371c5d2348310512tBTC Proxy
    12
    0xe9c5143c3c116146d9745334cdd673aa124438ae119029997Unknown
    13
    0x68650a9873740526f29b30b2b97040173b861ffd118679997Unknown
    14
    0x4b92814e5bcc9f0eba71ebfbddfb758c79e6f502118679997Unknown
    15
    0x2986b058e0832ea25e2cf45a971dee177ad9b458118679997Unknown
    16
    0x4075ab867e5afd7a86b738432d726b1ba62b5113118679997Unknown
    17
    0x96fb2981524cef46b3382eeae4cbc59d30addfc1118579997Unknown
    18
    0x987e7b0f6d89f3779b7e4d90df2476da2f2d32c9100767086Blend tBTC
    19
    0xa4e1aef86111d214755c46a5053169405c7703ce93425730Blend WBTC
    20
    0xac10cd8486f92fa55d9549203fb7fdf6afdc5a7791043894DefaultPool
    20
    1KB
    2s