Enriched Transactions
Chain
Dataset name
fantom.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 | receipt_root_hash | receipt_l1_fee | receipt_l1_gas_used | receipt_l1_gas_price | receipt_l1_fee_scalar |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| enriched_transaction_0x0001332c00001036f268be042d859b52b27caae1f11b78c2243395c4d878fc5d_0 | 0xb750f998316746d286427c77ce39d98d3133d920a6a01a5bd97bdb6322fb3b29 | 3040 | 0x0001332c00001036f268be042d859b52b27caae1f11b78c2243395c4d878fc5d | 30030459 | 0 | 0xe2255aea86b7b11ca757f9721478008c599d4014 | 0x1cc765cd7badf46a215bd142846595594ad4ffe3 | 0 | 131386 | 426129600000 | 0x8dbdbe6d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000089996acb6faafd0ae000000000000000000000000e2255aea86b7b11ca757f9721478008c599d4014 | null | null | 0 | 1644025592 | 76970 | 76970 | null | 1 | 426129600000 | null | null | null | null | null | null |
| enriched_transaction_0x0001332c0000104607713770727122a2fe9c65dd62d3b54dec7b3255c43f222f_5 | 0xdfaf745da80b1dd61085247da59675a11cd9699ad12b55f66cf7c0f6360f38a7 | 16 | 0x0001332c0000104607713770727122a2fe9c65dd62d3b54dec7b3255c43f222f | 30030461 | 5 | 0xba4201c7b3cd34319c1277834884e8ba8c8a51c5 | 0xf491e7b69e4244ad4002bc14e878a34207e38c29 | 0 | 267092 | 426315200000 | 0x38ed1739000000000000000000000000000000000000000000000001981ff070bc10f5cf0000000000000000000000000000000000000000000000056c5029325351c03c00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000ba4201c7b3cd34319c1277834884e8ba8c8a51c50000000000000000000000000000000000000000000000000000000061fde9aa000000000000000000000000000000000000000000000000000000000000000300000000000000000000000014def7584a6c52f470ca4f4b9671056b22f4ffde00000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c830000000000000000000000007a6e4e3cc2ac9924605dca4ba31d1831c84b44ae | null | null | 0 | 1644025593 | 678814 | 179043 | null | 1 | 426315200000 | 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 |