COUNT(*) AS transactions,

COUNT(DISTINCT SIGNER_ID) AS users,

SUM(AMOUNT) AS amount

FROM near.gov.fact_staking_actions

WHERE ADDRESS = 'meteor.poolv1.near'

AND ACTION = 'unstaking'

AND BLOCK_TIMESTAMP::date >= current_date-30