trunc(BLOCK_TIMESTAMP, 'd') as date,

ACTION,

COUNT(*) as n_txs,

COUNT(DISTINCT SIGNER_ID) as n_stakers,

SUM(CASE WHEN ACTION = 'staking' THEN AMOUNT ELSE -1 * AMOUNT END) AS net_staked_amt,

net_staked_amt/n_stakers avg_net_staked_per_user

FROM near.gov.fact_staking_actions

WHERE ADDRESS LIKE 'meteor%'

AND ACTION IN ('staking', 'unstaking')

GROUP by 1,2

ORDER by 1 DESC