NFT
Wallets
Data Transformations
- Data Transformations Overview
- Filter Data Sources
- Filters
- Workflows
Chains
Deep Dives
Blocks
Blocks are the building blocks of blockchains and rollups.
A block contains transactions which will alter the state of an EVM system incrementally. Transaction within a block can only be executed one after the other, not in parallel.
Query blocks data by timestamp, block number
select * from monad_testnet.blocks where number = 17783260;
Query blocks data by timestamp, block number
select * from monad_testnet.blocks where number = 17783260;
Coming Soon
Table Columns
Table "monad_testnet.blocks"
Column | Type | Collation | Nullable | Default
-------------------+-----------------------------+-----------+----------+---------
timestamp | timestamp without time zone | | |
number | numeric(38,0) | | |
hash | character varying(66) | | not null |
parent_hash | character varying(66) | | |
nonce | character varying(42) | | |
sha3_uncles | character varying(66) | | |
logs_bloom | text | | |
transactions_root | character varying(66) | | |
state_root | character varying(66) | | |
receipts_root | character varying(66) | | |
miner | character varying(42) | | |
mix_hash | character varying(66) | | |
difficulty | numeric(38,0) | | |
total_difficulty | character varying | | |
size | numeric(38,0) | | |
extra_data | text | | |
gas_limit | numeric(38,0) | | |
gas_used | numeric(38,0) | | |
transaction_count | numeric(38,0) | | |
base_fee_per_gas | numeric(38,0) | | |
_metadata | jsonb | | |
_extra_fields | jsonb | | |
_created_at | character varying | | |
_updated_at | character varying | | |
Indexes:
"blocks_pk" PRIMARY KEY, btree (hash)
"blocks_number_uindex" UNIQUE, btree (number DESC)
"blocks_timestamp_index" btree ("timestamp" DESC)
On this page