SELECT

SUM(event_data:flowAmountIn) AS Total_staked,

authorizers [0] AS Address

FROM

flow.core.fact_events

JOIN flow.core.fact_transactions USING (tx_id)

WHERE

event_contract = 'A.d6f80565193ad727.LiquidStaking'

AND event_type = 'Stake'

GROUP BY

Address

),

Unstake_flow AS (

SELECT

SUM(event_data:lockedFlowAmount) AS Total_unstaked,

authorizers [0] AS Address

FROM

flow.core.fact_events

JOIN flow.core.fact_transactions USING (tx_id)

WHERE

event_contract = 'A.d6f80565193ad727.LiquidStaking'

AND event_type = 'Unstake'

GROUP BY

Address

),

Total_net AS (

SELECT (

(SELECT SUM(Total_staked) AS "Total Staked" FROM Stake_flow) -

(SELECT SUM(Total_unstaked) AS "Total Unstaked" FROM Unstake_flow)

)

AS "Total Net"

Address,