DATE_TRUNC('DAY', block_timestamp) AS transaction_date,

COUNT(DISTINCT tx_id) AS "daily stakes",

SUM(amount) AS "staked amount"

FROM

flow.gov.ez_staking_actions

WHERE

block_timestamp >= '2024-11-27'

AND block_timestamp < '2024-12-04'

AND action = 'DelegatorTokensCommitted'

GROUP BY

transaction_date

ORDER BY

transaction_date;