(select receiver ,sum(amount/pow(10,decimal)) as am_in

from

osmosis.core.fact_transfers

where currency like '%uosmo%'

group by 1)

, amount_send as

(select sender,sum(amount/pow(10,decimal)) as am_out

from osmosis.core.fact_transfers

where currency like '%uosmo%'

group by 1)

,Whales as (select (am_in-am_out) as total,sender

from amount_receive

inner join amount_send

on sender=receiver

where total>50000 )

select count(1),to_date(block_timestamp::date) from osmosis.core.fact_swaps

where trader not in (select sender from Whales)

group by 2