Block Schemas
Parquet table definitions from firehose-parquet
The tables of every EVM network in the lake, generated from fireparq v1.0.3's published schema. Types are the Delta types of the data files; string (hex) holds binary values as 0x-prefixed hex, and date is the partition column. Examples are a recent row of each table in s3://eth; hover a value to see it whole.
▶blocks31 columnsBASE
| Column | Type | Nullable | Example |
|---|---|---|---|
| block_num26093738 | long | required | 26093738 |
| block_id0x41ebfe304393a8d19fb0b8273a5fa88573cc9a1962a6b8645d139a1d4f860edb | string (hex) | required | 0x41ebfe304393a8d19fb0b8273a5fa88573cc9a1962a6b8645d139a1d4f860edb |
| parent_num26093737 | long | required | 26093737 |
| parent_id0xcd26204e996dceb606ccf0bc6f5bf8ea6747a471df8be73b5855f01624d5d743 | string (hex) | required | 0xcd26204e996dceb606ccf0bc6f5bf8ea6747a471df8be73b5855f01624d5d743 |
| lib_num26093659 | long | required | 26093659 |
| timestamp2026-10-01T00:00:11.000Z | timestamp | required | 2026-10-01T00:00:11.000Z |
| date2026-10-01 | date (partition) | required | 2026-10-01 |
| number26093738 | long | required | 26093738 |
| hash0x41ebfe304393a8d19fb0b8273a5fa88573cc9a1962a6b8645d139a1d4f860edb | string (hex) | required | 0x41ebfe304393a8d19fb0b8273a5fa88573cc9a1962a6b8645d139a1d4f860edb |
| parent_hash0xcd26204e996dceb606ccf0bc6f5bf8ea6747a471df8be73b5855f01624d5d743 | string (hex) | required | 0xcd26204e996dceb606ccf0bc6f5bf8ea6747a471df8be73b5855f01624d5d743 |
| gas_used228073 | long | required | 228073 |
| gas_limit60000000 | long | required | 60000000 |
| base_fee_per_gas66894921 | string | nullable | 66894921 |
| coinbase0xc13ced137e90bc695cb77288962280516a2f9b8b | string (hex) | required | 0xc13ced137e90bc695cb77288962280516a2f9b8b |
| size1927 | long | required | 1927 |
| nonce0 | decimal(20,0) | required | 0 |
| state_root0x37ac65de0c73edcaf8958cd372470d652631158812cfc77f4652031135efd5f4 | string (hex) | required | 0x37ac65de0c73edcaf8958cd372470d652631158812cfc77f4652031135efd5f4 |
| transactions_root0x6cd0fc42a9cea3c4e0957af5a2e309c5baeb59eab867bb1e922813e0e6fbbc78 | string (hex) | required | 0x6cd0fc42a9cea3c4e0957af5a2e309c5baeb59eab867bb1e922813e0e6fbbc78 |
| receipt_root0xae52e8f1005cf3126457b6d853a98f65e30e5e083ef43300d1e62ee1830d06ec | string (hex) | required | 0xae52e8f1005cf3126457b6d853a98f65e30e5e083ef43300d1e62ee1830d06ec |
| difficulty0 | string | nullable | 0 |
| mix_hash0x686588ec9af08045205596e580e171e19b94599326ff373b326c385da9efe445 | string (hex) | required | 0x686588ec9af08045205596e580e171e19b94599326ff373b326c385da9efe445 |
| extra_data0x4d6576526566756e64202d20312c204261642067757973202d2030 | string (hex) | required | 0x4d6576526566756e64202d20312c204261642067757973202d2030 |
| num_transactions2 | long | required | 2 |
| detail_levelEXTENDED | string | required | EXTENDED |
| uncle_hash0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 | string (hex) | required | 0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347 |
| logs_bloom0x0020000000000000002000000000000000040000002000000000000000000000000000000000000000000000000000… | string (hex) | required | 0x0020000000000000002000000000000000040000002000000000000000000000000000000000000000000000000000… |
| withdrawals_root0xf3cf5c1f5d7833907e8839afbc5154b7ba90e636c2c4bea3f74f3a6e6ad498f7 | string (hex) | nullable | 0xf3cf5c1f5d7833907e8839afbc5154b7ba90e636c2c4bea3f74f3a6e6ad498f7 |
| blob_gas_used0 | long | nullable | 0 |
| excess_blob_gas176551452 | long | nullable | 176551452 |
| parent_beacon_root0x11f7b01bca1717ca90a000881beb00bc764842bdd4e703e20983c28c54bcff4b | string (hex) | nullable | 0x11f7b01bca1717ca90a000881beb00bc764842bdd4e703e20983c28c54bcff4b |
| requests_hash0xe3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855 | string (hex) | nullable | 0xe3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855 |
▶transactions35 columnsBASE
▶logs19 columnsBASE
▶withdrawals12 columnsBASE
▶access_lists13 columnsBASE
▶set_code_authorizations19 columnsBASE
▶calls30 columnsEXTENDED
▶balance_changes18 columnsEXTENDED
▶code_changes19 columnsEXTENDED
▶storage_changes18 columnsEXTENDED
▶nonce_changes17 columnsEXTENDED
▶gas_changes16 columnsEXTENDEDno rows yet
▶account_creations15 columnsEXTENDEDno rows yet
▶system_calls28 columnsEXTENDED
▶system_balance_changes14 columnsEXTENDED
▶system_code_changes15 columnsEXTENDEDno rows yet
▶system_storage_changes14 columnsEXTENDED
▶system_nonce_changes13 columnsEXTENDEDno rows yet
▶system_gas_changes13 columnsEXTENDEDno rows yet
▶system_account_creations11 columnsEXTENDEDno rows yet