Jefferscool-indigo
    Updated 2025-03-25
    select
    m.block_timestamp,
    m.tx_hash,
    m.contract_address AS nft_contract,
    m.origin_from_address,
    m.origin_to_address,
    m.topic_0,
    m.topic_1,
    m.topic_2,
    m.topic_3,
    CASE
    when topic_3 = NULL
    then 0
    else TO_NUMERIC(utils.udf_hex_to_int(topic_3)) -- convert tokenid to numeric
    END as token_id_,
    CASE
    when m.contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
    then TO_NUMERIC(utils.udf_hex_to_int(REPLACE(m.data, '0x0000000000000000000000000000000000000000000000', ''))) / POWER(10,18) -- make the hex WMON value numeric
    else 0
    END as data_converted,
    t.value as MON_value,
    t.tx_fee as gas_fee
    from monad.testnet.fact_event_logs m
    join monad.testnet.fact_transactions t
    on m.tx_hash = t.tx_hash
    where m.tx_hash = '0x81c22d8fe59f089d56babc43759ba69910c30e2c71c07ba79e479520064a481d'
    QueryRunArchived: QueryRun has been archived