SYMBOL_IN as symbol_to ,

SYMBOL_OUT as symbol_from ,

sum(AMOUNT_IN) as fund_in,

CONTRACT_ADDRESS ,

POOL_NAME

--sum(AMOUNT_out_USD) as fund_usd_out

-- 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 AMOUNT_out_USD IS NULL

--AND SENDER = '0xa5f2211B9b8170F694421f2046281775E8468044'

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

order by 4 desc