COUNT(DISTINCT CASE WHEN e.event_type = 'Stake' THEN t.authorizers[0] ELSE NULL END) AS total_stakers,

COUNT(DISTINCT CASE WHEN e.event_type = 'Unstake' THEN t.authorizers[0] ELSE NULL END) AS total_unstakers

FROM

flow.core.fact_events e

JOIN flow.core.fact_transactions t USING (tx_id)

WHERE

e.event_contract = 'A.d6f80565193ad727.LiquidStaking'

AND t.TX_SUCCEEDED

AND t.block_timestamp::date >= '2022-10-10'

AND (e.event_type = 'Stake' OR e.event_type = 'Unstake');