SELECT

tx_hash,

block_number,

block_timestamp,

contract_address,

event_name,

decoded_log:account :: VARCHAR AS "Wallet Address",

0 AS "Merged Escrowed Amount",

(

CASE

WHEN event_name = 'Burn' THEN -1 * decoded_log:amount :: NUMBER * 1e-18

WHEN event_name = 'Mint' THEN decoded_log:amount :: NUMBER * 1e-18

END

) AS "Minted Amount",

SUM("Minted Amount") OVER (

PARTITION BY "Wallet Address"

ORDER BY

block_timestamp,

event_index

) AS "SDS Balance",

event_index

FROM

optimism.core.ez_decoded_event_logs

WHERE

contract_address = '0x45c55bf488d3cb8640f12f63cbedc027e8261e79'

AND event_name IN ('Burn', 'Mint')

AND "Minted Amount" != 0

),

account_merge AS (

SELECT

tx_hash,

block_number,

block_timestamp,

contract_address,

event_name,