AzinTokens that swaped to stable coins
    Updated 2024-11-30
    with t1 as
    (select
    *
    from
    sei.core.dim_tokens
    where
    (SYMBOL like 'us%'
    OR
    SYMBOL like 'US%'
    OR
    SYMBOL like 'Us%'
    OR
    SYMBOL like 'uS%')
    and
    SYMBOL not in ('USDX','USEDCAR','usei','USEI','USK','USTC','USTRD')
    )
    ,
    t2 as
    (select
    TOKEN_NAME as token_name1,
    SYMBOL as symbol1,
    AMOUNT_IN/pow(10,DECIMALS) as value1 ,
    date_trunc('day',BLOCK_TIMESTAMP) as date ,
    PLATFORM,
    SWAPPER,
    AMOUNT_OUT,
    CURRENCY_OUT,
    POOL_ADDRESS
    from

    sei.defi.fact_dex_swaps a left join sei.core.dim_tokens b
    on a.CURRENCY_IN=b.CURRENCY)
    ,
    swap as
    (select
    token_name1,