Enriched Transactions
Chain
BobDataset name
bob.transaction_receiptsVersion
1.2.0Description
Enriched transaction data including input, value, from and to address, and metadata for the block, gas and receipt.
Example data
| id | hash | nonce | block_hash | block_number | transaction_index | from_address | to_address | value | gas | gas_price | input | max_fee_per_gas | max_priority_fee_per_gas | transaction_type | block_timestamp | receipt_cumulative_gas_used | receipt_gas_used | receipt_contract_address | receipt_status | receipt_effective_gas_price | receipt_root_hash | receipt_l1_fee | receipt_l1_gas_used | receipt_l1_gas_price | receipt_l1_fee_scalar | receipt_l1_blob_base_fee | receipt_l1_blob_base_fee_scalar | blob_versioned_hashes | max_fee_per_blob_gas | receipt_l1_block_number | receipt_l1_base_fee_scalar | gateway_fee | fee_currency | gateway_fee_recipient |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_v2_0x8246895682bd42c18e26735897a920ff1bb4b4733e68d52125a499531b55b1ed_0 | 0xbdd7f4f6d9ce730fdaf160ffbd6a30d5063df46da63e01048acfbf545b9d4045 | 22592 | 0x8246895682bd42c18e26735897a920ff1bb4b4733e68d52125a499531b55b1ed | 22592 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 1000000 | 0x440a5e20000a6fe0000000000000000000000004000000006618e36300000000012ba7230000000000000000000000000000000000000000000000000000000517160d2b00000000000000000000000000000000000000000000000000000000000a5967e1d9f893ec36394bd5fe24f14eb9b9c9f991cb8e7a811c6034622f17ab24749b00000000000000000000000008f9f14ff43e112b18c96f0986f28cb1878f1d11 | null | null | 126 | 1712907171 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | ||||
| enriched_transaction_v2_0x6401b5365aaafe4e03b969b982565beca1f45c09029bf86e985ff514c658efd0_0 | 0x63ed0afca6600ddd868ade84c5fad309a5bac6776d1f738dbc8d3a6017f28e73 | 22601 | 0x6401b5365aaafe4e03b969b982565beca1f45c09029bf86e985ff514c658efd0 | 22601 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 1000000 | 0x440a5e20000a6fe0000000000000000000000002000000006618e36f00000000012ba72400000000000000000000000000000000000000000000000000000004ffff488600000000000000000000000000000000000000000000000000000000000ba4949fdf3ab0ae7ecbfe051fe097db328e2bebc9174f0db78ed0f3c66a6cd2ea157700000000000000000000000008f9f14ff43e112b18c96f0986f28cb1878f1d11 | null | null | 126 | 1712907189 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x6dad377cf2d523ba567c05a03b0f3a7ef2281cf3020f9972e0423a6f26088d74_0 | 0xec38a1867b180db77504ec671ac49fca3e453326671ca2849af5f46fd4f10daa | 22605 | 0x6dad377cf2d523ba567c05a03b0f3a7ef2281cf3020f9972e0423a6f26088d74 | 22605 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 1000000 | 0x440a5e20000a6fe0000000000000000000000000000000006618e37b00000000012ba72500000000000000000000000000000000000000000000000000000004f4b3b30600000000000000000000000000000000000000000000000000000000000a596738391504babbee2b5210323ffb07410f4803aa1b82c1644c8d50bb506f653bac00000000000000000000000008f9f14ff43e112b18c96f0986f28cb1878f1d11 | null | null | 126 | 1712907197 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
Schema
| Column | Type |
|---|---|
| id | string |
| hash | string |
| nonce | long |
| block_hash | string |
| block_number | long |
| transaction_index | long |
| from_address | string |
| to_address | string |
| value | decimal |
| gas | decimal |
| gas_price | decimal |
| input | string |
| max_fee_per_gas | decimal |
| max_priority_fee_per_gas | decimal |
| transaction_type | long |
| block_timestamp | long |
| receipt_cumulative_gas_used | decimal |
| receipt_gas_used | decimal |
| receipt_contract_address | string |
| receipt_status | long |
| receipt_effective_gas_price | decimal |
| receipt_root_hash | string |
| receipt_l1_fee | decimal |
| receipt_l1_gas_used | decimal |
| receipt_l1_gas_price | decimal |
| receipt_l1_fee_scalar | double |
| receipt_l1_blob_base_fee | decimal |
| receipt_l1_blob_base_fee_scalar | long |
| blob_versioned_hashes | array |
| max_fee_per_blob_gas | decimal |
| receipt_l1_block_number | long |
| receipt_l1_base_fee_scalar | long |
| gateway_fee | long |
| fee_currency | string |
| gateway_fee_recipient | string |