Enriched Transactions
Chain
SettlusDataset name
settlus.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_0x3943060da42a47824804ac421272cee851231e91b04d3b14b40bd8ca61c7dfb1_0 | 0xdbde4b4ae573a9b138f0faa82f6b80082ea2e6ea01795063a618e6f1885782a2 | 14 | 0x3943060da42a47824804ac421272cee851231e91b04d3b14b40bd8ca61c7dfb1 | 15 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc500000000000000030000000067b8e94300000000014e202b0000000000000000000000000000000000000000000000000000000046738df00000000000000000000000000000000000000000000000000000000278aaebf566daba40ef4f61c197c973d127645925bf3c00d216ac2e729958111363493bf8000000000000000000000000d0b4c3ac8a50b6f1b3949adaf55cc9805620eb57 | null | null | 126 | 1740171590 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x9a215c450678adef16b49f40a65dc7455268e68552a99c852b5669ab84512d3e_0 | 0xdb50fa8a6c53df43b5ee8582d19539cce7bf3d019363521b38ccbd18104cbe7e | 69 | 0x9a215c450678adef16b49f40a65dc7455268e68552a99c852b5669ab84512d3e | 70 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc5000000000000000a0000000067b8e97300000000014e202f000000000000000000000000000000000000000000000000000000004aad92370000000000000000000000000000000000000000000000000000000248e3c17c6c8a61d2487c1eb6ddbdf6efba506d0d7db61aecf882ec2fdc79cf68bb3ae811000000000000000000000000d0b4c3ac8a50b6f1b3949adaf55cc9805620eb57 | null | null | 126 | 1740171645 | null | 1 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||||
| enriched_transaction_v2_0x750af9acb1c9aef3371e047310b209a210f0ef53bf2410fabe62696ad51b242a_0 | 0x8dafd8ba678bf1ff64e2840c1f7f35395b5d1d7603cd1bb6ef3a88e9dfba6ade | 84 | 0x750af9acb1c9aef3371e047310b209a210f0ef53bf2410fabe62696ad51b242a | 85 | 0 | 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001 | 0x4200000000000000000000000000000000000015 | 0 | 0x440a5e2000000558000c5fc500000000000000010000000067b8e98b00000000014e20310000000000000000000000000000000000000000000000000000000049e7fec70000000000000000000000000000000000000000000000000000000278aaebf5a1daf3043727e59388974da7172cf5311344a2ed80c655ecb6d897ad1a466909000000000000000000000000d0b4c3ac8a50b6f1b3949adaf55cc9805620eb57 | null | null | 126 | 1740171660 | 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 |