Enriched Transactions
Chain
LiskDataset name
lisk.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_0x8d7764f95c298b48042096428b3cd477014628b7d2ad6c43ad5cf46607d168f8_0 | 0x5f2ac968eb60384a04d1397e04d7af3623a9655cb130ef8b04a2d3fe7383fd52 | 31 | 0x8d7764f95c298b48042096428b3cd477014628b7d2ad6c43ad5cf46607d168f8 | 31 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f4240000000000000000000000001000000006634af9300000000012df3b500000000000000000000000000000000000000000000000000000001c7fa010600000000000000000000000000000000000000000000000000000000000000018a7623253242d8c22f99ffb97cbd1f794e6c902794e4e0ccc1231816eff2338a000000000000000000000000a6ea2f3299b63c53143c993d2d5e60a69cd6fe24 | null | null | 126 | 1714728853 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x6d036188f96f8e9aff125aad83324994cdaa5e3b1474774ba1291c2bf636aa18_0 | 0x97aaefa1e36cfb9b636ef37bec7c4f1ae34b3f13f28949c7eaad518a476b94b1 | 39 | 0x6d036188f96f8e9aff125aad83324994cdaa5e3b1474774ba1291c2bf636aa18 | 39 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f4240000000000000000000000009000000006634af9300000000012df3b500000000000000000000000000000000000000000000000000000001c7fa010600000000000000000000000000000000000000000000000000000000000000018a7623253242d8c22f99ffb97cbd1f794e6c902794e4e0ccc1231816eff2338a000000000000000000000000a6ea2f3299b63c53143c993d2d5e60a69cd6fe24 | null | null | 126 | 1714728869 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x1240e220324a24a523139b7477d94d071528b6a1bbefe4a0843c6fd92e41f14d_0 | 0x4fe49c9d7aea6d609f159412cc9d1cfed37659ce1f80e8a21bc6a2d77586e5ec | 51 | 0x1240e220324a24a523139b7477d94d071528b6a1bbefe4a0843c6fd92e41f14d | 51 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e20000f4240000000000000000000000003000000006634afb700000000012df3b7000000000000000000000000000000000000000000000000000000019a710c010000000000000000000000000000000000000000000000000000000000000001facbb66117fbccefb5144db2c7e1a74d4623b95a19bcc7e37f77af1e6b11f81d000000000000000000000000a6ea2f3299b63c53143c993d2d5e60a69cd6fe24 | null | null | 126 | 1714728893 | 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 |