SYMBOL as token,

count(a.tx_hash) as no_txn,

sum(AMOUNT_USD) as volume

from ethereum.core.fact_transactions a join ethereum.core.ez_token_transfers b on a.tx_hash=b.tx_hash

where substring(a.INPUT_DATA, 202, 1)='1'

and a.ORIGIN_FUNCTION_SIGNATURE in ('0x9981509f','0x0f5287b0') -- Ethereum to Solana

and a.TO_ADDRESS='0x3ee18b2214aff97000d974cf647e7c347e8fa585'

and a.STATUS='SUCCESS'

and a.BLOCK_TIMESTAMP>=CURRENT_DATE-90

group by 1 having volume is not null

order by 2 desc limit 10