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 optimism.blocks where number = 1

​
Table Columns

                                                        Table "evm.blocks"

      Column       |            Type             | Collation | Nullable | Default | Storage  | Compression | Stats target | Description

-------------------+-----------------------------+-----------+----------+---------+----------+-------------+--------------+-------------

 timestamp         | timestamp without time zone |           |          |         | plain    |             |              |

 number            | bigint                      |           |          |         | plain    |             |              |

 hash              | character varying(66)       |           | not null |         | extended |             |              |

 parent_hash       | character varying(66)       |           |          |         | extended |             |              |

 nonce             | character varying(42)       |           |          |         | extended |             |              |

 sha3_uncles       | character varying(66)       |           |          |         | extended |             |              |

 logs_bloom        | text                        |           |          |         | extended |             |              |

 transactions_root | character varying(66)       |           |          |         | extended |             |              |

 state_root        | character varying(66)       |           |          |         | extended |             |              |

 receipts_root     | character varying(66)       |           |          |         | extended |             |              |

 miner             | character varying(42)       |           |          |         | extended |             |              |

 difficulty        | numeric(38,0)               |           |          |         | main     |             |              |

 total_difficulty  | numeric(38,0)               |           |          |         | main     |             |              |

 size              | bigint                      |           |          |         | plain    |             |              |

 extra_data        | text                        |           |          |         | extended |             |              |

 gas_limit         | bigint                      |           |          |         | plain    |             |              |

 gas_used          | bigint                      |           |          |         | plain    |             |              |

 transaction_count | bigint                      |           |          |         | plain    |             |              |

 base_fee_per_gas  | bigint                      |           |          |         | plain    |             |              |

 _created_at       | timestamp without time zone |           |          |         | plain    |             |              |

 _updated_at       | timestamp without time zone |           |          |         | plain    |             |              |

Indexes:

    "blocks_pk" PRIMARY KEY, btree (hash)

    "blocks_number_uindex" UNIQUE, btree (number DESC)

    "blocks_timestamp_index" btree ("timestamp" DESC)