all_val as (

select

rank,

label as validator,

address,

delegator_shares / pow(10, 6) as vote_power,

raw_metadata:commission:commission_rates:rate as com_rate,

self_delegation,

num_delegators,

max_change_rate,

max_rate,

commission_rate_last_updated,

status,

num_governance_votes as votes_cast

from

cosmos.core.fact_validators

order by

rank asc

),

adjusted as (

select

rank,

validator,

address,

vote_power,

com_rate * 100 as commission_rt,

com_rate as com_rate_decimal,

self_delegation,

num_delegators,

max_change_rate,

max_rate,

commission_rate_last_updated,

status,

votes_cast

from