Table description

Contains each validated block in the chain. block_timestamp is only available in this table, so you need to do an inner join on block_height to get block_timestamp to other tables.

Column Descriptions

ColumnDescriptionType
block_dateThe date of the block.date
block_heightThe height of the block, a unique identifier for each block.bigint
block_timestampTimestamp when the block was validated.timestamp(3) with time zone
chain_idThe ID of the chain where the block belongs.varchar
proposer_addressThe address of the validator proposing the block.varchar
validators_hashThe hash of the validators set for the block.varchar
updated_atTimestamp of when the record was last updated.timestamp(3) with time zone
ingested_atTimestamp of when the record was ingested into Dune.timestamp(3) with time zone

Table Sample