with lst_amount as (

select

ATTRIBUTE_INDEX

,msg_index

,tx_id

,msg_group

,split(ATTRIBUTE_VALUE ,'uluna')[0]/1e6 as amount

from terra.core.fact_msg_attributes

where MSG_TYPE= 'delegate'

and ATTRIBUTE_KEY='amount'

and TX_SUCCEEDED=true

)

,validator_check as (

select

msg_group

,msg_index

,tx_id

from terra.core.fact_msg_attributes

where MSG_TYPE= 'delegate'

and ATTRIBUTE_KEY='validator'

and ATTRIBUTE_VALUE='terravaloper18vnm040mwk0d6plc60v5m9h2376gkcphknuwzs'

and TX_SUCCEEDED=true

)

,lst_wallet as (

select

tx_id

,TX_SENDER as wallet

from terra.core.fact_transactions

where TX_SUCCEEDED=true

)

select

block_timestamp::date as date

,m.tx_id