(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