MasiOverview of Top Contracts
    Updated 2025-05-12
    SELECT contract_address,
    count(distinct a.block_timestamp::date) as "Active Days",
    count(distinct a.origin_from_address) as "Wallets",
    count(distinct a.tx_hash) as "Total Transactions",
    COUNT(DISTINCT CASE WHEN a.TX_SUCCEEDED = 'TRUE' THEN a.tx_hash END) AS "Success Transactions",
    COUNT(DISTINCT CASE WHEN a.TX_SUCCEEDED != 'TRUE' THEN a.tx_hash END) AS "Failed Transactions",
    sum(TX_FEE_PRECISE) as "Total Fee (BTC)",
    avg(TX_FEE_PRECISE) as "Average Fee (BTC)",
    max(TX_FEE_PRECISE) as "Max Fee (BTC)"
    FROM mezo.testnet.fact_event_logs a join mezo.testnet.fact_transactions b on a.tx_hash = b.tx_hash
    group by 1
    order by 4 desc
    limit 100
    Last run: 21 days ago
    CONTRACT_ADDRESS
    Active Days
    Wallets
    Total Transactions
    Success Transactions
    Failed Transactions
    Total Fee (BTC)
    Average Fee (BTC)
    Max Fee (BTC)
    1
    0x637e22a1ebbca50ea2d34027c238317fd10003eb452834917029717029700.18916037126.122745039e-70.000860305504014759
    2
    0x7ec27d448c6437b4dc3561b3b33512680a179c3f391333015431715431700.025090741491.475066961e-70.000584992502729965
    3
    0x5eaa741552d6af40c7bf46467eaf79eea08eea9f371324113114813114800.035336827892.620143542e-70.000622816502906477
    4
    0x9c55214751472788a06797d88f38af1e79eee018401852811182011182000.13798748865.27025848e-70.000660996003084648
    5
    0xd68308efbe8330a7bf58276edef51d91316e90b43711758963139631300.016154997351.500180835e-70.000595281002777978
    6
    0xf08085ed33c0619113ee706fdb4b1b2c96137bee3611003865238652300.012491812461.286555689e-70.000649683003031854
    7
    0xe9c5143c3c116146d9745334cdd673aa124438ae848938510545105400.0000010951598545.462988561e-120.0000000000175
    8
    0x4b92814e5bcc9f0eba71ebfbddfb758c79e6f502848938510195101905.488092209e-75.465029783e-120.0000000000175
    9
    0x2986b058e0832ea25e2cf45a971dee177ad9b458848938510195101900.0000011089048535.433304521e-120.0000000000175
    10
    0x4075ab867e5afd7a86b738432d726b1ba62b5113848938510195101902.843736242e-75.357554291e-120.0000000000175
    11
    0x68650a9873740526f29b30b2b97040173b861ffd848938510195101902.779328825e-75.426045107e-120.0000000000175
    12
    0x96fb2981524cef46b3382eeae4cbc59d30addfc1848938510045100408.234888601e-75.454688447e-120.000000000012
    13
    0x20faea18b6a1d0fcdbccfffe3d164314744baf304527398507085070800.10881460028.463122707e-70.000860305504014759
    14
    0xd374631405613990d62984a08663a282486789754527398507085070800.13701242888.847445696e-70.000860305504014759
    15
    0xd54700ad42fc49a829dcd3c377ad7b9ed176656a4527398507085070800.052920699867.19197367e-70.000860305504014759
    16
    0xb1dc6a437a2b96ac3ae61db110fe5be43deb09ad4527398507085070800.17013579447.882715161e-70.000860305504014759
    17
    0xd6626dcca8aa760b227e02b2391aaaecf9371c5d4516388362713627100.010189947762.809392561e-70.0002871000013398
    18
    0xac10cd8486f92fa55d9549203fb7fdf6afdc5a77437589232122321200.012497857785.384222723e-70.000614638502868313
    19
    0x936a17172d13a4a784cbd4a53d259631fe4575e8366450183291832900.012726860083.471782444e-70.000633504002956352
    20
    0x987e7b0f6d89f3779b7e4d90df2476da2f2d32c9399932156131561300.0074168027212.375201025e-70.000303114001414532
    100
    11KB
    36s