SELECT

date_trunc('day', block_timestamp) AS day,

SUM(attribute_value / 10e5) AS SEI_bonded

FROM

sei.core.fact_msg_attributes

WHERE

msg_type = 'wasm-silohub/bonded'

AND ATTRIBUTE_KEY = 'token_bonded'

GROUP BY

day

),

CTE_2 AS (

SELECT

date_trunc('day', block_timestamp) AS day_unbond,

SUM(attribute_value / 10e5) AS SEI_unbonded

FROM

sei.core.fact_msg_attributes

WHERE

msg_type = 'wasm-silohub/unbond_queued'

AND ATTRIBUTE_KEY = 'ustake_to_burn'

GROUP BY

day_unbond

SELECT

a.day,

SUM(a.cumulative_SEI_bonded - b.cumulative_SEI_unbonded) AS net_SEI

FROM

(SELECT

day,

SUM(SEI_bonded) OVER (ORDER BY day ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_SEI_bonded

FROM

CTE_1) a

LEFT JOIN

(SELECT

day_unbond,