select

block_timestamp,

tx_id

from sei.core.fact_msg_attributes

where attribute_value = 'sei1e3gttzq5e5k49f9f5gzvrl0rltlav65xu6p9xc0aj7e84lantdjqp7cncc'

and attribute_key = '_contract_address'

and msg_type IN ('wasm-silohub/bonded','wasm-silohub/unbonded_withdrawn')

and block_timestamp::date >= '2024-01-04'

and TX_SUCCEEDED

, bonded as (

select

date_trunc('day', a.block_timestamp) as date,

sum(attribute_value / 1e6) as bonded

from sei.core.fact_msg_attributes a

join all_txns using(tx_id, block_timestamp)

where a.msg_type = 'wasm-silohub/bonded'

and a.attribute_key = 'token_bonded'

and a.block_timestamp::date >= '2024-01-04'

group by 1

, withdraw as (

select

date_trunc('day', a.block_timestamp) as date,

sum(attribute_value / 1e6) as withdrawn

from sei.core.fact_msg_attributes a

join all_txns using(tx_id, block_timestamp)

where a.msg_type = 'wasm-silohub/unbonded_withdrawn'

and a.attribute_key = 'utoken_refunded'

and a.block_timestamp::date >= '2024-01-04'

group by 1

, prices as (

SELECT