Enriched Transactions
Chain
B3Dataset name
b3.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_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_0x063c77123f11fbb162afc7d15548704140c708bf423d50670ca5197893d97e0b_0 | 0x21764aa1695af8ee1116dbdddbb72d62a2e7a19a4bd880fb6648ad71ed0a4bd3 | 14 | 0x063c77123f11fbb162afc7d15548704140c708bf423d50670ca5197893d97e0b | 15 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000a31c20000000000000000000000010000000066a95c6700000000010f7fc200000000000000000000000000000000000000000000000000000000002d33960000000000000000000000000000000000000000000000000000000000000001228b6241809ccaa430993a0d493b64d33eb108532f6dd16432e9b53fe9e571af0000000000000000000000001af3f4e08a16b93ccbdf6887549697f17f9cf78a | null | null | 126 | 1722375272 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xe3db1b957ecaa0f323deaadeb7bf6bc7278095a0f531a1d1baa1365f7ec56b2d_0 | 0x0d745bcf6c4cbf1d6c2b12a23175588ea9e93b6d117f25a56e9101bf00768877 | 52 | 0xe3db1b957ecaa0f323deaadeb7bf6bc7278095a0f531a1d1baa1365f7ec56b2d | 53 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000a31c20000000000000000000000010000000066a95c8d00000000010f7fd500000000000000000000000000000000000000000000000000000000002c67d5000000000000000000000000000000000000000000000000000000000000000142ad459809ce5d8e63f04cfe889cfac7c9f0ce1634f3c26067ae1a056c8ddbbd0000000000000000000000001af3f4e08a16b93ccbdf6887549697f17f9cf78a | null | null | 126 | 1722375310 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xbdf7ad8992dfd2be2d879011f3d7eac61039abd02a5207d8d330f940e927271e_0 | 0x4cad6f80ffbcc52ad463e6de615a1d0cd88b441dda213b626bdfce81cee9fa37 | 81 | 0xbdf7ad8992dfd2be2d879011f3d7eac61039abd02a5207d8d330f940e927271e | 82 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000a31c20000000000000000000000000000000066a95cab00000000010f7fe400000000000000000000000000000000000000000000000000000000002bfd5f0000000000000000000000000000000000000000000000000000000000000001f1d83b37571b6c3418d8b41ccafba846e97ab8361aada25367d733df6e39cc2a0000000000000000000000001af3f4e08a16b93ccbdf6887549697f17f9cf78a | null | null | 126 | 1722375339 | 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 |