Afonso_DiazTop Token pairs
    Updated 1 day 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: 1 day ago
    TOKEN_PAIR
    SWAPS
    SWAPPERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    USDC -> WSEI68060563779428506211.536066596.613361907
    2
    WSEI -> USDC66451463446429698965.400841615.935767937
    3
    WSEI -> USDT45386618938126382323.276593275.995159094
    4
    USDT -> WSEI43979619969124824979.56969282.069951031
    5
    iSEI -> WSEI3480955122034770911.904206397.623111965
    6
    WSEI -> iSEI3284582981652087167.6160996154.684341304
    7
    WSEI -> fastUSD306985351091560875.1293523292.718474174
    8
    fastUSD -> WSEI281696330689811974.0993185312.395994697
    9
    USDC -> USDT2295101478639937425.9318787173.335760647
    10
    WSEI -> WETH219756715872102136.656701303.623739459
    10
    611B
    4s