Raw Blocks
Chain
SophonDataset name
sophon.raw_blocksVersion
1.0.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 | size | extra_data | gas_limit | gas_used | timestamp | transaction_count | base_fee_per_gas | withdrawals_root | blob_gas_used | excess_blob_gas | difficulty | total_difficulty | withdrawals |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| block_v3_0x54da95dc098ea879da0fb1c898919e9f74a4e3db2280a3256c31abacc0aa67b5_0 | 40 | 0x54da95dc098ea879da0fb1c898919e9f74a4e3db2280a3256c31abacc0aa67b5 | 0xbd9784ddd4301199b1d4cdd84313f747b57e4642fec4a5302d7eb845372621e5 | 0x0000000000000000 | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0x00100000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100040000000008000000000000000000000000000000000080080000000000000000000000000000000000000000000000000800000010000000000000000002000000000004000000000000000000000000000000000000000000000000000000104000000000000000000000000000000000000000000020000000000002008000000000000000000000000000000008000000000000000000000000000800000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000 | 0 | 0x | 1125899906842624 | 86938 | 1729674927 | 1 | 3418355339200 | null | null | null | null | ||
| block_v3_0x37254ca9014b095eb50e27d28bb3cb62e430676c7aaef829edb183e88da46c08_0 | 43 | 0x37254ca9014b095eb50e27d28bb3cb62e430676c7aaef829edb183e88da46c08 | 0xf94b25c4ec600887c7a43b7a1e76acb0a517431cf53e6804951dd0cf354f3404 | 0x0000000000000000 | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0x00000000000400000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000008000040000000000000000000040000000000080000000000000000040000000000000000000000000020000000000010000100000000000000000000000004000000000000000000000000000000000000000000000000000000104000000000000000000000000000004000000000000020000000000002008000000000000000000000004000000000000000000000000000000000000800000000000000000000002000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000 | 0 | 0x | 1125899906842624 | 93704 | 1729677196 | 1 | 3418355339200 | null | null | null | null | ||
| block_v3_0x04b93ca04bfbdd0bec3ac15030ed8d455b35106909592d86e3a630b973cb8a23_0 | 45 | 0x04b93ca04bfbdd0bec3ac15030ed8d455b35106909592d86e3a630b973cb8a23 | 0x224561f68ad790d0e8991eb1694c2f509d658620f9ea43f19e619fa1c8f71edd | 0x0000000000000000 | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | 0x00000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040200000008000040000000000000000000000000000000080000000000000000000008000000000000000000000000000000000010000000000000000000000000000004000000000400000100002000000000000000000000000000000000104000000000800000000000040000000000002000010020000000000002008000000000000000000000000000000100000000000000000000000000000800000000000000000000000000000000400000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000 | 0 | 0x | 1125899906842624 | 167003 | 1729681874 | 1 | 2775278950400 | null | null | 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 |
| size | long |
| extra_data | string |
| gas_limit | long |
| gas_used | long |
| timestamp | long |
| transaction_count | long |
| base_fee_per_gas | long |
| withdrawals_root | string |
| blob_gas_used | long |
| excess_blob_gas | long |
| difficulty | decimal |
| total_difficulty | decimal |
| withdrawals | string |