Monad Metrics Guildgorgeous-moccasin
    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
    ADDRESS
    NET_HOLDING
    RN
    1
    0xd018ce362ba0ff2ac8d85d8fe90bb023e015104d1000000000.251831
    2
    0x581b1dd14731efe7986db62e2a003e859147ed141000000000.110422
    3
    0x97a6945344c0e5aba275c3822ed2101af6214f8b1000000000.10953
    4
    0x1b3d6697bda29e6c3fa8d49cd0ab77c99a34fcef1000000000.021614
    5
    0x23fb83abbacb3ce3dc76509f926f5c34997e8ee41000000000.00945
    6
    0x92ba92a0dbb9a21b03e363547c26896dd1b14bac1000000000.00946
    7
    0x20fcd2699784314d53be3ee42b60906a38f96cf31000000000.00057
    8
    0x2f7e0ad39eb866792a5535fba399145263f56100999999999.999658
    9
    0x173562a3747eb31192e196aea1180b2496881f7c999916976.9766439
    10
    0x3c75cfdfb0d3c995a960c143d8958fd8a937be9e735705160.89202510
    11
    0xff73ba9e0669d7ead82421ad105bc6d715606ec4131762690.31499911
    12
    0xae4f437cf284cc6ece5398da83657c531e622b9b29764503.011401612
    13
    0xfa735cca8424e4ef30980653bf9015331d9929db23446005.956740313
    14
    0x3e09533c74df2181069a1ec04c425fbca8a76b509991950.0023924814
    15
    0xd58d857a5d9faa5865ead06a1e99b2cef8dd24d49378894.0003924815
    16
    0xb40162fe63ac898bf5b221ac8c73de4c42a39a798998799.9005024816
    17
    0x173d64529222db4d0427d36040bfe131c35027eb3232415.9902803517
    18
    0x04c9495d7fcb42557348cd061590d99d8b8ce04a268517418
    19
    0x7d6a2ca771ac7c68d4e2bace94a3926af30d7d831618047.330975819
    20
    0xe0588212965896fc659e407e4ed4a94840f6ec561501396.001220
    100
    6KB
    13s