Enriched Transactions
Chain
Bob TestnetDataset name
bob_testnet.receipt_transactionsVersion
1.0.0Description
Transaction data including input, value, from and to address, and metadata for the block, gas, and receipts.
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 | 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_0x764699b28c608e16a408ed9090aad717c2c76a5e564418fdd536fb4cd61cbccc_0 | 0xbb4c8e14721f1e111ce6814ba45d3553a098922a1249ac75fe078558f46cb246 | 1 | 0x764699b28c608e16a408ed9090aad717c2c76a5e564418fdd536fb4cd61cbccc | 2 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0 | 0 | 0x015d8eb90000000000000000000000000000000000000000000000000000000000441813000000000000000000000000000000000000000000000000000000006525260400000000000000000000000000000000000000000000000000000000000000302ea36f07fff4127174b68efacd2c5a9a47455a2b278e8c3b2ee9e0a01808eced0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000a06251fda7fe4a8ab89b0d7f6e5949b3ef1afafa00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1696933384 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null |
| enriched_transaction_v2_0xb255cfe24a7eb679709131cc7568481a4dcfc16e5ced8f40ebf64a44da0c1e97_0 | 0xd6905f76d4243d5438f92475c628d3c3b49eac66c060a00a18f20cd9a2af11dc | 10 | 0xb255cfe24a7eb679709131cc7568481a4dcfc16e5ced8f40ebf64a44da0c1e97 | 11 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0 | 0 | 0x015d8eb9000000000000000000000000000000000000000000000000000000000044181400000000000000000000000000000000000000000000000000000000652526100000000000000000000000000000000000000000000000000000000000000035aa7e39002be7392cc188dedea18485a64239ac1028eee6d118c2de7922a81ed50000000000000000000000000000000000000000000000000000000000000005000000000000000000000000a06251fda7fe4a8ab89b0d7f6e5949b3ef1afafa00000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000a6fe0 | null | null | 126 | 1696933402 | 0 | 0 | null | 1 | 0 | null | 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 | long |
| 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 |