select

block_timestamp::date as day

,count (DISTINCT DELEGATOR_ADDRESS) as wallet

,sum(case

when ACTION='delegate' or ACTION='redelegate' then AMOUNT/pow(10,decimal)

when ACTION='undelegate' then -1*AMOUNT/pow(10,decimal)

else 0

end) as amount_stake

,sum(wallet) over (order by day) as growth_wallet

,sum(amount_stake) over (order by day) as growth_amount

from osmosis.core.fact_staking

where block_timestamp::date >='2022-01-01'

and TX_STATUS='SUCCEEDED'

group by 1

order by 1

select * from lst_staker