Updated 2025-03-21
    SELECT DISTINCT LOWER(SUBSTRING(l.topic_3, 27)) AS to_address
    FROM monad.testnet.fact_event_logs l
    JOIN monad.testnet.fact_transactions t
    ON l.tx_hash = t.tx_hash
    WHERE t.to_address = LOWER('0x38f7f5147f8d185577edf2c72b3367992b01c58d')
    AND t.block_timestamp >= DATEADD('month', -3, CURRENT_DATE)
    AND LEFT(t.input_data, 10) = '0xbb4c9f0b'
    AND l.topic_1 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'; -- Transfer event

    Last run: about 1 month ago
    No Data to Display
    0
    2B
    58s