Enriched Transactions
Chain
Lisk SepoliaDataset name
lisk_sepolia.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_0x0eb6abd291aeb590ddc50b59eca34820c410a4c2608d70d7deb9da95ec663289_0 | 0x7339a02aabf151dc94b26c70e665894751ba91ab155f18f55b47ad24088d6322 | 22 | 0x0eb6abd291aeb590ddc50b59eca34820c410a4c2608d70d7deb9da95ec663289 | 23 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000004daa3d0000000000000000000000000000000000000000000000000000000065a5030400000000000000000000000000000000000000000000000000000008ba1e6dffd0a1ce6de2f31e72ce6983c75097729e5c17fd31bae1cb38d6dfe3260bf270120000000000000000000000000000000000000000000000000000000000000005000000000000000000000000246e119a5bcc2875161b23e4e602e25cece96e37000000000000000000000000000000000000000000000000000000000000083400000000000000000000000000000000000000000000000000000000000f4240 | null | null | 126 | 1705313038 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x4965a4823f28d74939e316a0538a0f999104f8e0dcc4ae021e88d629eb36b5bc_0 | 0x46333b547036d1da9d4fab6a0fbd760bf3c791c07f6a311a42e04a2c75b831a5 | 23 | 0x4965a4823f28d74939e316a0538a0f999104f8e0dcc4ae021e88d629eb36b5bc | 24 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000004daa3d0000000000000000000000000000000000000000000000000000000065a5030400000000000000000000000000000000000000000000000000000008ba1e6dffd0a1ce6de2f31e72ce6983c75097729e5c17fd31bae1cb38d6dfe3260bf270120000000000000000000000000000000000000000000000000000000000000006000000000000000000000000246e119a5bcc2875161b23e4e602e25cece96e37000000000000000000000000000000000000000000000000000000000000083400000000000000000000000000000000000000000000000000000000000f4240 | null | null | 126 | 1705313040 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0xee505ea342b55464c3312c8c429a73ba801a1a9aeb6c75af7ab848b863544805_0 | 0xc01f870533b8d8aebcf0f4d3e905fe8d2a97a49863141df4f229b56ad1af299e | 26 | 0xee505ea342b55464c3312c8c429a73ba801a1a9aeb6c75af7ab848b863544805 | 27 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x015d8eb900000000000000000000000000000000000000000000000000000000004daa3d0000000000000000000000000000000000000000000000000000000065a5030400000000000000000000000000000000000000000000000000000008ba1e6dffd0a1ce6de2f31e72ce6983c75097729e5c17fd31bae1cb38d6dfe3260bf270120000000000000000000000000000000000000000000000000000000000000009000000000000000000000000246e119a5bcc2875161b23e4e602e25cece96e37000000000000000000000000000000000000000000000000000000000000083400000000000000000000000000000000000000000000000000000000000f4240 | null | null | 126 | 1705313046 | 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 |