aPriori0xb2f82D0f38dc453D596Ad40A37799446Cc89274A
    Updated 2025-02-28

    select
    case when TO_ADDRESS='0xb2f82D0f38dc453D596Ad40A37799446Cc89274A' then 'in' else 'out' end as transfer_type
    ,FROM_ADDRESS
    ,TO_ADDRESS
    ,amount
    ,min_time
    ,max_time
    from
    (
    select
    TO_ADDRESS
    ,FROM_ADDRESS
    ,sum(VALUE) as amount
    ,max(BLOCK_TIMESTAMP) as max_time
    ,min(BLOCK_TIMESTAMP) as min_time
    from monad.testnet.fact_traces
    where
    (
    FROM_ADDRESS=lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A')
    or
    TO_ADDRESS=lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A')
    )
    and VALUE>0
    group by 1,2
    ) a
    order by 4 desc
    -- TX_HASH='0x2b9689a297a1674c27ad0df4ce7bd431008914660289d416695d1aafc5f8cb1e'
    -- where TX_HASH='0x7c87736dee1db46b31dacb3c8c86043ac9ef5b09998408a39a7626b5f84d9e1f'

    -- group by 1
    -- order by 2 desc


    QueryRunArchived: QueryRun has been archived