blocks
Schema: public
Description
The blocks table contains high-level metadata about each block we've ingested.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| id | bpchar(44) | The unique identifier for the block. |
| block_time | timestamptz | The timestamp of the block. |
| block_hash | text | The unique hash of the block. |
| block_number | numeric | The number of the block. |
| chain | text | The blockchain this block belongs to. |
Example
Get block count over the past day for Avalanche
select count(1) block_count
from blocks
where block_time > now() - '1 day'::interval
and chain = 'avalanche';