Enriched Transactions
Chain
RoninDataset name
ronin.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_0x1b7f03516502fd93c9b84690c1c868d02fb7d8d08a89bb61c370653a6eacb300_19 | 0xbf67c26758c78c959bad37551e152150695f40e18ec8b814d9f52c1220b5ad82 | 110 | 0x1b7f03516502fd93c9b84690c1c868d02fb7d8d08a89bb61c370653a6eacb300 | 47196005 | 19 | 0x0e0bb2e404a6a8244a0f12ecafbdcec4aba5e471 | 0x19f70ecd63f40f11716c3ce2b50a6d07491c12fe | 0 | 0 | 0xd85d3d270000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000002a30783045306242324534303441364138323434613046313245634146624463654334414261356534373100000000000000000000000000000000000000000000 | 0 | 0 | 2 | 1753447879 | 1 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0xec44e1c05e8f4fdaa8ae635fabd8bd49640da5dbec94dd37bba2a63067b74988_3 | 0x4c76192a612c46678f4882283deb23763049520f9c0f77f102d16fba792c0bda | 62 | 0xec44e1c05e8f4fdaa8ae635fabd8bd49640da5dbec94dd37bba2a63067b74988 | 47196007 | 3 | 0xa98914aa35c6d07ad6397620cc109312f716ffb5 | 0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef5 | 0 | 0x095ea7b3000000000000000000000000771ca29e483df5447e20a89e0f00e1daf09ef534ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff | 0 | 0 | 2 | 1753447885 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |||
| enriched_transaction_v2_0x19e46ebc83b25ef2f0cb1ab0d8f94e8380193297c401893bfd58110720fb9879_1 | 0x47b8f7b1c436446b06fe5a8f547a16f7ad01801a1dda117ac974f6fb8c78e1e6 | 15073 | 0x19e46ebc83b25ef2f0cb1ab0d8f94e8380193297c401893bfd58110720fb9879 | 47196008 | 1 | 0x00c4d20a2ddc49dafe1c6b3ed8ebc962679240f1 | 0xd6d11474eb323521ada927f14a4b839b90009ac8 | 0 | 0 | 0xae6a2ef4000000000000000000000000000000000000000000000000000000000001a1130000000000000000000000003b93f96c350b7478633a08fe88f26538c05e8453000000000000000000000000000000000000000000000000000000006a64b1470000000000000000000000000000000000000000000000000000000000000001 | 0 | 0 | 2 | 1753447888 | 0 | 0 | null | 1 | 0 | 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 |