Enriched Transactions
Chain
XlayerDataset name
xlayer.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 | receipt_root_hash | receipt_l1_fee | receipt_l1_gas_used | receipt_l1_gas_price | receipt_l1_fee_scalar |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_0xbb0c09392cadf3cef5b50575f28ae05d622292f71707ac1b0831ec0c83bb067f_1 | 0xc27aaaae87be42a0ebef5d5c73fe20a0317cd00cceaeb764189bb5215dbe4238 | 952403 | 0xbb0c09392cadf3cef5b50575f28ae05d622292f71707ac1b0831ec0c83bb067f | 34974801 | 1 | 0xaef7197e050a8eac5f94ea335d97847dd0a77fd4 | 0x8aac0ac3d851b278af6f9da2e4b78428233f603c | õá | 0x | null | null | 0 | 1757441136 | ¬ | " | null | 1 | õá | null | null | null | null | null | null | ||
| enriched_transaction_0x8fa4b4d15b20fd920fc3b75a603661d87f96a1b46186ecb84567a4a6609f39b7_3 | 0xce774108025173445be2a7b76ac8ab18170490b7370a9d378db37219127389b2 | 455849 | 0x8fa4b4d15b20fd920fc3b75a603661d87f96a1b46186ecb84567a4a6609f39b7 | 34974817 | 3 | 0xc6ca61e3ce26ffd31fb91ed61579536bca27df0c | 0x164d9b632f0eca9c47e52fe4f8467e4d9eb5149c | TÅc | õá | 0x290c05ea000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000080000000000000000000000003ea2a2f97a8bf3bbb1a3539bce45c612982ea9bf00000000000000000000000007acace793c28a3936645c1906cea701dd757f04000000000000000000000000c71f9e1de80eb505c0cb3bbf90ae6593130e5d2500000000000000000000000032d6b77ee026d471c191ea9ef9ed404d2cb4d4a60000000000000000000000004e6c7d221b5fa285aabdd8c7fa692bc0c79e7d8b000000000000000000000000d352a852a328d7eccc8bbf63e2e1dd73c68527cd000000000000000000000000fb43803eaf41a516c062e7cfb9d77c65c523590700000000000000000000000076451ea2075ef09f0e31ea86204547ac0caf3647 | null | null | 0 | 1757441144 | rH | n | null | 1 | õá | null | null | null | null | null | null | |
| enriched_transaction_0x7ae7fa8787adc7644ea7e2259ffc6a43e7431877edbc931ddb84ea243449bf5c_4 | 0x562fa3bf34d1f675a46a4e7f0e1cf4e0e14475fdd51f4ec0d7f50e487ac74506 | 41181 | 0x7ae7fa8787adc7644ea7e2259ffc6a43e7431877edbc931ddb84ea243449bf5c | 34974819 | 4 | 0x420696ba3d5dd672e2745eaf6ad843fb976a09bd | 0x6a9aac7c08d6f4a61e6c871cf60d3d89aac64e88 | -ÆÀ | 0x00042069000003011e4926cd769a0be1723bffc53825edc9144f33db7fe538905cf8410324e03a5a23c1c177a474d59b2b001eec424d742561b18e7b2a846a03aaf8d005b71aac5a94df4c0777514b6a0cc95d9bca66afcca667f6073d5115951c47f4 | null | null | 0 | 1757441145 | ¦ | §R | null | 0 | 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 | long |
| receipt_root_hash | string |
| receipt_l1_fee | decimal |
| receipt_l1_gas_used | decimal |
| receipt_l1_gas_price | decimal |
| receipt_l1_fee_scalar | double |