SELECT DISTINCT

tx_id,

block_timestamp

FROM sei.core.fact_msg_attributes

WHERE attribute_key = '_contract_address'

AND attribute_value IN (

'sei1e3gttzq5e5k49f9f5gzvrl0rltlav65xu6p9xc0aj7e84lantdjqp7cncc',

'sei1swe2fy3t49j2c2xl8l64ldjaqyr6khmaya60pl5kr4em2v2jp0ysa3xjum'

)

AND tx_succeeded = 'true'

AND block_timestamp::Date >= '2024-01-15'

),

burn_amt AS (

SELECT

b.tx_id,

b.block_timestamp,

(a.attribute_value / POW(10, 6)) AS burn_amount,

fee.attribute_value as fee_payer

FROM base_txs b

JOIN sei.core.fact_msg_attributes a

ON b.tx_id = a.tx_id

JOIN sei.core.fact_msg_attributes fee

ON b.tx_id = fee.tx_id AND fee.attribute_key = 'fee_payer'

WHERE a.attribute_key IN ('utoken_refunded', 'unbonded_amount')

),

mint_amt AS (

SELECT

b.tx_id,

b.block_timestamp,

(a.attribute_value / POW(10, 6)) AS mint_amount,

fee.attribute_value as fee_payer

FROM base_txs b

JOIN sei.core.fact_msg_attributes a