SYMBOL_IN as symbol_to ,

SYMBOL_OUT as symbol_from ,

sum(AMOUNT_IN_USD) as fund_usd_in,

CONTRACT_ADDRESS ,

POOL_NAME

-- count(TX_HASH) as number_of_transaction,

--sum(AMOUNT_OUT_USD),SENDER,TX_TO

from ethereum.sushi.ez_swaps

--where CONTRACT_ADDRESS = '0XCD7BF80CD53484D91E2C4E30A46DB1D69EDF2E9D'

where SYMBOL_OUT = 'THOR'

AND SYMBOL_IN = 'WETH'

--AND SENDER = '0xa5f2211B9b8170F694421f2046281775E8468044'

GROUP by 1,2,3,6,5--,8,9

order by 3 desc