Enriched Transactions
Chain
Data TestnetDataset name
data_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_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_0x55d3d1bd2501ccf3afecb2820b704cfb7e2f9b6253516970abbc4d19f8a442c8_1 | 0x3eb547dc672db10879646b6bdcbb0c50b33f7d0c41f5d99486ac6b8cd9cdd217 | 17 | 0x55d3d1bd2501ccf3afecb2820b704cfb7e2f9b6253516970abbc4d19f8a442c8 | 1147 | 1 | 0x2bd0cf9b2079a2e34869e0ed2336846e1074a1bd | 0x9fbb3df7c40da2e5a0de984ffe2ccb7c47cd0abf | 0 | 0 | 0x9881d1950000000000000000000000000000000000000000000000000000000000000040bfe762a59eff867b2eed2516f6c0853a4004615a5837c1a987e6f261b4324ae2000000000000000000000000000000000000000000000000000000000000047d60806040526040516103dd3803806103dd8339810160408190526100229161023c565b61002c8282610033565b5050610321565b61003c82610091565b6040516001600160a01b038316907fbc7cd75a20ee27fd9adebab32041f755214dbc6bffa90cc0225b39da2e5c2d3b905f90a280511561008557610080828261010c565b505050565b61008d61017f565b5050565b806001600160a01b03163b5f036100cb57604051634c9c8ce360e01b81526001600160a01b03821660048201526024015b60405180910390fd5b7f360894a13ba1a3210667c828492db98dca3e2076cc3735a920a3ca505d382bbc80546001600160a01b0319166001600160a01b0392909216919091179055565b60605f80846001600160a01b031684604051610128919061030b565b5f60405180830381855af49150503d805f8114610160576040519150601f19603f3d011682016040523d82523d5f602084013e610165565b606091505b5090925090506101768583836101a0565b95945050505050565b341561019e5760405163b398979f60e01b815260040160405180910390fd5b565b6060826101b5576101b0826101ff565b6101f8565b81511580156101cc57506001600160a01b0384163b155b156101f557604051639996b31560e01b81526001600160a01b03851660048201526024016100c2565b50805b9392505050565b80511561020f5780518082602001fd5b604051630a12f52160e11b815260040160405180910390fd5b634e487b7160e01b5f52604160045260245ffd5b5f806040838503121561024d575f80fd5b82516001600160a01b0381168114610263575f80fd5b60208401519092506001600160401b0381111561027e575f80fd5b8301601f8101851361028e575f80fd5b80516001600160401b038111156102a7576102a7610228565b604051601f8201601f19908116603f011681016001600160401b03811182821017156102d5576102d5610228565b6040528181528282016020018710156102ec575f80fd5b8160208401602083015e5f602083830101528093505050509250929050565b5f82518060208501845e5f920191825250919050565b60b08061032d5f395ff3fe6080604052600a600c565b005b60186014601a565b605d565b565b5f60587f360894a13ba1a3210667c828492db98dca3e2076cc3735a920a3ca505d382bbc5473ffffffffffffffffffffffffffffffffffffffff1690565b905090565b365f80375f80365f845af43d5f803e8080156076573d5ff35b3d5ffdfea26469706673582212206ea39a1c34dec5b44e403b67aa977869bb76976909e6be629ec45def1f1742ad64736f6c634300081a0033000000000000000000000000c9711b5c5840ef0a16c6628b96109ec0f5a73ea200000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000024c4d66de8000000000000000000000000fdece7b8a2f55cec33b53fd28936b4b1e3153d5300000000000000000000000000000000000000000000000000000000000000 | null | null | 0 | 1737579533 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0x637678b594cdfecc3b187380d69ba6cd57c5a12abf5180a063e67a6013b7515e_9 | 0x491d6777fc256eb8c09bbea84ad1ac678e8499ac3c5169d95c251889d315373f | 35 | 0x637678b594cdfecc3b187380d69ba6cd57c5a12abf5180a063e67a6013b7515e | 1149 | 9 | 0x2bd0cf9b2079a2e34869e0ed2336846e1074a1bd | 0x9fbb3df7c40da2e5a0de984ffe2ccb7c47cd0abf | 0 | 0 | 0x9881d1950000000000000000000000000000000000000000000000000000000000000040ec81f8628eb1f528b12bc9cdd1e44687224c7116224dad4abefb017ef5aa470e000000000000000000000000000000000000000000000000000000000000057d60806040526040516103dd3803806103dd8339810160408190526100229161023c565b61002c8282610033565b5050610321565b61003c82610091565b6040516001600160a01b038316907fbc7cd75a20ee27fd9adebab32041f755214dbc6bffa90cc0225b39da2e5c2d3b905f90a280511561008557610080828261010c565b505050565b61008d61017f565b5050565b806001600160a01b03163b5f036100cb57604051634c9c8ce360e01b81526001600160a01b03821660048201526024015b60405180910390fd5b7f360894a13ba1a3210667c828492db98dca3e2076cc3735a920a3ca505d382bbc80546001600160a01b0319166001600160a01b0392909216919091179055565b60605f80846001600160a01b031684604051610128919061030b565b5f60405180830381855af49150503d805f8114610160576040519150601f19603f3d011682016040523d82523d5f602084013e610165565b606091505b5090925090506101768583836101a0565b95945050505050565b341561019e5760405163b398979f60e01b815260040160405180910390fd5b565b6060826101b5576101b0826101ff565b6101f8565b81511580156101cc57506001600160a01b0384163b155b156101f557604051639996b31560e01b81526001600160a01b03851660048201526024016100c2565b50805b9392505050565b80511561020f5780518082602001fd5b604051630a12f52160e11b815260040160405180910390fd5b634e487b7160e01b5f52604160045260245ffd5b5f806040838503121561024d575f80fd5b82516001600160a01b0381168114610263575f80fd5b60208401519092506001600160401b0381111561027e575f80fd5b8301601f8101851361028e575f80fd5b80516001600160401b038111156102a7576102a7610228565b604051601f8201601f19908116603f011681016001600160401b03811182821017156102d5576102d5610228565b6040528181528282016020018710156102ec575f80fd5b8160208401602083015e5f602083830101528093505050509250929050565b5f82518060208501845e5f920191825250919050565b60b08061032d5f395ff3fe6080604052600a600c565b005b60186014601a565b605d565b565b5f60587f360894a13ba1a3210667c828492db98dca3e2076cc3735a920a3ca505d382bbc5473ffffffffffffffffffffffffffffffffffffffff1690565b905090565b365f80375f80365f845af43d5f803e8080156076573d5ff35b3d5ffdfea26469706673582212206ea39a1c34dec5b44e403b67aa977869bb76976909e6be629ec45def1f1742ad64736f6c634300081a0033000000000000000000000000fe0f0d97f56b62abb4a539fdca8b10c3e6a12b190000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000012490657147000000000000000000000000fdece7b8a2f55cec33b53fd28936b4b1e3153d53000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000370696c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005368747470733a2f2f6769746875622e636f6d2f73746f727970726f746f636f6c2f70726f746f636f6c2d636f72652f626c6f622f6d61696e2f50494c5f426574615f46696e616c5f323032345f30322e7064660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | null | null | 0 | 1737579539 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0xcbd0a1423ddc33311a903abba5d32055b05394f5ab9d0befa4352e6181b5e79a_29 | 0x9ebed2c87de4530945cb455a13983751ead7d6f59af1177a4b1b184b022b8eb2 | 65 | 0xcbd0a1423ddc33311a903abba5d32055b05394f5ab9d0befa4352e6181b5e79a | 1151 | 29 | 0x2bd0cf9b2079a2e34869e0ed2336846e1074a1bd | 0x9825cc7a398d9c3ddd66232a8ec76d5b05422581 | 0 | 0xf2fde38b00000000000000000000000077319b4031e6ef1250907aa00018b8b1c67a244b | null | null | 0 | 1737579545 | oO | null | 1 | 0 | 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 |