select

delegator_address,

sum(amount/1e6) as delegate_amount

from osmosis.core.fact_staking

where tx_status = 'SUCCEEDED'

and action = 'delegate'

group by delegator_address

order by delegate_amount desc

),

undelegate_action as (

select

delegator_address,

sum(amount/1e6) as undelegate_amount

from osmosis.core.fact_staking

where tx_status = 'SUCCEEDED'

and action = 'undelegate'

group by delegator_address

order by undelegate_amount desc

),

whales_list as (

select

delegator_address,

case

when undelegate.undelegate_amount is not null then delegate.delegate_amount - undelegate.undelegate_amount

else delegate.delegate_amount

end as staking_amount

from delegate_action delegate

left join undelegate_action undelegate using(delegator_address)

order by staking_amount desc

limit 20

),

swap_by_whales as (

select

block_timestamp::date as days,

count(distinct tx_id) as number_of_swap