staked AS (

SELECT

DATE_TRUNC('week', fe.block_timestamp) AS date,

SUM(CASE WHEN event_type = 'Stake' THEN fe.event_data:flowAmountIn ELSE 0 END) AS flow_staked,

SUM(CASE WHEN event_type = 'Unstake' THEN fe.event_data:lockedFlowAmount ELSE 0 END) AS flow_unstaked

FROM

flow.core.fact_events

WHERE

event_contract = 'A.d6f80565193ad727.LiquidStaking'

AND fe.tx_succeeded

AND fe.block_timestamp::DATE >= '2022-10-10'

AND fe.event_type IN ('Stake', 'Unstake')

GROUP BY

DATE_TRUNC('week', fe.block_timestamp)

),

cumulative AS (

SELECT

date,

ROUND(COALESCE(flow_staked, 0), 2) AS volume_staked,

ROUND(COALESCE(flow_unstaked, 0), 2) AS volume_unstaked,

ROUND(COALESCE(flow_staked, 0) - COALESCE(flow_unstaked, 0), 2) AS netflow_volume

FROM

staked

)

SELECT

date,

volume_staked,

volume_unstaked,

netflow_volume,

SUM(netflow_volume) OVER (ORDER BY date) AS liquid_staked_volume

FROM

cumulative

WHERE

date < TRUNC(CURRENT_DATE, 'week')

ORDER BY