date_trunc('day', block_timestamp) as date,

count(distinct validator_hash) as validators,

count(distinct block_id) as blocks,

count(distinct proposer_address) as proposers,

sum(blocks) over (order by date) as cumulative_blocks

from lava.core.fact_blocks

where block_timestamp::date >= '2024-07-30'

group by 1

order by 1