| hour_agg | Hour-truncated UTC timestamp of the aggregation window. Derived from timestamp_trunc(closed_at, hour). | TIMESTAMP | | Yes | |
| contract_id | The Soroban smart contract address invoked by the transaction. | STRING | | Yes | |
| txn_count | Total number of Soroban transactions invoking this contract in the hour. | INTEGER | | Yes | |
| failed_txn_count | Number of failed Soroban transactions for this contract in the hour. Failed transactions are still charged inclusion_fee_charged and non_refundable_resource_fee_charged. | INTEGER | | No | |
| unique_fee_source_accounts | Count of distinct fee-paying accounts for this contract in the hour. For fee-bump transactions this is the fee sponsor; for regular transactions this is the transaction originator. Useful for distinguishing between a single account driving a contract's fee volume vs. broad usage. | INTEGER | | Yes | |
| total_fee_charged | Sum of fee_charged across all transactions invoking this contract in the hour. | INTEGER | | Yes | |
| avg_fee_charged | Average fee_charged per transaction invoking this contract in the hour. | FLOAT | | No | |
| max_fee_charged | Maximum fee_charged across transactions invoking this contract in the hour. | INTEGER | | No | |
| total_max_fee | Sum of the effective fee ceiling -- coalesce(new_max_fee, max_fee) -- across transactions invoking this contract. For fee-bump transactions, new_max_fee is the actual ceiling used by the network; max_fee is the inner transaction's original max. Represents total willingness-to-pay. | INTEGER | | No | |
| fee_efficiency | Ratio of total_fee_charged to total_max_fee. Bounded (0, 1]. Values closer to 1.0 indicate callers are bidding close to what they actually pay; lower values indicate overbidding. | FLOAT | | No | |
| total_inclusion_fee_charged | Sum of inclusion_fee_charged across transactions invoking this contract. | INTEGER | | No | |
| avg_inclusion_fee_charged | Average inclusion_fee_charged per transaction invoking this contract. | FLOAT | | No | |
| total_inclusion_fee_bid | Sum of inclusion_fee_bid across transactions invoking this contract. Represents total willingness-to-pay for inclusion. | INTEGER | | No | |
| total_resource_fee | Sum of resource_fee (pre-execution budget) across transactions invoking this contract. | INTEGER | | No | |
| avg_resource_fee | Average resource_fee per transaction invoking this contract. | FLOAT | | No | |
| total_non_refundable_resource_fee | Sum of non_refundable_resource_fee_charged across transactions. Covers CPU instructions, read bytes, write bytes, and bandwidth. Charged regardless of tx success/failure. | INTEGER | | No | |
| total_refundable_resource_fee | Sum of refundable_resource_fee_charged across transactions. Covers rent, events, and return value. Based on actual usage; 0 for failed transactions. | INTEGER | | No | |
| total_rent_fee | Sum of rent_fee_charged across transactions. The portion of refundable_resource_fee_charged that went to ledger entry TTL extensions. | INTEGER | | No | |
| total_resource_fee_refund | Sum of resource_fee_refund across transactions. Represents the unused portion of resource_fee returned to the account after execution. | INTEGER | | No | |
| surge_txn_count | Number of Soroban transactions for this contract where inclusion_fee_charged exceeded the base fee (effective_operation_count * 100 stroops), indicating surge pricing. | INTEGER | | No | |
| airflow_start_ts | Timestamp when the Airflow DAG run started. Used for pipeline metadata and debugging. | STRING | | No | |