Monad Metrics GuildTop Holders and their interaction
    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
    HOLDERS
    TOTAL_TRANSACTIONS
    CONTRACTS_INTERACTED
    TOTAL_AMOUNT_INTERACTED
    1
    0xff73ba9e0669d7ead82421ad105bc6d715606ec4498641141532077.59236
    2
    0x3c75cfdfb0d3c995a960c143d8958fd8a937be9e4425000003
    3
    0xae4f437cf284cc6ece5398da83657c531e622b9b9523000102.2
    4
    0x04c9495d7fcb42557348cd061590d99d8b8ce04a165202684716
    5
    0x173d64529222db4d0427d36040bfe131c35027eb4382261846
    6
    0xc95dd1e8ea4b14f97cb3d10075ed4586053ba3363405681667359.150835
    7
    0xf7eedd2bc737406d46d4cbfd51c2e90a6979987d1221591420385.54374851
    8
    0x7d6a2ca771ac7c68d4e2bace94a3926af30d7d832678741161304036.95
    9
    0xe6e483000d4707d506d814d88714fa2041bd3bd216729528132.448710508
    10
    0xf22b976ea899662017ec98d3e1b1299adfd89df22792428455983.963623112
    11
    0x87f6ae6d6e0c3c9b08fc01c25705c679c043ed8159924355886.382511543
    12
    0x9d083bc354e3d4b39b9ca3c77f80fbf95fec3c76472649283508.118096179
    13
    0xebfbc2990ea690ff57930a9fc9f25f281edbbed1576622276068.921052765
    14
    0x8b576ffaedbc9883496746b6ec91f7ab4795f2505999250714.6025055
    15
    0x9d7fce433d258016457ba056e24cb1a2fc26cb53378711203300.98
    16
    0xed86b5962a1a73afad7181f0b3e427a93ce8e55242334174946.152489607
    17
    0xc4891c94c5987ed3263c791b61562d3731155e5310219150063.0051
    18
    0x954b1af8a7c0f95f4607362773d553a61fa434f15093149910
    19
    0x1ebfd9ba352a8622493e124e819abd4205b4614823203123700.0051
    20
    0xff85d222a3753e5ec6978d470e3d816e667bdd15385410109773.538516051
    73
    5KB
    10s