-- forked from DebtLock Release @ https://flipsidecrypto.xyz/edit/queries/5b39a95c-a23b-4df5-b5bc-022db8490a78

with snxStaker as (

select row_number() over (partition by user_address order by block_number DESC) as acctIndex, * from ethereum.synthetix.ez_snx_staking

, snaxPrice as (

SELECT decoded_log:current *1e-8 AS snx_price

FROM ethereum.core.ez_decoded_event_logs

WHERE contract_address = '0x06ce8be8729b6ba18dd3416e3c223a5d4db5e755'

AND event_name = 'AnswerUpdated'

ORDER BY block_timestamp desc

limit 1

, sdsPrice as (

SELECT decoded_log:current *1e-27 AS sds_price

FROM ethereum.core.ez_decoded_event_logs

WHERE contract_address = '0xc7bb32a4951600fbac701589c73e219b26ca2dfc'

AND event_name = 'AnswerUpdated'

ORDER BY block_timestamp DESC

limit 1

, release_base as (

select

block_timestamp

, ss.snx_balance as current_SNX

, (snx_balance + escrowed_snx_balance) as current_SNX_with_escrow

, (snx_balance + escrowed_snx_balance) * SP.snx_price as snx_usd

, (sds_balance * sds.sds_price) as debt_usd