Enriched Transactions
Chain
Scroll MainnetDataset name
scroll_mainnet.transaction_receiptsVersion
1.0.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_l1_fee | receipt_l1_fee_scalar | receipt_l1_gas_price | receipt_l1_gas_used | receipt_root | receipt_root_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_0x8e2ef416de7f7d5acf97ff3670c509cd6a40c490fabdb53b2c266b3d6f359c85_0 | 0x5ffe75a240bf97d7a621b116ecd93040867f7dfc4e642e6f6b252487d7defb02 | 96 | 0x8e2ef416de7f7d5acf97ff3670c509cd6a40c490fabdb53b2c266b3d6f359c85 | 1190087 | 0 | 0xf8ca4bdc7db06ad819fe8aed62bf5fc9a13831f6 | 0x80c67432656d59144ceff962e8faf8926599bcf8 | 9500000000009023 | 21000 | 400000000 | 0x | 0 | 1701292746 | 21000 | 21000 | 1 | 400000000 | 335725953262977 | ||||||||
| enriched_transaction_0x7608276a76c61c64b5372ddb00c4428cff3a7f09b93e98fbc882f71ba576e506_1 | 0x6fb075f4a3ac9199c2fa3b8005c8a51cb2934603de40c76992f82d9d0de1300e | 73750 | 0x7608276a76c61c64b5372ddb00c4428cff3a7f09b93e98fbc882f71ba576e506 | 1190082 | 1 | 0x80c67432656d59144ceff962e8faf8926599bcf8 | 0x46e168e4b54298bf02acbbd252b5930cf7d4eb8e | 47227000000000001 | 21000 | 440000000 | 0x | 0 | 1701292727 | 56189 | 21000 | 1 | 440000000 | 338518498160728 | ||||||||
| enriched_transaction_0x619d37a91b83ef9ba3bfa0eff3b396e33a90ee6a741748ffca355d3ad861f6c5_1 | 0x1a21785b90b39b83975e108caf159a9036cdbc076eeb8753cd52e76512d409c2 | 5 | 0x619d37a91b83ef9ba3bfa0eff3b396e33a90ee6a741748ffca355d3ad861f6c5 | 1189987 | 1 | 0xa8deb1a45696f409661025f644e7102b74b2228b | 0x6e55472109e6abe4054a8e8b8d9edffcb31032c5 | 400000000000000 | 77938 | 400000000 | 0x1249c58b | 0 | 1701292333 | 98938 | 77938 | 1 | 400000000 | 416957033211537 |
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 |