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;

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)