Datasets
Blockchain tables over S3, queried with your own project credentials.
blocks
Ethereum · s3://eth/blocks · 31 columns. Partitioned by UTC day as date=YYYY-MM-DD. Read through the Delta log and filter by date.
The EVM tables use fireparq v1.0.3's published schema. Types match the Delta files: string (hex) contains 0x-prefixed bytes and date is the partition column. Examples are historical rows from date=2026-10-01 in the earlier riv-dev1 lake's ethbucket; they do not indicate the current gateway's coverage. Hover a value to see it whole.
blocks 31 columns BASE
| 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 |
Try It
Filter by date or block range, calculate the estimated read price, and browse active files to inspect their schema and preview rows. Ethereum is backfilling from genesis; recent dates may not be available yet.
Ethereum eth
blocks
Opening this section sends no dataset reads. Browse table loads metadata; row previews require a separate click.
Connect with DuckDB, Python, AWS CLI or Node.js using your project credentials.