CUBE3Revolut history - EVM - time based
    Updated 2024-10-26
    -- USD value transferres by receivers (native + ERC20)
    SELECT
    ADDRESS,
    SUM(NATIVE_COUNTER) AS NATIVE_COUNTER,
    SUM(TOKEN_COUNTER) AS TOKEN_COUNTER,
    SUM(TOTAL_COUNTER) AS TOTAL_COUNTER,
    SUM(NATIVE_USD) as NATIVE_USD,
    SUM(TOKEN_USD) as TOKEN_USD,
    SUM(TOTAL_USD) as TOTAL_USD
    FROM(
    SELECT
    TO_ADDRESS AS ADDRESS,
    COUNT(*) AS NATIVE_COUNTER,
    0 AS TOKEN_COUNTER,
    COUNT(*) AS TOTAL_COUNTER,
    'native' AS TRANSFER_TYPE,
    SUM(AMOUNT_USD) as NATIVE_USD,
    0 as TOKEN_USD,
    SUM(AMOUNT_USD) as TOTAL_USD,
    FROM ethereum.core.ez_native_transfers
    -- FROM bsc.core.ez_native_transfers
    -- FROM polygon.core.ez_native_transfers
    -- FROM optimism.core.ez_native_transfers
    -- FROM base.core.ez_native_transfers
    -- FROM arbitrum.core.ez_native_transfers
    -- FROM avalanche.core.ez_native_transfers
    WHERE FROM_ADDRESS = '0xb23360ccdd9ed1b15d45e5d3824bb409c8d7c460'
    AND ORIGIN_FROM_ADDRESS = '0xb23360ccdd9ed1b15d45e5d3824bb409c8d7c460'
    AND BLOCK_TIMESTAMP BETWEEN '2024-08-01' AND '2024-10-25'
    GROUP BY TO_ADDRESS

    UNION

    SELECT
    TO_ADDRESS AS ADDRESS,
    0 AS NATIVE_COUNTER,
    QueryRunArchived: QueryRun has been archived