Updated 2025-03-02
    with raw as
    (select
    block_timestamp,
    tx_hash,
    from_address,
    to_address,
    value
    from monad.testnet.fact_traces
    where input = '0x'
    and output is null
    and TX_SUCCEEDED = 'true'
    and trace_address = 'ORIGIN'
    and origin_function_signature = '0x'
    ),

    out as (
    select
    from_address as address,
    sum(-value) as amount
    from raw
    group by 1
    ),

    ins as (
    select
    to_address as address,
    sum(value) as amount
    from raw
    group by 1
    ),

    combined as (
    select * from ins
    union all
    select * from out
    ),
    Last run: about 1 month ago
    CONTRACT
    TOTAL_TRANSACTIONS
    USER_INTERACTION
    AMOUNT_INTERACTED
    1
    0xbb444821e159dd6401bb92fb18c2ac0a3711302595334020
    2
    0x09fb6a39471eb9dcee30fb91d8830195b1380e0f26775821304026.15
    3
    0x836047a99e11f376522b447bffb6e3495dd0637c112018320
    4
    0x6aca21c6c79066f41b4d0c32574ddb07fc2e713146913130101.448928879
    5
    0xedb0f17e5b701c8a1278b94b961384cf4015f2403042724.3532e-14
    6
    0xc56f9f2527a943f217dcb8ce1180613f62d1d7102301310
    7
    0x86d74bcfca4a9fd369f53257cb9f1ccffc15f7618139150670
    8
    0x40ca34a5c532bdfb41ed31a1c0a7bbe626eb196b5375159943
    9
    0x9fb480a193c250bf8ece39df5d9d728e21026b345285223015000.3504406
    10
    0x8a86d48c867b76ff74a36d3af4d2f1e707b143ed416810
    11
    0xfb8e1c3b833f9e67a71c859a132cf783b645e4363877320566107.3582831
    12
    0x88b96af200c8a9c35442c8ac6cd3d22695aae4f03853324427466.98021815
    13
    0x760afe86e5de5fa0ee542fc7b7b713e1c5425701382121122096997.024437
    14
    0x3ae6d8a282d67893e17aa70ebffb33ee5aa65893246325515404.190859685
    15
    0x2c57d920961007ae56d3b93169e98a803b336ef1188010
    16
    0x0000000000000068f116a894984e2db1123eb395109810158121.674001
    17
    0x75f2948bff7d6d6bb6133cc5fe3c710656c2a939100621667349
    18
    0x6dcf87a42ccfcedee684607e406e75d079cbf23a69510
    19
    0x0bff87e80fbbeb934b79990eaeb535e549ad078d69410
    20
    0x8d29e081c0b95d56e2cbca2cef35c82bb6cdd644634221000
    ...
    1097
    62KB
    11s