Enriched Transactions
Chain
FlareDataset name
flare.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_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_0x9f20e9c08257391ab5baf7dbbbcbac618edd519058b5af8842664b623635d155_0 | 0x80e4bc5a0a7651bc92638bd6e2d96f6f2f6d7d9a3a00f8905e6b585282114a7d | 0 | 0x9f20e9c08257391ab5baf7dbbbcbac618edd519058b5af8842664b623635d155 | 5 | 0 | 0xfffec6c83c8bf5c3f4ae0ccf8c45ce20e4560bd7 | 0x1000000000000000000000000000000000000002 | 0 | 0 | 0x689c499900000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000 | null | null | 0 | 1657740819 | 0 | 0 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | |
| enriched_transaction_v2_0x3fbc5aa5031edc431aec7e5f368b6b6f8a417958e270fd78e9bef51f7632a3d5_0 | 0xa41b41060e5fd5fa8353178baaa14d71d79bbd295cbb5fc444df6b27e40932de | 1 | 0x3fbc5aa5031edc431aec7e5f368b6b6f8a417958e270fd78e9bef51f7632a3d5 | 6 | 0 | 0xfffec6c83c8bf5c3f4ae0ccf8c45ce20e4560bd7 | 0x1000000000000000000000000000000000000002 | 0 | 0x5042916c000000000000000000000000000000000000000000000000000000000000001e | null | null | 0 | 1657740822 | null | 1 | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | ||||
| enriched_transaction_v2_0x4eacf52f66653038ea29fbdfbe4fc9ec0673569f5eda7af8aad12c38779dd288_0 | 0x725afe85f9a3c1731080faab9bbd80975dbee99823d5251f45e6989927939172 | 15 | 0x4eacf52f66653038ea29fbdfbe4fc9ec0673569f5eda7af8aad12c38779dd288 | 22 | 0 | 0x4598a6c05910ab914f0cbaaca1911cd337d10d29 | 0x260371e0cf561887c6da270cc3be84c2fab5444f | 0 | 0 | 0xb2d9e8060000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000010000000000000000000000006d55e24dc2d3bd2fc5ae1fccd1a73bc5f18a8a3000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000002710 | null | null | 0 | 1657740884 | 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 |