mo115NEAR stablecoin swaps - Top 10 Losses
    Updated 2024-08-23
    -- forked from NEAR stablecoin swaps - Top 10 Loosers @ https://flipsidecrypto.xyz/studio/queries/79c05af9-3ecc-4b88-9123-69c8e227efee

    -- forked from NEAR stablecoin swaps - Top 10 Swaps @ https://flipsidecrypto.xyz/studio/queries/ee53e334-641f-42e3-9950-50d1865055d7

    -- forked from NEAR stablecoin swaps - Top 10 Gainers @ https://flipsidecrypto.xyz/studio/queries/fc51d5ac-f2e5-4c02-adc9-d3c7e87cdb92

    -- forked from NEAR stablecoin swaps - Daily - 30Days @ https://flipsidecrypto.xyz/studio/queries/e43cb7c9-bfc0-4b9a-a046-a04e584bc9f0

    -- forked from NEAR stablecoin swaps @ https://flipsidecrypto.xyz/studio/queries/17f3209b-a6bf-43e2-97d4-a16664e71541

    select
    TX_HASH as "Transaction"
    , TRADER as "Wallet"
    , ((AMOUNT_OUT)-(AMOUNT_IN)) as diff
    , BLOCK_TIMESTAMP
    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')
    order by 3
    limit 10
    QueryRunArchived: QueryRun has been archived