0xHaM-dRetention copy
    Updated 2025-02-08
    -- forked from Retention @ https://flipsidecrypto.xyz/edit/queries/5c1a1e29-3e5c-4119-bc4e-fc74c6bbcc07

    -- forked from Retention @ https://flipsidecrypto.xyz/edit/queries/c0cb060e-fca1-4c21-9399-e460b535d396

    -- forked from Retention by Dune @ https://flipsidecrypto.xyz/edit/queries/821afa83-97c1-49de-bc53-f515ada55660

    with eth_transfers as (
    select
    ORIGIN_FROM_ADDRESS trader,
    TRACE_INDEX EVENT_INDEX ,
    'ETH' symbol ,
    AMOUNT_USD,
    BLOCK_TIMESTAMP,
    TX_HASH ,
    from_address,
    TO_ADDRESS
    from blast.core.ez_native_transfers
    where ORIGIN_TO_ADDRESS = '0xaaaaaaaaffe404ee9433eef0094b6382d81fb958'
    ),
    token_transfers as (
    select
    ORIGIN_FROM_ADDRESS trader,
    EVENT_INDEX ,
    SYMBOL,
    AMOUNT_USD,
    BLOCK_TIMESTAMP,
    TX_HASH,
    from_address,
    TO_ADDRESS
    from blast.core.ez_token_transfers
    where ORIGIN_TO_ADDRESS = '0xaaaaaaaaffe404ee9433eef0094b6382d81fb958'
    ),
    swaps as (
    select * from eth_transfers
    UNION
    select * from token_transfers
    QueryRunArchived: QueryRun has been archived