Enriched Transactions
Chain
RootstockDataset name
rootstock.receipt_transactionsVersion
1.1.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_0xf2614e068d121dea102e025de0c7f52cca19eba883e85102e33f4fe3a8de87e6_9 | 0x80b7cb9fb2d9322eee3041480c4ce2a74af13acabc4b7d6a12ac5bc8ac362d03 | 40828 | 0xf2614e068d121dea102e025de0c7f52cca19eba883e85102e33f4fe3a8de87e6 | 8537198 | 9 | 0xe93685f3bba03016f02bd1828badd6195988d950 | 0xa20db4ffe74a31d17fc24bd32a7dd7555441058e | Êi | ÝF | 0xcfc3257000000000000000000000000000000000000000000000000000000000000000200000000000000000000000009d1b1669c73b033dfe47ae5a0164ab96df25b94400000000000000000000000000000000000000000000000000000000000075c1000000000000000000000000e1ad845d93853fff44990ae0dcecd8575293681e0000000000000000000000000000000000000000000000000000000000000093ae6c5a14cdb9fc27874f230aebf78aadf7fe4248a528cd464ebd8ad7d1fecc640000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000187ad000000000000000000000000000000000000000000000000000000000000001001000d010000767400000000000002a9000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | null | null | 0 | 1771313907 | J | " | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0x4cf827b25c55816a0c7b51a49e09d20c4b6c71952a93a68155409976a233841c_0 | 0xd650ca6e0e3e6998e02177cb52de4e087edfc1ac760a83a619aa625c74ddba07 | 8537204 | 0x4cf827b25c55816a0c7b51a49e09d20c4b6c71952a93a68155409976a233841c | 8537205 | 0 | 0x0000000000000000000000000000000000000000 | 0x0000000000000000000000000000000001000008 | 0x | null | null | 0 | 1771314060 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x88b92c7a48ef2d41d466addd61dc3ddafc132dfea2a752fab94ede7073f2e2c9_0 | 0xb8d07a2e35ff7d1770ef8094f69d3edcc458491adda135fd4a5acfc858826029 | 26461 | 0x88b92c7a48ef2d41d466addd61dc3ddafc132dfea2a752fab94ede7073f2e2c9 | 8537208 | 0 | 0xa6666c28365fe75ff3562c5f1af084368fff180a | 0x0000000000000000000000000000000001000006 | Ð | ºÀ | 0x0c5a9990 | null | null | 0 | 1771314120 | Ð | Ð | 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 |