Raw Blocks
Chain
OptimismDataset name
optimism.raw_blocksVersion
1.1.0Description
Metadata for each block on the chain including hashes, transaction count, difficulty, and gas used.
Example data
| id | number | hash | parent_hash | nonce | sha3_uncles | logs_bloom | transactions_root | state_root | receipts_root | miner | difficulty | total_difficulty | size | extra_data | gas_limit | gas_used | timestamp | transaction_count | base_fee_per_gas | withdrawals_root |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| block_0xe5383a7bdca4eff973a6b43ca9ebc19778556b39ecb668b789b88db4772550e8_0 | 108403117 | 0xe5383a7bdca4eff973a6b43ca9ebc19778556b39ecb668b789b88db4772550e8 | 0x9459f67c60c252bc91e3765b362262e5f4b0ead2ba4919fa1646a0abdf04e541 | 0x0000000000000000 | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0x00004000440100000000008020040000000000800000020000040010044220000410000000040200080000100400400000000040000000000100000000e020400000402000000008280000080000000020840000004000000004000000100010000400000004000000400000000100010000000000000402a00000100000000c80000000030800000000020048000000020010008020400012000201080000000600114884000000000000c000000400000400000000000000800008000001004400000208000000000000070000020000a000000008020040000002000000000010000180010080801000800080010000000000008000000000080000010000 | 0x1f40b46a12d81dd601ce0eb0cec404f45ac92703d05ee86ed9adc1ef6c87c0c0 | 0xe8751d74cafcaf760e84b2fca4332d8a41b865268443eeca4a873f397d209b87 | 0x29023498de661937148caaf82f303c6a685a2cadddb7244541f67e7167afb017 | 0x4200000000000000000000000000000000000011 | 0 | 0 | 2861 | 0x | 30000000 | 722940 | 1692405011 | 6 | 54 | null |
| block_0x63c533f3c6f8c057a8532a04fffaf2ddc0351b53256935567795fe7cec218e66_0 | 108403487 | 0x63c533f3c6f8c057a8532a04fffaf2ddc0351b53256935567795fe7cec218e66 | 0x3ff790b7f5bbe858bae8cd8d1855902d2c33c6ba1fd54bb7e6d0a9fa733d6edf | 0x0000000000000000 | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0x0600800809002111000080c08000c2020000142004090000002c22000001a02004081000008006018023481100300809481230482207a01290b843a000e0006100106820089000092380001c8280201c24801002504001000400098004004200130000a10a0c040480c00002000019800020100020208483020c40d0288e0205048210080b00000201100600064000400301100087a54010400000400820101506a0025002000204284c000400028082300000048389100200901260306040e160000003080004080001000600500200948000002000030180248002000830000010810980a6150044000025006001082340408840d220100210502040030051 | 0xd3cd350eabd33238141e7cb9878eacf6095b88fb58dd296d9f704529741ef7dc | 0x9014b853e86da8e9712407c4765a46355a18f59cd0b9eb542e5da9ba85557fc2 | 0xeab555f6f14bd07e23f9a9eb7d3720817d61841862718bbc0a4f9885d9deedc2 | 0x4200000000000000000000000000000000000011 | 0 | 0 | 8397 | 0x | 30000000 | 6963069 | 1692405751 | 18 | 122 | null |
| block_0xb11a34916859a15f22004d5ca880805d65bf96392bbfb56890cc15f394329305_0 | 499 | 0xb11a34916859a15f22004d5ca880805d65bf96392bbfb56890cc15f394329305 | 0x82b68862caa77f62813f06e9dd61812ca0d8e634aac09c105815a9c9c6cf00de | 0x0000000000000000 | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | 0x72b9643a27145b6541db7653d7837f366311dcd605bd3841f918ba8c77f6fc52 | 0xd3f4326e796fe7eda01d0189ca81cc36028887f95a07684ba1a32a7c0d36bf39 | 0x5fe5f2191c6eb46d5470546dde61595f7f9060e9803a255b90191039c77f42b8 | 0x0000000000000000000000000000000000000000 | 2 | 999 | 784 | 0xd98301090a846765746889676f312e31352e3133856c696e7578000000000000f84e5e21e97f602239774361d0734cb295fd1d42aaf4e8c88794525190edcd80236819de4b1ed732ab0bf7c40989399108bf170cbae1cd967225558bc4aed73400 | 15000000 | 40743 | 1636672903 | 1 | null | null |
Schema
| Column | Type |
|---|---|
| id | string |
| number | long |
| hash | string |
| parent_hash | string |
| nonce | string |
| sha3_uncles | string |
| logs_bloom | string |
| transactions_root | string |
| state_root | string |
| receipts_root | string |
| miner | string |
| difficulty | double |
| total_difficulty | double |
| size | long |
| extra_data | string |
| gas_limit | long |
| gas_used | long |
| timestamp | long |
| transaction_count | long |
| base_fee_per_gas | long |
| withdrawals_root | string |