dannyamahWallets and tx by Event
    Updated 2025-03-24
    WITH event_data AS (
    -- OpenedChest events
    SELECT
    block_timestamp,
    tx_hash,
    event_name,
    full_decoded_log:data[0]:value::VARCHAR AS wallet
    FROM ronin.core.ez_decoded_event_logs
    WHERE 1 = 1
    AND full_decoded_log:data[0]:name = 'from'
    AND event_name = 'OpenedChest'
    AND contract_address = '0xc69f7434d4b336e68acbbde4101b7990e7d6b3b3'
    AND tx_succeeded
    AND block_timestamp >= '2025-03-21'
    UNION ALL
    -- NFTStakedRod events
    SELECT
    block_timestamp,
    tx_hash,
    event_name,
    full_decoded_log:data[0]:value::VARCHAR AS wallet
    FROM ronin.core.ez_decoded_event_logs
    WHERE 1 = 1
    AND full_decoded_log:data[0]:name = 'from'
    AND event_name = 'NFTStakedRod'
    AND contract_address = '0xc69f7434d4b336e68acbbde4101b7990e7d6b3b3'
    AND tx_succeeded
    AND block_timestamp >= '2025-03-21'

    UNION ALL
    -- NFTUnstakedRod events
    SELECT
    QueryRunArchived: QueryRun has been archived