flipside

    Total
    Afonso_DiazTotal
    Updated 2024-06-10
    WITH t_main AS (
    SELECT
    BLOCK_TIMESTAMP
    ,TX_HASH
    ,ORIGIN_FROM_ADDRESS AS USER
    ,'Ethereum' AS CHAIN
    FROM ethereum.core.ez_decoded_event_logs
    WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    AND TX_STATUS = 'SUCCESS'

    UNION ALL

    SELECT
    BLOCK_TIMESTAMP
    ,TX_HASH
    ,ORIGIN_FROM_ADDRESS AS USER
    ,'Arbitrum' AS CHAIN
    FROM arbitrum.core.ez_decoded_event_logs
    WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    AND TX_STATUS = 'SUCCESS'

    UNION ALL

    SELECT
    BLOCK_TIMESTAMP
    ,TX_HASH
    ,ORIGIN_FROM_ADDRESS AS USER
    ,'Polygon' AS CHAIN
    FROM polygon.core.ez_decoded_event_logs
    WHERE ORIGIN_TO_ADDRESS = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    AND TX_STATUS = 'SUCCESS'

    UNION ALL

    SELECT
    BLOCK_TIMESTAMP
    QueryRunArchived: QueryRun has been archived