Datasets

Blockchain tables over S3, queried with your own project credentials.

Delta Lake · Parquet · AWS Signature Version 4

Resources & endpoints

Block schemas

Parquet table definitions from firehose-parquet.

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

evm blocks columns and historical examples
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

transactions 35 columns BASE

evm transactions columns and historical examples
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

logs 19 columns BASE

evm logs columns and historical examples
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
tx_hash0xf59857b4e1b56972b83fe10e6a97cb7fbee7dce73dfb1cc1dfb7646cc20ce01d	string (hex)	required	0xf59857b4e1b56972b83fe10e6a97cb7fbee7dce73dfb1cc1dfb7646cc20ce01d
tx_index4	long	required	4
log_index9	long	required	9
block_index73	long	required	73
address0xdc893995d488e5be8ec8ca1db92cbec2a1ab0775	string (hex)	required	0xdc893995d488e5be8ec8ca1db92cbec2a1ab0775
topic00x7a53080ba414158be7ec69b987b5fb7d07dee101fe85488f0853ae16239d0bde	string (hex)	nullable	0x7a53080ba414158be7ec69b987b5fb7d07dee101fe85488f0853ae16239d0bde
topic10x0000000000000000000000001f2f10d1c40777ae1da742455c65828ff36df387	string (hex)	nullable	0x0000000000000000000000001f2f10d1c40777ae1da742455c65828ff36df387
topic20xffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa6f0	string (hex)	nullable	0xffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa6f0
topic30xffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa7b8	string (hex)	nullable	0xffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffa7b8
data0x0000000000000000000000001f2f10d1c40777ae1da742455c65828ff36df387000000000000000000000000000000…	string (hex)	nullable	0x0000000000000000000000001f2f10d1c40777ae1da742455c65828ff36df387000000000000000000000000000000…
ordinal720	long	required	720

withdrawals 12 columns BASE

evm withdrawals columns and historical examples
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
block_number26093738	long	required	26093738
index144940427	long	required	144940427
validator_index1294510	long	required	1294510
address0x2bf916f8169ed2a77324d3e168284fc252ae4087	string (hex)	required	0x2bf916f8169ed2a77324d3e168284fc252ae4087
amount_gwei14103030	decimal(20,0)	required	14103030

access_lists 13 columns BASE

