Afonso_DiazTop Token pairs
    Updated 3 days ago
    with

    stablecoins as (
    select '0x37a4dd9ced2b19cfe8fac251cd727b5787e45269' as token_address

    union all

    select '0xb75d0b03c06a926e488e2659df1a861f860bd3d1' as token_address

    union all

    select '0x059a6b0ba116c63191182a0956cf697d0d2213ec' as token_address

    union all

    select '0x3894085ef7ff0f0aedf52e2a2704928d1ec074f1' as token_address

    union all

    select '0x80eede496655fb9047dd39d9f418d5483ed600df' as token_address
    ),

    main as (
    select
    tx_id,
    block_timestamp,
    swapper,
    platform,
    symbol_in,
    symbol_out,
    case
    when amount_in_usd is not null then amount_in_usd
    when amount_out_usd is not null then amount_out_usd
    when token_in in (select token_address from stablecoins) then amount_in
    when token_out in (select token_address from stablecoins) then amount_out
    end as amount_usd
    Last run: 3 days ago
    TOKEN_PAIR
    SWAPS
    SWAPPERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    WSEI -> USDC61259646682402279602.060566637.904184344
    2
    USDC -> WSEI62381438462401425147.193347621.193451096
    3
    WSEI -> USDT45023818873126379052.704598278.198219819
    4
    USDT -> WSEI43570119789124821755.701918284.71791084
    5
    WSEI -> fastUSD294981348685470999.0164209289.652668306
    6
    fastUSD -> WSEI270333327783746354.6976957309.689944152
    7
    WSEI -> WETH210606692262125045.3361451289.584049634
    8
    WETH -> WSEI173752818158448811.9041381328.933277267
    9
    USDC -> WBTC158279230258007353.9031607366.115588886
    10
    USDC -> WETH138517164757249107.3218466411.145316618
    10
    610B
    5s