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 -> USDC66451463446429698965.400841615.935767937
    2
    USDC -> WSEI68060563779428506211.536066596.613361907
    3
    WSEI -> USDT45386618938126382323.276593275.995159094
    4
    USDT -> WSEI43979619969124824979.56969282.069951031
    5
    WSEI -> fastUSD306985351091560875.1293523292.718474174
    6
    fastUSD -> WSEI281696330689811974.0993185312.395994697
    7
    WSEI -> WETH219756715872102136.656701303.623739459
    8
    WETH -> WSEI182098834068278788.3166086341.687793085
    9
    USDC -> WETH150551187666826840.2037099419.603170899
    10
    WETH -> USDC145192185966056714.8141017429.302104465
    10
    609B
    6s