WITH raw_data AS
(SELECT *
FROM near.core.dim_staking_actions
where action = 'Stake'
-- FROM near.core.fact_receipts
-- WHERE receiver_id ='bflame.poolv1.near'
-- AND array_size(logs) > 0
ORDER BY block_timestamp DESC)
SELECT DATE_TRUNC('day',block_timestamp) AS days, COUNT(tx_hash) AS tx_count
FROM raw_data
GROUP BY days