Hessishnom fees
    Updated 2025-03-10
    WITH mints as
    (select
    a.BLOCK_TIMESTAMP as time ,
    a.ORIGIN_FROM_ADDRESS as "Mitner",
    ethereum.public.udf_hex_to_int(b.topics[3]) as "Token id",
    a.tx_hash as "Tx"
    from monad.testnet.fact_event_logs a
    join monad.testnet.fact_event_logs b on a.tx_hash = b.tx_hash
    WHERE -- a.tx_hash = '0x7eaa7ba024fd1a07d3148aa7c1aa1e35ec9550c816f3d90f498d22741d4cca7b' and
    a.CONTRACT_ADDRESS = '0x3019bf1dfb84e5b46ca9d0eec37de08a59a41308' and
    a.TOPICS[0] = '0xcee7d9f7ea527be6fd2ad58f0621348b614e640f77b4e69c5546e2a68ac4db20'
    and a.ORIGIN_FUNCTION_SIGNATURE = '0xadba7a51'
    and a.TX_SUCCEEDED = 'TRUE'
    and b.CONTRACT_ADDRESS = '0x3019bf1dfb84e5b46ca9d0eec37de08a59a41308' and
    b.TOPICS[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
    and b.ORIGIN_FUNCTION_SIGNATURE = '0xadba7a51')


    select
    date_trunc('hour',block_timestamp) as time,
    sum(value) as "Fees (MONAD)"
    from monad.testnet.fact_traces
    join mints on "Mitner" = FROM_ADDRESS
    and "Tx" = tx_hash
    where block_timestamp::date >= '2025-02-19' and
    TO_ADDRESS = '0x758d80767a751fc1634f579d76e1ccaab3485c9c'
    group by 1
    QueryRunArchived: QueryRun has been archived