-- forked from Popex404 / General Metrics Blocks @ https://flipsidecrypto.xyz/Popex404/q/untitled-query-43w0B3
select
count(distinct Block_ID) as "Total Blocks",
cast(MIN(block_timestamp) AS date) AS "First Date of Block",
count(distinct Proposer_address) as "Number of Total Proposers"
from
cosmos.core.fact_blocks