SELECT CAST(CAST(date AS TIMESTAMP) AS DATE) as date FROM (

DATEADD(DAY, SEQ4(), '2024-02-01 00:00:00') AS date

TABLE(GENERATOR(ROWCOUNT => 1000))

) x

WHERE date <= CURRENT_DATE

),

stakedBalance as (

SELECT date_trunc('day',block_timestamp) as date,

index_user,

SUM(SUM(CASE WHEN action = 'Staked' THEN amount ELSE -amount END)) OVER (partition by index_user ORDER BY date_trunc('day',block_timestamp)) as cumulative_balance

FROM (

SELECT block_timestamp,block_number,

topics[2] as index_user,

(utils.udf_hex_to_int(data)::int)/1e18 as amount,

CASE WHEN LOWER(topics[0]) = LOWER('0x99039fcf0a98f484616c5196ee8b2ecfa971babf0b519848289ea4db381f85f7') THEN 'Staked' ELSE 'Unstaked' END as action

FROM blast.core.fact_event_logs

WHERE LOWER(contract_address) = LOWER('0xE1784da2b8F42C31Fb729E870A4A8064703555c2')

AND (LOWER(topics[0]) = LOWER('0x99039fcf0a98f484616c5196ee8b2ecfa971babf0b519848289ea4db381f85f7')

OR LOWER(topics[0]) = LOWER('0x2cbcd809a4c90d11f8d12c4b6d09986b255ae1e68f54f076c145fbb2185904e1'))

) x

GROUP BY 1,2

),

setLeadData AS (

SELECT

*,

LEAD(date, 1, CURRENT_TIMESTAMP()) OVER (PARTITION BY index_user ORDER BY date) AS latest_day

FROM

stakedBalance

),

getETHPrice as (