Datasets
Blockchain tables over S3, queried with your own project credentials.
transactions
Ethereum · s3://eth/transactions · 35 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.
transactions 35 columns BASE
| Column | Type | Nullable | Example |
|---|---|---|---|
| block_num26093739 | long | required | 26093739 |
| block_id0xc5347886733970989a8027bec5d773bce9e1fdf156b0dd40acbcbec3dfefd251 | string (hex) | required | 0xc5347886733970989a8027bec5d773bce9e1fdf156b0dd40acbcbec3dfefd251 |
| parent_num26093738 | long | required | 26093738 |
| parent_id0x41ebfe304393a8d19fb0b8273a5fa88573cc9a1962a6b8645d139a1d4f860edb | string (hex) | required | 0x41ebfe304393a8d19fb0b8273a5fa88573cc9a1962a6b8645d139a1d4f860edb |
| lib_num26093659 | long | required | 26093659 |
| timestamp2026-10-01T00:00:23.000Z | timestamp | required | 2026-10-01T00:00:23.000Z |
| date2026-10-01 | date (partition) | required | 2026-10-01 |
| block_number26093739 | long | required | 26093739 |
| index193 | long | required | 193 |
| hash0x1e32c36797fe82c4b73b7609958b62878ef0046c633578f684b413f9af4edb27 | string (hex) | required | 0x1e32c36797fe82c4b73b7609958b62878ef0046c633578f684b413f9af4edb27 |
| from0xdaa526086787d9debe1d7f3ffdb1fe50cf8687f4 | string (hex) | required | 0xdaa526086787d9debe1d7f3ffdb1fe50cf8687f4 |
| to0xbd0d173eeb87d57a09521c24388a12789f33ba96 | string (hex) | required | 0xbd0d173eeb87d57a09521c24388a12789f33ba96 |
| value0 | string | required | 0 |
| gas_limit400000 | long | required | 400000 |
| gas_used144456 | long | required | 144456 |
| gas_price308596627 | string | nullable | 308596627 |
| typeBLOB | string | required | BLOB |
| statusSUCCEEDED | string | required | SUCCEEDED |
| nonce295082 | long | required | 295082 |
| input0x3e5aa08200000000000000000000000000000000000000000000000000000000000480ab0000000000000000000000… | string (hex) | required | 0x3e5aa08200000000000000000000000000000000000000000000000000000000000480ab0000000000000000000000… |
| max_fee_per_gas3181861700 | string | nullable | 3181861700 |
| max_priority_fee_per_gas250000000 | string | nullable | 250000000 |
| cumulative_gas_used54096603 | long | nullable | 54096603 |
| v0x01 | string (hex) | required | 0x01 |
| r0xe4db37fe4db02ee9c68d4a76d39fe5c1884b20936151288a9d545adaa9fc748f | string (hex) | required | 0xe4db37fe4db02ee9c68d4a76d39fe5c1884b20936151288a9d545adaa9fc748f |
| s0x46de6164508decf143144dda4314b435b829ac3114b2ac94b5aa49404331fc3c | string (hex) | required | 0x46de6164508decf143144dda4314b435b829ac3114b2ac94b5aa49404331fc3c |
| return_data0x | string (hex) | required | 0x |
| logs_bloom0x0000080000000000000000000000000000000000000000000000000040000000080000000000000000000000000000… | string (hex) | nullable | 0x0000080000000000000000000000000000000000000000000000000040000000080000000000000000000000000000… |
| blob_gas393216 | long | nullable | 393216 |
| blob_gas_fee_cap40505360 | string | nullable | 40505360 |
| blob_hashes["0x017ff5770d9077f91b71266e62bc46018ed9d60a37e11c0665f9d82f2f3615f7","0x0172f98c430337c9c4de28a… | array<string> (hex) | required | ["0x017ff5770d9077f91b71266e62bc46018ed9d60a37e11c0665f9d82f2f3615f7","0x0172f98c430337c9c4de28a… |
| blob_gas_used393216 | long | nullable | 393216 |
| blob_gas_price3647906 | string | nullable | 3647906 |
| begin_ordinal16991 | long | required | 16991 |
| end_ordinal17024 | long | required | 17024 |
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
transactions
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.