SYMBOL,

abs(max(price-1)) as deviation

from ethereum.core.fact_hourly_token_prices

where SYMBOL in (select SYMBOL_IN from ethereum.sushi.ez_swaps )

and HOUR>=CURRENT_DATE-60

group by 1 having deviation < 0.05)

select

SYMBOL_IN,

count(tx_hash) as no_sell,

sum(AMOUNT_IN) as vol_sell

from ethereum.core.ez_dex_swaps

where PLATFORM='sushiswap'

and SYMBOL_IN in (select SYMBOL from st)

and SYMBOL_IN !='DSD'

group by 1