evm access_lists columns and historical examples
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
tx_hash0xf59857b4e1b56972b83fe10e6a97cb7fbee7dce73dfb1cc1dfb7646cc20ce01d	string (hex)	required	0xf59857b4e1b56972b83fe10e6a97cb7fbee7dce73dfb1cc1dfb7646cc20ce01d
tx_index4	long	required	4
access_index0	long	required	0
address0x40efafe9250b43b7c1be0ec1a75e4e7526559507	string (hex)	required	0x40efafe9250b43b7c1be0ec1a75e4e7526559507
storage_keys["0x0000000000000000000000000000000000000000000000000000000000000006","0x00000000000000000000000…	array<string> (hex)	required	["0x0000000000000000000000000000000000000000000000000000000000000006","0x00000000000000000000000…

set_code_authorizations 19 columns BASE

evm set_code_authorizations columns and historical examples
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
block_number26093738	long	required	26093738
tx_hash0x5c8f19b7d9d389c28448a0cce2f3130ae0f3f15730f59b2c0686b26bd3e1bf47	string (hex)	required	0x5c8f19b7d9d389c28448a0cce2f3130ae0f3f15730f59b2c0686b26bd3e1bf47
tx_index0	long	required	0
authorization_index0	long	required	0
chain_id1	string	required	1
address0xadc272a23adeecf26edef70fe1494be7f88c9193	string (hex)	nullable	0xadc272a23adeecf26edef70fe1494be7f88c9193
nonce324	decimal(20,0)	required	324
v1	long	required	1
r0xe0df3a074488f2ba6320f480d7637c5051b748b5eda4a40f64e1b143ece0ddab	string (hex)	required	0xe0df3a074488f2ba6320f480d7637c5051b748b5eda4a40f64e1b143ece0ddab
s0x32ee6d4fc2abdac625bc6bdf3d260e5ac302538c7f8bc279d84c29ac2a4d4d90	string (hex)	required	0x32ee6d4fc2abdac625bc6bdf3d260e5ac302538c7f8bc279d84c29ac2a4d4d90
authority0xe49e20152c3c51120d4fcfd41e8b6013f5bd87df	string (hex)	nullable	0xe49e20152c3c51120d4fcfd41e8b6013f5bd87df
discardedfalse	boolean	required	false

calls 30 columns EXTENDED

evm calls columns and historical examples
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
tx_hash0x4fad61d1eebd1333deb1bd7ad4d4086bdcbe75b196d20370bd7216ab431df5ad	string (hex)	required	0x4fad61d1eebd1333deb1bd7ad4d4086bdcbe75b196d20370bd7216ab431df5ad
tx_index1	long	required	1
call_index1	long	required	1
parent_index0	long	required	0
depth0	long	required	0
call_typeCALL	string	required	CALL
caller0xb3340aba2b5a97995ccd56ecf4d9ef1b5c4635bb	string (hex)	required	0xb3340aba2b5a97995ccd56ecf4d9ef1b5c4635bb
address0xe49e20152c3c51120d4fcfd41e8b6013f5bd87df	string (hex)	required	0xe49e20152c3c51120d4fcfd41e8b6013f5bd87df
value0	string	required	0
gas_limit353936	long	required	353936
gas_consumed88	long	required	88
input0x81c8c219	string (hex)	required	0x81c8c219
output0x	string (hex)	required	0x
status_failedtrue	boolean	required	true
status_revertedtrue	boolean	required	true
state_revertedtrue	boolean	required	true
executed_codetrue	boolean	required	true
suicidefalse	boolean	required	false
failure_reasonexecution reverted	string	nullable	execution reverted
address_delegates_to0xadc272a23adeecf26edef70fe1494be7f88c9193	string (hex)	nullable	0xadc272a23adeecf26edef70fe1494be7f88c9193
begin_ordinal565	long	required	565
end_ordinal566	long	required	566

balance_changes 18 columns EXTENDED

evm balance_changes columns and historical examples
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
block_number26093738	long	required	26093738
tx_hash0x5c8f19b7d9d389c28448a0cce2f3130ae0f3f15730f59b2c0686b26bd3e1bf47	string (hex)	required	0x5c8f19b7d9d389c28448a0cce2f3130ae0f3f15730f59b2c0686b26bd3e1bf47
tx_index0	long	required	0
call_index1	long	required	1
ordinal9	long	required	9
address0xc13ced137e90bc695cb77288962280516a2f9b8b	string (hex)	required	0xc13ced137e90bc695cb77288962280516a2f9b8b
old_value10122667680406152845	string	required	10122667680406152845
new_value10119253905736387456	string	required	10119253905736387456
reasonGAS_BUY	string	required	GAS_BUY
state_revertedfalse	boolean	required	false
persistedtrue	boolean	required	true

code_changes 19 columns EXTENDED

evm code_changes columns and historical examples
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
block_number26093738	long	required	26093738
tx_hash0x5c8f19b7d9d389c28448a0cce2f3130ae0f3f15730f59b2c0686b26bd3e1bf47	string (hex)	required	0x5c8f19b7d9d389c28448a0cce2f3130ae0f3f15730f59b2c0686b26bd3e1bf47
tx_index0	long	required	0
call_index1	long	required	1
ordinal12	long	required	12
address0xe49e20152c3c51120d4fcfd41e8b6013f5bd87df	string (hex)	required	0xe49e20152c3c51120d4fcfd41e8b6013f5bd87df
old_hash0x5eb7f67adcafbcba73b2f149246119aa556a72a609ef452f820f69f664a1ea08	string (hex)	required	0x5eb7f67adcafbcba73b2f149246119aa556a72a609ef452f820f69f664a1ea08
new_hash0xdcb3827d8948908fc77b7aeb7a242e9e3255b83d83fe7c87fc23086e59c6fc47	string (hex)	required	0xdcb3827d8948908fc77b7aeb7a242e9e3255b83d83fe7c87fc23086e59c6fc47
old_code0xef0100ddeeb70e3cf6e1735ada388a204347618df48156	string (hex)	required	0xef0100ddeeb70e3cf6e1735ada388a204347618df48156
new_code0xef0100adc272a23adeecf26edef70fe1494be7f88c9193	string (hex)	required	0xef0100adc272a23adeecf26edef70fe1494be7f88c9193
state_revertedfalse	boolean	required	false
persistedtrue	boolean	required	true

storage_changes 18 columns EXTENDED

evm storage_changes columns and historical examples
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
block_number26093738	long	required	26093738
tx_hash0x5c8f19b7d9d389c28448a0cce2f3130ae0f3f15730f59b2c0686b26bd3e1bf47	string (hex)	required	0x5c8f19b7d9d389c28448a0cce2f3130ae0f3f15730f59b2c0686b26bd3e1bf47
tx_index0	long	required	0
call_index3	long	required	3
ordinal17	long	required	17
address0x72a19342e8f1838460ebfccef09f6585e32db86e	string (hex)	required	0x72a19342e8f1838460ebfccef09f6585e32db86e
key0x0000000000000000000000000000000000000000000000000000000000000000	string (hex)	required	0x0000000000000000000000000000000000000000000000000000000000000000
old_value0x0000000000000000000000000000000000000000000000000000000000000001	string (hex)	required	0x0000000000000000000000000000000000000000000000000000000000000001
new_value0x0000000000000000000000000000000000000000000000000000000000000002	string (hex)	required	0x0000000000000000000000000000000000000000000000000000000000000002
state_revertedfalse	boolean	required	false
persistedtrue	boolean	required	true

nonce_changes 17 columns EXTENDED

evm nonce_changes columns and historical examples
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
block_number26093738	long	required	26093738
tx_hash0x5c8f19b7d9d389c28448a0cce2f3130ae0f3f15730f59b2c0686b26bd3e1bf47	string (hex)	required	0x5c8f19b7d9d389c28448a0cce2f3130ae0f3f15730f59b2c0686b26bd3e1bf47
tx_index0	long	required	0
call_index1	long	required	1
ordinal10	long	required	10
address0xc13ced137e90bc695cb77288962280516a2f9b8b	string (hex)	required	0xc13ced137e90bc695cb77288962280516a2f9b8b
old_value3996	long	required	3996
new_value3997	long	required	3997
state_revertedfalse	boolean	required	false
persistedtrue	boolean	required	true

gas_changes 16 columns EXTENDEDNo example row

evm gas_changes columns
Column	Type	Nullable
block_num	long	required
block_id	string (hex)	required
parent_num	long	required
parent_id	string (hex)	required
lib_num	long	required
timestamp	timestamp	required
date	date (partition)	required
block_number	long	required
tx_hash	string (hex)	required
tx_index	long	required
call_index	long	required
ordinal	long	required
old_value	long	required
new_value	long	required
reason	string	required
state_reverted	boolean	required

account_creations 15 columns EXTENDEDNo example row

evm account_creations columns
Column	Type	Nullable
block_num	long	required
block_id	string (hex)	required
parent_num	long	required
parent_id	string (hex)	required
lib_num	long	required
timestamp	timestamp	required
date	date (partition)	required
block_number	long	required
tx_hash	string (hex)	required
tx_index	long	required
call_index	long	required
ordinal	long	required
account	string (hex)	required
state_reverted	boolean	required
persisted	boolean	required

system_calls 28 columns EXTENDED

evm system_calls columns and historical examples
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
block_number26093738	long	required	26093738
call_index1	long	required	1
parent_index0	long	required	0
depth0	long	required	0
call_typeCALL	string	required	CALL
caller0xfffffffffffffffffffffffffffffffffffffffe	string (hex)	required	0xfffffffffffffffffffffffffffffffffffffffe
address0x0000f90827f1c53a10cb7a02335b175320002935	string (hex)	required	0x0000f90827f1c53a10cb7a02335b175320002935
value0	string	required	0
gas_limit31566720	long	required	31566720
gas_consumed5043	long	required	5043
input0xcd26204e996dceb606ccf0bc6f5bf8ea6747a471df8be73b5855f01624d5d743	string (hex)	required	0xcd26204e996dceb606ccf0bc6f5bf8ea6747a471df8be73b5855f01624d5d743
output0x	string (hex)	required	0x
status_failedfalse	boolean	required	false
status_revertedfalse	boolean	required	false
state_revertedfalse	boolean	required	false
executed_codetrue	boolean	required	true
suicidefalse	boolean	required	false
failure_reasonnull	string	nullable	null
address_delegates_tonull	string (hex)	nullable	null
begin_ordinal1	long	required	1
end_ordinal3	long	required	3

system_balance_changes 14 columns EXTENDED

evm system_balance_changes columns and historical examples
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
block_number26093738	long	required	26093738
call_indexnull	long	nullable	null
ordinal64	long	required	64
address0x2bf916f8169ed2a77324d3e168284fc252ae4087	string (hex)	required	0x2bf916f8169ed2a77324d3e168284fc252ae4087
old_value26268701703947947949656	string	required	26268701703947947949656
new_value26268715806977947949656	string	required	26268715806977947949656
reasonWITHDRAWAL	string	required	WITHDRAWAL

system_code_changes 15 columns EXTENDEDNo example row

evm system_code_changes columns
Column	Type	Nullable
block_num	long	required
block_id	string (hex)	required
parent_num	long	required
parent_id	string (hex)	required
lib_num	long	required
timestamp	timestamp	required
date	date (partition)	required
block_number	long	required
call_index	long	nullable
ordinal	long	required
address	string (hex)	required
old_hash	string (hex)	required
new_hash	string (hex)	required
old_code	string (hex)	required
new_code	string (hex)	required

system_storage_changes 14 columns EXTENDED

evm system_storage_changes columns and historical examples
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
block_number26093738	long	required	26093738
call_index1	long	nullable	1
ordinal2	long	required	2
address0x0000f90827f1c53a10cb7a02335b175320002935	string (hex)	required	0x0000f90827f1c53a10cb7a02335b175320002935
key0x000000000000000000000000000000000000000000000000000000000000151a	string (hex)	required	0x000000000000000000000000000000000000000000000000000000000000151a
old_value0xca088a4f97415ecfd8d985996be67793f308da40207a538092e357fd0042a68d	string (hex)	required	0xca088a4f97415ecfd8d985996be67793f308da40207a538092e357fd0042a68d
new_value0xcd26204e996dceb606ccf0bc6f5bf8ea6747a471df8be73b5855f01624d5d743	string (hex)	required	0xcd26204e996dceb606ccf0bc6f5bf8ea6747a471df8be73b5855f01624d5d743

system_nonce_changes 13 columns EXTENDEDNo example row

evm system_nonce_changes columns
Column	Type	Nullable
block_num	long	required
block_id	string (hex)	required
parent_num	long	required
parent_id	string (hex)	required
lib_num	long	required
timestamp	timestamp	required
date	date (partition)	required
block_number	long	required
call_index	long	nullable
ordinal	long	required
address	string (hex)	required
old_value	long	required
new_value	long	required

system_gas_changes 13 columns EXTENDEDNo example row

evm system_gas_changes columns
Column	Type	Nullable
block_num	long	required
block_id	string (hex)	required
parent_num	long	required
parent_id	string (hex)	required
lib_num	long	required
timestamp	timestamp	required
date	date (partition)	required
block_number	long	required
call_index	long	nullable
ordinal	long	required
old_value	long	required
new_value	long	required
reason	string	required

system_account_creations 11 columns EXTENDEDNo example row

evm system_account_creations columns
Column	Type	Nullable
block_num	long	required
block_id	string (hex)	required
parent_num	long	required
parent_id	string (hex)	required
lib_num	long	required
timestamp	timestamp	required
date	date (partition)	required
block_number	long	required
call_index	long	nullable
ordinal	long	required
account	string (hex)	required

Reference schemas from earlier fireparq releases. Solana, Bitcoin and Beacon dataset buckets are not available in the App yet.

blocks 15 columns

solana blocks columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	nullable
date	Date32	nullable
slot	UInt64	required
parent_slot	UInt64	required
block_height	UInt64	nullable
blockhash	Utf8	required
previous_blockhash	Utf8	required
block_time	Int64	nullable
num_transactions	UInt32	required
num_rewards	UInt32	required

transactions 21 columns

solana transactions columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	nullable
date	Date32	nullable
slot	UInt64	required
transaction_index	UInt32	required
signature	Bytes	required
num_signatures	UInt32	required
fee	UInt64	required
err	Bytes	nullable
success	Boolean	required
compute_units_consumed	UInt64	nullable
log_messages	List<Utf8>	nullable
pre_balances	List<UInt64>	nullable
post_balances	List<UInt64>	nullable
cost_units	UInt64	nullable
return_data_program_id	Bytes	nullable
return_data	Bytes	nullable

messages 18 columns

solana messages columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	nullable
date	Date32	nullable
slot	UInt64	required
transaction_index	UInt32	required
message_index	UInt32	required
num_required_signatures	UInt32	required
num_readonly_signed_accounts	UInt32	required
num_readonly_unsigned_accounts	UInt32	required
recent_blockhash	Bytes	required
versioned	Boolean	required
account_keys	List<Bytes>	required
loaded_writable_addresses	List<Bytes>	nullable
loaded_readonly_addresses	List<Bytes>	nullable

instructions 16 columns

solana instructions columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	nullable
date	Date32	nullable
slot	UInt64	required
transaction_index	UInt32	required
instruction_index	UInt32	required
program_id_index	UInt32	required
accounts	Bytes	required
data	Bytes	required
is_inner	Boolean	required
inner_index	UInt32	nullable
stack_height	UInt32	nullable

rewards 16 columns

solana rewards columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	nullable
date	Date32	nullable
slot	UInt64	required
reward_index	UInt32	required
pubkey	Utf8	required
lamports	Int64	required
post_balance	UInt64	required
reward_type	Int32	required
commission	Utf8	nullable
source	Utf8	required
transaction_index	UInt32	nullable

token_balances 19 columns

solana token_balances columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	nullable
date	Date32	nullable
slot	UInt64	required
transaction_index	UInt32	required
balance_index	UInt32	required
balance_type	Utf8	required
account_index	UInt32	required
mint	Utf8	required
owner	Utf8	required
program_id	Utf8	required
amount	Utf8	required
ui_amount	Float64	nullable
decimals	UInt32	required
ui_amount_string	Utf8	required

account_lookups 13 columns

solana account_lookups columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	nullable
date	Date32	nullable
slot	UInt64	required
transaction_index	UInt32	required
lookup_index	UInt32	required
account_key	Bytes	required
writable_indexes	Bytes	required
readonly_indexes	Bytes	required

vote_transactions 21 columns with votes

solana vote_transactions columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	nullable
date	Date32	nullable
slot	UInt64	required
transaction_index	UInt32	required
signature	Bytes	required
num_signatures	UInt32	required
fee	UInt64	required
err	Bytes	nullable
success	Boolean	required
compute_units_consumed	UInt64	nullable
log_messages	List<Utf8>	nullable
pre_balances	List<UInt64>	nullable
post_balances	List<UInt64>	nullable
cost_units	UInt64	nullable
return_data_program_id	Bytes	nullable
return_data	Bytes	nullable

Reference schemas from earlier fireparq releases. Solana, Bitcoin and Beacon dataset buckets are not available in the App yet.

blocks 22 columns

bitcoin blocks columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
hash	Utf8	required
height	Int64	required
previous_hash	Utf8	required
merkle_root	Utf8	required
time	Int64	required
nonce	UInt32	required
bits	Utf8	required
difficulty	Float64	required
size	Int32	required
stripped_size	Int32	required
weight	Int32	required
version	Int32	required
n_tx	UInt32	required
mediantime	Int64	required
chainwork	Utf8	required

transactions 18 columns

bitcoin transactions columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
txid	Utf8	required
hash	Utf8	required
size	Int32	required
vsize	Int32	required
weight	Int32	required
version	UInt32	required
locktime	UInt32	required
block_hash	Utf8	required
block_height	Int64	required
block_time	Int64	required
tx_index	UInt32	required

inputs 17 columns

bitcoin inputs columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
tx_hash	Utf8	required
block_height	Int64	required
input_index	UInt32	required
prev_txid	Utf8	required
prev_vout	UInt32	required
sequence	UInt32	required
script_sig_asm	Utf8	required
script_sig_hex	Utf8	required
coinbase	Utf8	required
witness	List<Utf8>	required

outputs 15 columns

bitcoin outputs columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
tx_hash	Utf8	required
block_height	Int64	required
output_index	UInt32	required
value	Float64	required
script_pubkey_asm	Utf8	required
script_pubkey_hex	Utf8	required
script_pubkey_type	Utf8	required
script_pubkey_address	Utf8	required

Reference schemas from earlier fireparq releases. Solana, Bitcoin and Beacon dataset buckets are not available in the App yet.

blocks 16 columns

beacon blocks columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
slot	UInt64	required
parent_slot	UInt64	required
proposer_index	UInt64	required
root	Bytes	required
parent_root	Bytes	required
state_root	Bytes	required
body_root	Bytes	required
signature	Bytes	required
spec	Utf8	required

attestations 18 columns

beacon attestations columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
block_slot	UInt64	required
attestation_index	UInt32	required
slot	UInt64	required
committee_index	UInt64	required
aggregation_bits	Bytes	required
beacon_block_root	Bytes	required
source_epoch	UInt64	required
source_root	Bytes	required
target_epoch	UInt64	required
target_root	Bytes	required
signature	Bytes	required

deposits 13 columns

beacon deposits columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
block_slot	UInt64	required
deposit_index	UInt32	required
pubkey	Bytes	required
withdrawal_credentials	Bytes	required
amount	UInt64	required
signature	Bytes	required

proposer_slashings 19 columns

beacon proposer_slashings columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
block_slot	UInt64	required
slashing_index	UInt32	required
header_1_slot	UInt64	required
header_1_proposer_index	UInt64	required
header_1_parent_root	Bytes	required
header_1_state_root	Bytes	required
header_1_body_root	Bytes	required
header_2_slot	UInt64	required
header_2_proposer_index	UInt64	required
header_2_parent_root	Bytes	required
header_2_state_root	Bytes	required
header_2_body_root	Bytes	required

attester_slashings 23 columns

beacon attester_slashings columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
block_slot	UInt64	required
slashing_index	UInt32	required
attestation_1_slot	UInt64	required
attestation_1_committee_index	UInt64	required
attestation_1_beacon_block_root	Bytes	required
attestation_1_source_epoch	UInt64	required
attestation_1_source_root	Bytes	required
attestation_1_target_epoch	UInt64	required
attestation_1_target_root	Bytes	required
attestation_2_slot	UInt64	required
attestation_2_committee_index	UInt64	required
attestation_2_beacon_block_root	Bytes	required
attestation_2_source_epoch	UInt64	required
attestation_2_source_root	Bytes	required
attestation_2_target_epoch	UInt64	required
attestation_2_target_root	Bytes	required

voluntary_exits 12 columns

beacon voluntary_exits columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
block_slot	UInt64	required
exit_index	UInt32	required
epoch	UInt64	required
validator_index	UInt64	required
signature	Bytes	required

execution_payload 21 columns

beacon execution_payload columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
block_slot	UInt64	required
parent_hash	Bytes	required
fee_recipient	Bytes	required
state_root	Bytes	required
receipts_root	Bytes	required
prev_randao	Bytes	required
block_number	UInt64	required
gas_limit	UInt64	required
gas_used	UInt64	required
payload_timestamp	Int64	nullable
block_hash	Bytes	required
base_fee_per_gas	Bytes	required
blob_gas_used	UInt64	nullable
excess_blob_gas	UInt64	nullable

blob_sidecars 12 columns

beacon blob_sidecars columns
Column	Type	Nullable
block_num	UInt64	required
block_id	Bytes	required
parent_num	UInt64	required
parent_id	Bytes	required
lib_num	UInt64	required
timestamp	Timestamp(Second, UTC)	required
date	Date32	required
block_slot	UInt64	required
blob_index	UInt64	required
blob	Bytes	required
kzg_commitment	Bytes	required
kzg_proof	Bytes	required

Block schemas

EVM schemas

Solana schemas

Bitcoin schemas

Beacon schemas