with validators as (

select

distinct LABEL as validator_name,

from cosmos.core.fact_msg_attributes a

join cosmos.core.fact_validators v on a.ATTRIBUTE_VALUE=v.ADDRESS

where msg_type = 'delegate'

and attribute_key = 'validator'

and LABEL_SUBTYPE = 'validator'

and tx_succeeded = 'TRUE'),

volumes as (

select tx_id,

block_timestamp,

split(ATTRIBUTE_VALUE,'uatom')[0]::numeric/1e6 as Delegate_Amount

from cosmos.core.fact_msg_attributes

where msg_type = 'delegate'

and attribute_key = 'amount'

and tx_id in (select tx_id from validators)),

delegators as (

select tx_id,

block_timestamp,

attribute_value as Delegator

from cosmos.core.fact_msg_attributes

where msg_type = 'coin_spent'

and attribute_index = '0'

and attribute_key = 'spender'

and msg_index = '0'

and tx_id in (select tx_id from validators)),

Per_final as (

select a.tx_id,

b.block_timestamp,