(

SELECT

ORIGIN_FROM_ADDRESS AS owner,

CONCAT('0x', SUBSTRING(TOPICS [2], 27)) AS clone

from

blast.core.fact_event_logs

WHERE

CONTRACT_ADDRESS = '0x642219e70ab67a955d15f2a12a1caa2f23faa0b1'

AND ORIGIN_FUNCTION_SIGNATURE = '0xe4de98b5'

AND TX_STATUS = 'SUCCESS'

AND length(TOPICS) > 208

ORDER BY

BLOCK_TIMESTAMP ASC

)

),

totalStaked AS (

(

SELECT

SUM(VALUE) AS totalStaked

FROM

blast.core.fact_transactions

WHERE

TO_ADDRESS IN(

SELECT

clone

FROM

clones

)

AND ORIGIN_FUNCTION_SIGNATURE = '0x3a4b66f1'

AND STATUS = 'SUCCESS'

)

),

totalUnstaked AS (

(

SELECT