mo115NEAR stablecoin swaps - Top 10 Loosers
    Updated 2024-08-23
    select
    count (distinct TX_HASH) as "Transactions"
    , TRADER as "Wallet"
    , (sum(AMOUNT_OUT)-sum(AMOUNT_IN)) as diff
    from near.defi.ez_dex_swaps
    where SYMBOL_OUT in ('USDt' , 'USDT.e' ,'USDC' ,'USDC.e')
    and SYMBOL_IN in ('USDt' , 'USDT.e' ,'USDC' ,'USDC.e')

    group by 2
    order by 3
    limit 10
    QueryRunArchived: QueryRun has been archived