select concat(SOURCE_CHAIN,'➡',DESTINATION_CHAIN) as path

,sum(AMOUNT_USD) as volume

,count(distinct TX_HASH) as bridges

from near.defi.ez_bridge_activity

where BLOCK_TIMESTAMP::date>=current_date-30

and PLATFORM='rainbow'

and TX_HASH not in ('HaK2Rft7UzAqHk3CHscWnEeWW8Hisupqtfe7zf82GRLD') --wrong BRRR price

group by 1

order by 2 desc