select

tx_id

from axelar.core.fact_msg_attributes

where MSG_TYPE= 'delegate'

-- and tx_id='E9D740AB850673A399EFBBF2118D9BEE3AF9D724AD5C162B4C2EAACA92859ADC'

and ATTRIBUTE_KEY ='validator'

and ATTRIBUTE_VALUE ='axelarvaloper19dx6vywgr62jtsxhhlhlgh7ug5vmgjnz6dkeud'

and TX_SUCCEEDED=true

,lst_stake_amount as (

select

tx_id

,ATTRIBUTE_VALUE/1e6 as amount

from axelar.core.fact_msg_attributes

where MSG_TYPE = 'delegate'

and ATTRIBUTE_KEY= 'new_shares'

and TX_SUCCEEDED=true

-- and tx_id='E9D740AB850673A399EFBBF2118D9BEE3AF9D724AD5C162B4C2EAACA92859ADC'

)

,lst_stake_wallet as (

select

tx_id

,ATTRIBUTE_VALUE as wallet

,MSG_INDEX

from axelar.core.fact_msg_attributes

where TX_SUCCEEDED=true

-- and tx_id='E9D740AB850673A399EFBBF2118D9BEE3AF9D724AD5C162B4C2EAACA92859ADC'

and MSG_TYPE = 'message'

and ATTRIBUTE_KEY= 'sender'

,lst_stake as (

select

block_timestamp::date as date