Enriched Transactions
Chain
AvalancheDataset name
avalanche.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_0xb550d35189c5a94e3bd891fa9243b521bbdaa1ad78d6e058f09e320b214853d3_1 | 0x6feb537a3d0dc27d1ece08753ba36f604aa88ce99ca7b06bdcac19f449983457 | 710367 | 0xb550d35189c5a94e3bd891fa9243b521bbdaa1ad78d6e058f09e320b214853d3 | 45671836 | 1 | 0x0d0707963952f2fba59dd06f2b425ace40b492fe | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 0 | 1000000 | 32500000000 | 0xa9059cbb000000000000000000000000056ba7ece645568118d913def1a7c1d86187b3d800000000000000000000000000000000000000000000000000000000ac150a20 | null | null | 0 | 1716203171 | 169903 | 61138 | null | 1 | 32500000000 | null | null | null | null | null | null |
| enriched_transaction_0x2a21c7d95702b340d4c112ea24b963de9a87857ba2917d2c1c75892899851e63_0 | 0x165564d0a85a9646c59a25d1d812cd1e14d7aeeb71dd47a393de2df1b50217dc | 0 | 0x2a21c7d95702b340d4c112ea24b963de9a87857ba2917d2c1c75892899851e63 | 45671865 | 0 | 0x31e805c30c4587c9a89f94c6fbdca52e56ec8e8d | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 0 | 70000 | 31000000000 | 0xa9059cbb0000000000000000000000007e4aa755550152a522d9578621ea22edab20430800000000000000000000000000000000000000000000000000000000001c61a0 | 54000000000 | 6000000000 | 2 | 1716203233 | 44026 | 44026 | null | 1 | 31000000000 | 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 |