flipside

    EVM addresses over time
    0xHaM-dEVM addresses over time
    Updated 2025-01-07
    with userTb as (
    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    AMOUNT_USD
    FROM polygon.core.ez_token_transfers
    WHERE ORIGIN_TO_ADDRESS in (
    '0x488863d609f3a673875a914fbee7508a1de45ec6' -- Polygon
    ,'0x2297aebd383787a160dd0d9f71508148769342e3' -- Polygon
    )

    UNION all

    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    AMOUNT_USD
    FROM arbitrum.core.ez_token_transfers
    WHERE ORIGIN_TO_ADDRESS in (
    '0x1b896893dfc86bb67cf57767298b9073d2c1ba2c' -- Arbitrum
    ,'0x1bacc2205312534375c8d1801c27d28370656cff' -- Arbitrum
    ,'0x2297aebd383787a160dd0d9f71508148769342e3' -- Arbitrum
    )

    UNION all

    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    AMOUNT_USD
    FROM avalanche.core.ez_token_transfers
    WHERE ORIGIN_TO_ADDRESS in (
    '0xa5972eee0c9b5bbb89a5b16d1d65f94c9ef25166' -- avalanche
    QueryRunArchived: QueryRun has been archived