> ## Documentation Index
> Fetch the complete documentation index at: https://developers.stellar.org/llms.txt
> Use this file to discover all available pages before exploring further.

# Hourly Fee Agg Account

> Reference documentation for the Hourly Fee Agg Account table in Hubble's Gold data dictionary.

## Table Metadata

| Property | Configuration |
| - | - |
| Natural Key(s) | hour\_agg, fee\_source\_account |
| Partition Field(s) | hour\_agg (DAY partition) |
| Clustered Field(s) | hour\_agg, fee\_source\_account |
| Documentation | [dbt docs](http://www.stellar-dbt-docs.com/#!/model/model.stellar_dbt_public.hourly_fee_agg_account) |

## Column Details

| Name | Description | Data Type | Domain Values | Required? | Notes |
| - | - | - | - | - | - |
| 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 | |