flipside

    getapprove
    0x07f2e2fE7A091e69389E6996644F1Af09441C7e4getapprove
    Updated 2024-04-15
    select
    /* CONTRACT_ADDRESS,*/
    DISTINCT '0x' || substring(topics[2], 27, 67)
    from
    /*optimism.core.fact_event_logs*/
    /*arbitrum.core.fact_event_logs*/
    ethereum.core.fact_event_logs
    /*bsc.core.fact_event_logs*/
    /*polygon.core.fact_event_logs*/
    /*avalanche.core.fact_event_logs*/
    WHERE
    TOPICS[0] = '0x17307eab39ab6107e8899845ad3d59bd9653f200f220920489ca2b5937696c31'
    /* and topics[1] = '0x000000000000000000000000a52dfb36aa490aa5a83df0b4b2d917da7e19b635'*/
    /*and TOPICS[2] = '0x00000000000000000000000036c543b8bb76b330ecb66a13c1c1377f889f1919'*/
    and CONTRACT_ADDRESS = '0xc36442b4a4522e871399cd717abdd847ab11fe88'
    QueryRunArchived: QueryRun has been archived