| hour_agg | Hour-truncated UTC timestamp of the aggregation window. Derived from timestamp_trunc(closed_at, hour). | TIMESTAMP | | Yes | |
| fee_source_account | The account that paid the transaction fee. For fee-bump transactions, this is the fee sponsor (fee_account). For non-fee-bump transactions, this is the transaction originator (txn_account). | STRING | | Yes | |
| txn_count | Total number of transactions (Classic + Soroban) submitted by this fee_source_account in the hour. | INTEGER | | Yes | |
| failed_txn_count | Number of failed transactions (Classic + Soroban) for this fee_source_account in the hour. Failed transactions are still charged fees and included in all fee aggregates. | INTEGER | | No | |
| total_fee_charged | Sum of fee_charged across all transactions (Classic + Soroban) for this fee_source_account in the hour. This is the total fees actually paid. | INTEGER | | Yes | |
| total_max_fee | Sum of the effective fee ceiling -- coalesce(new_max_fee, max_fee) -- across all transactions for this fee_source_account in the hour. For fee-bump transactions, new_max_fee is the actual ceiling used by the network. Represents total willingness-to-pay. | INTEGER | | Yes | |
| fee_efficiency | Ratio of total_fee_charged to total_max_fee. Bounded (0, 1]. Values closer to 1.0 indicate the account is bidding close to what it actually pays; lower values indicate overbidding. | FLOAT | | No | |
| total_effective_operation_count | Total effective operations across all transactions for this fee_source_account. Adds 1 to the operation count for fee-bump transactions. | INTEGER | | Yes | |
| total_raw_operation_count | Total raw operations (txn_operation_count) across all transactions for this fee_source_account. Does NOT include fee-bump adjustment. | INTEGER | | Yes | |
| classic_txn_count | Number of Classic transactions for this fee_source_account in the hour. Classic transactions have resource_fee = 0. | INTEGER | | No | |
| classic_failed_txn_count | Number of failed Classic transactions for this fee_source_account in the hour. | INTEGER | | No | |
| classic_total_fee_charged | Sum of fee_charged across Classic transactions for this fee_source_account. For Classic txns, fee_charged is the inclusion fee (no resource_fee component). NULL if the account had no Classic transactions in this hour. | INTEGER | | No | |
| classic_total_max_fee | Sum of the effective fee ceiling -- coalesce(new_max_fee, max_fee) -- across Classic transactions for this fee_source_account. Represents Classic willingness-to-pay. NULL if the account had no Classic transactions in this hour. | INTEGER | | No | |
| classic_total_effective_operation_count | Total effective operations across Classic transactions for this fee_source_account. Adds 1 for fee-bump transactions. NULL if the account had no Classic transactions in this hour. | INTEGER | | No | |
| classic_surge_txn_count | Number of Classic transactions for this fee_source_account where fee_charged exceeded the base fee (effective_operation_count * 100 stroops), indicating surge pricing. | INTEGER | | No | |
| soroban_txn_count | Number of Soroban transactions for this fee_source_account in the hour. Soroban transactions have resource_fee > 0. | INTEGER | | No | |
| soroban_failed_txn_count | Number of failed Soroban transactions for this fee_source_account in the hour. Even failed Soroban transactions are charged inclusion_fee_charged and non_refundable_resource_fee_charged. | INTEGER | | No | |
| soroban_total_fee_charged | Sum of fee_charged across Soroban transactions for this fee_source_account. fee_charged = inclusion_fee_charged + non_refundable_resource_fee_charged + refundable_resource_fee_charged - resource_fee_refund. NULL if the account had no Soroban transactions in this hour. | INTEGER | | No | |
| soroban_total_inclusion_fee_charged | Sum of inclusion_fee_charged across Soroban transactions for this fee_source_account. NULL if the account had no Soroban transactions in this hour. | INTEGER | | No | |
| soroban_total_inclusion_fee_bid | Sum of inclusion_fee_bid across Soroban transactions for this fee_source_account. Represents total willingness-to-pay for inclusion. NULL if the account had no Soroban transactions in this hour. | INTEGER | | No | |
| soroban_total_resource_fee | Sum of resource_fee (pre-execution budget) across Soroban transactions for this fee_source_account. NULL if the account had no Soroban transactions in this hour. | INTEGER | | No | |
| soroban_total_non_refundable_resource_fee | Sum of non_refundable_resource_fee_charged across Soroban transactions. Covers CPU instructions, read bytes, write bytes, and bandwidth. Charged regardless of tx success/failure. NULL if the account had no Soroban transactions in this hour. | INTEGER | | No | |
| soroban_total_refundable_resource_fee | Sum of refundable_resource_fee_charged across Soroban transactions. Covers rent, events, and return value. Based on actual usage; 0 for failed transactions. NULL if the account had no Soroban transactions in this hour. | INTEGER | | No | |
| soroban_total_rent_fee | Sum of rent_fee_charged across Soroban transactions. The portion of refundable_resource_fee_charged that went to ledger entry TTL extensions. NULL if the account had no Soroban transactions in this hour. | INTEGER | | No | |
| soroban_total_resource_fee_refund | Sum of resource_fee_refund across Soroban transactions. Represents the unused portion of resource_fee returned to the account after execution. NULL if the account had no Soroban transactions in this hour. | INTEGER | | No | |
| soroban_total_effective_operation_count | Total effective operations across Soroban transactions for this fee_source_account. Adds 1 for fee-bump transactions. NULL if the account had no Soroban transactions in this hour. | INTEGER | | No | |
| soroban_surge_txn_count | Number of Soroban transactions for this fee_source_account 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 | |