select TX_HASH as hash

from bsc.core.fact_event_logs

where EVENT_NAME='Swap'

),

code2 as (

select

TX_HASH, ORIGIN_FROM_ADDRESS, EVENT_INPUTS:value,

case when EVENT_INPUTS:to=ORIGIN_FROM_ADDRESS then 'Swap To TRIAS'

when EVENT_INPUTS:from=ORIGIN_FROM_ADDRESS then 'Swap From TRIAS' end as type

from bsc.core.fact_event_logs

where EVENT_NAME='Transfer'

and CONTRACT_ADDRESS='0xa4838122c683f732289805fc3c207febd55babdd'

and TX_STATUS='SUCCESS'

and TX_HASH!='0xf732a4209de88a9322c075740f17dced683ff35eb7720749a4f3ceb7663281b1'

and TX_HASH!='0x253c00318e374d5c8dc83bca892d59f216700e0c7774c9d73b81ff04c8de515a'

and (EVENT_INPUTS:to=ORIGIN_FROM_ADDRESS or EVENT_INPUTS:from=ORIGIN_FROM_ADDRESS )

and TX_HASH in (select hash from swap)

),

assets AS( select case when b.type='Swap From TRIAS' then a.CONTRACT_ADDRESS end as asset_in,

count (distinct a.TX_HASH) as TX

from bsc.core.fact_token_transfers a join code2 b on a.TX_HASH=b.TX_HASH

where a.CONTRACT_ADDRESS is not NULL

and a.CONTRACT_ADDRESS!='0xa4838122c683f732289805fc3c207febd55babdd'

group by 1

order by 2 DESC

limit 10

)

select asset_in, TX, CASE when asset_in='0xe9e7cea3dedca5984780bafc599bd69add087d56' then 'BUSD'

when asset_in='0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c' then 'BNB'

when asset_in='0x55d398326f99059ff775485246999027b3197955' then 'BUSC'

when asset_in='0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d' then 'USDC'

when asset_in='0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82' then 'Cake'

when asset_in='0x2170ed0880ac9a755fd29b2688956bd959f933f8' then 'ETH'

when asset_in='0x167fcfed3aad2d11052fcde0cbf704d879939473' then 'GEON '

when asset_in='0x0000000000004946c0e9f43f4dee607b0ef1fa1c' then 'CHI '