date(block_timestamp) as date,

min(block_id) as min_block_num,

max(block_id) as max_block_num,

count(distinct proposer_address) as realized_proposers,

sum(tx_count) as txns

from osmosis.core.fact_blocks

group by date

order by date asc