mawmawblushing-fuchsia
    Updated 2024-12-24
    WITH
    LiquidityPools_Events as (
    SELECT
    BLOCK_NUMBER ,
    BLOCK_TIMESTAMP,
    TX_HASH,
    EVENT_INDEX,
    CONTRACT_ADDRESS,
    CONTRACT_NAME,
    ORIGIN_FROM_ADDRESS,
    ORIGIN_TO_ADDRESS,
    FULL_DECODED_LOG,
    DATA,
    TOPICS[0] as topic0,
    CASE TOPICS[0]::STRING
    WHEN '0x0c396cd989a39f4459b5fa1aed6a9a8dcdbc45908acfd67e028cd568da98982c' THEN 'Burn'
    WHEN '0x7a53080ba414158be7ec69b987b5fb7d07dee101fe85488f0853ae16239d0bde' THEN 'Mint'
    END AS Event_Name
    FROM ethereum.core.ez_decoded_event_logs log
    WHERE
    CONTRACT_ADDRESS = '0xc6962004f452be9203591991d15f6b388e09e8d0'
    AND TOPICS[0]::STRING IN (
    '0x0c396cd989a39f4459b5fa1aed6a9a8dcdbc45908acfd67e028cd568da98982c', -- Burn
    '0x7a53080ba414158be7ec69b987b5fb7d07dee101fe85488f0853ae16239d0bde' -- Mint
    )
    AND TX_STATUS = 'SUCCESS'
    AND EVENT_REMOVED = 'false'
    ),

    NFTpositions_Events as (
    SELECT
    BLOCK_NUMBER ,
    BLOCK_TIMESTAMP,
    TX_HASH,
    EVENT_INDEX,
    CONTRACT_ADDRESS,
    QueryRunArchived: QueryRun has been archived