Afonso_DiazTop Contracts
    Updated 2025-03-06
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    origin_from_address as user,
    origin_to_address as contract_address
    from
    ink.core.fact_event_logs
    where
    tx_succeeded
    )

    select
    contract_address,
    count(distinct tx_hash) as transactions,
    count(distinct user) as users
    from
    main
    group by 1
    order by 2 desc
    limit 10

    Last run: about 2 months ago
    CONTRACT_ADDRESS
    TRANSACTIONS
    USERS
    1
    0x9f500d075118272b3564ac6ef2c70a9067fd2d3f2722618163510
    2
    0x1195cf65f83b3a5768f3c496d3a05ad6412c64b729997534505
    3
    0xa8c1c38ff57428e5c3a34e0899be5cb38547650729660057647
    4
    0x420000000000000000000000000000000000000625266853832
    5
    0xf1815bd50389c46847f0bda824ec8da914045d1414712455652
    6
    0x9b17690de96fcfa80a3acaefe11d936629cd7a7713195736060
    7
    0x9c5577aef7c2a5c80aa62ba5420170f6b4a302ff12040344367
    8
    0xef684c38f94f48775959ecf2012d7e864ffb9dd41012459132
    9
    0x7f4babd2c7d35221e72ab67ea72cba99573a00898533333060
    10
    0xcab283e4bb527aa9b157bae7180fef19e2aaa71a8105245293
    10
    600B
    4s