| day_agg | Day when the fee stats were aggregated. | DATE | | Yes | |
| total_fee_charged | Sum of fee_charged across all transactions (Classic + Soroban) for the day. | INTEGER | | Yes | |
| max_fee_charged | Maximum fee_charged across all transactions (Classic + Soroban) for the day. | INTEGER | | Yes | |
| txn_count | Total number of transactions (Classic + Soroban) for the day. | INTEGER | | Yes | |
| failed_txn_count | Number of failed transactions (Classic + Soroban) for the day. Failed transactions are still included in all fee aggregates because inclusion_fee_charged and non_refundable_resource_fee_charged are charged regardless of transaction success. | INTEGER | | No | |
| total_effective_txn_operation_count | Total number of effective operations across all transactions for the day. Uses effective_txn_operation_count, which adds 1 for fee-bump transactions to account for the extra inner transaction. | INTEGER | | Yes | |
| total_raw_txn_operation_count | Total number of raw operations (txn_operation_count) across all transactions for the day. Unlike effective operation count, this does NOT include fee-bump transactions. | INTEGER | | Yes | |
| min_ledger_sequence | First (minimum) ledger sequence number for the day. | INTEGER | | Yes | |
| max_ledger_sequence | Last (maximum) ledger sequence number for the day. | INTEGER | | Yes | |
| total_ledgers | Total number of ledgers processed for the day, regardless of whether they contain Classic or Soroban transactions. Used as the denominator for total_pct_ledgers_in_surge. | INTEGER | | Yes | |
| classic_txn_count | Number of Classic transactions for the day. Classic transactions have resource_fee = 0. | INTEGER | | No | |
| classic_failed_txn_count | Number of failed Classic transactions for the day. | INTEGER | | No | |
| classic_total_effective_operation_count | Total number of effective operations across Classic transactions for the day. Adds 1 for fee-bump transactions. | INTEGER | | No | |
| classic_total_raw_operation_count | Total number of raw operations across Classic transactions for the day. Does NOT include fee-bump transactions. | INTEGER | | No | |
| classic_sum_fee_charged | Sum of fee_charged across Classic transactions for the day. For Classic txns, fee_charged is the inclusion fee (no resource_fee component). | INTEGER | | No | |
| classic_max_fee_charged | Maximum fee_charged across Classic transactions for the day. | INTEGER | | No | |
| classic_sum_max_fee | Sum of COALESCE(new_max_fee, max_fee) across Classic transactions for the day. Represents total willingness-to-pay. | INTEGER | | No | |
| classic_max_max_fee | Maximum of COALESCE(new_max_fee, max_fee) across Classic transactions for the day. | INTEGER | | No | |
| classic_max_inclusion_fee_per_op | Maximum inclusion fee per operation (fee_charged / effective_txn_operation_count) across Classic transactions for the day. | FLOAT | | No | |
| classic_min_inclusion_fee_per_op | Minimum inclusion fee per operation across Classic transactions for the day. | FLOAT | | No | |
| classic_total_ledgers | Total number of ledgers containing at least one Classic transaction for the day. | INTEGER | | No | |
| classic_surge_ledger_count | Number of ledgers where at least one Classic transaction experienced surge pricing for the day. | INTEGER | | No | |
| classic_total_surge_txn_count | Total number of Classic transactions that experienced surge pricing across all ledgers for the day. | INTEGER | | No | |
| classic_total_surge_operation_count | Total operations in Classic transactions that experienced surge pricing across all ledgers for the day. | INTEGER | | No | |
| classic_pct_ledgers_in_surge | Percentage of Classic-containing ledgers that experienced surge pricing for the day. Calculated as 100 * classic_surge_ledger_count / classic_total_ledgers. | FLOAT | | No | |
| soroban_txn_count | Number of Soroban transactions for the day. Soroban transactions have resource_fee > 0. | INTEGER | | No | |
| soroban_failed_txn_count | Number of failed Soroban transactions for the day. Even failed Soroban transactions are charged inclusion_fee_charged and non_refundable_resource_fee_charged, so they are included in all fee aggregates. | INTEGER | | No | |
| soroban_total_effective_operation_count | Total number of effective operations across Soroban transactions for the day. Adds 1 for fee-bump transactions. | INTEGER | | No | |
| soroban_total_raw_operation_count | Total number of raw operations across Soroban transactions for the day. Does NOT include fee-bump transactions. | INTEGER | | No | |
| soroban_sum_fee_charged | Sum of fee_charged across Soroban transactions for the day. fee_charged = inclusion_fee_charged + non_refundable_resource_fee_charged + refundable_resource_fee_charged. | INTEGER | | No | |
| soroban_max_fee_charged | Maximum fee_charged across Soroban transactions for the day. | INTEGER | | No | |
| soroban_sum_inclusion_fee_charged | Sum of inclusion_fee_charged across Soroban transactions for the day. The base inclusion fee is 100 stroops per operation. If inclusion_fee_charged exceeds this base, the ledger experienced inclusion fee surge pricing. | INTEGER | | No | |
| soroban_max_inclusion_fee_charged | Maximum inclusion_fee_charged across Soroban transactions for the day. | INTEGER | | No | |
| soroban_sum_inclusion_fee_bid | Sum of inclusion_fee_bid across Soroban transactions for the day. inclusion_fee_bid = COALESCE(new_max_fee, max_fee) - resource_fee. | INTEGER | | No | |
| soroban_max_inclusion_fee_bid | Maximum inclusion_fee_bid across Soroban transactions for the day. | INTEGER | | No | |
| soroban_max_inclusion_fee_per_op | Maximum inclusion fee per operation (inclusion_fee_charged / effective_txn_operation_count) across Soroban transactions for the day. | FLOAT | | No | |
| soroban_min_inclusion_fee_per_op | Minimum inclusion fee per operation across Soroban transactions for the day. | FLOAT | | No | |
| soroban_sum_resource_fee | Sum of resource_fee (the pre-execution budget for Soroban resource consumption) across Soroban transactions for the day. | INTEGER | | No | |
| soroban_max_resource_fee | Maximum resource_fee across Soroban transactions for the day. | INTEGER | | No | |
| soroban_min_resource_fee | Minimum resource_fee across Soroban transactions for the day. | INTEGER | | No | |
| soroban_sum_non_refundable_resource_fee_charged | Sum of non_refundable_resource_fee_charged across Soroban transactions for the day. Covers CPU instructions, read bytes, write bytes, and bandwidth. Charged based on declared resources regardless of tx success/failure. | INTEGER | | No | |
| soroban_max_non_refundable_resource_fee_charged | Maximum non_refundable_resource_fee_charged across Soroban transactions for the day. | INTEGER | | No | |
| soroban_min_non_refundable_resource_fee_charged | Minimum non_refundable_resource_fee_charged across Soroban transactions for the day. | INTEGER | | No | |
| soroban_sum_refundable_resource_fee_charged | Sum of refundable_resource_fee_charged across Soroban transactions for the day. Covers rent, events, and return value. Based on actual usage; 0 for failed transactions. | INTEGER | | No | |
| soroban_max_refundable_resource_fee_charged | Maximum refundable_resource_fee_charged across Soroban transactions for the day. | INTEGER | | No | |
| soroban_min_refundable_resource_fee_charged | Minimum refundable_resource_fee_charged across Soroban transactions for the day. | INTEGER | | No | |
| soroban_sum_resource_fee_refund | Sum of resource_fee_refund across Soroban transactions for the day. NOTE: Currently broken -- always 0. | INTEGER | | No | |
| soroban_max_resource_fee_refund | Maximum resource_fee_refund across Soroban transactions for the day. NOTE: Currently broken -- always 0. | INTEGER | | No | |
| soroban_min_resource_fee_refund | Minimum resource_fee_refund across Soroban transactions for the day. NOTE: Currently broken -- always 0. | INTEGER | | No | |
| soroban_sum_rent_fee_charged | Sum of rent_fee_charged across Soroban transactions for the day. This is the portion of refundable_resource_fee_charged that went to ledger entry TTL extensions. | INTEGER | | No | |
| soroban_max_rent_fee_charged | Maximum rent_fee_charged across Soroban transactions for the day. | INTEGER | | No | |
| soroban_min_rent_fee_charged | Minimum rent_fee_charged across Soroban transactions for the day. | INTEGER | | No | |
| soroban_total_ledgers | Total number of ledgers containing at least one Soroban transaction for the day. | INTEGER | | No | |
| soroban_surge_ledger_count | Number of ledgers where at least one Soroban transaction experienced surge pricing for the day. | INTEGER | | No | |
| soroban_total_surge_txn_count | Total number of Soroban transactions that experienced surge pricing across all ledgers for the day. | INTEGER | | No | |
| soroban_total_surge_operation_count | Total operations in Soroban transactions that experienced surge pricing across all ledgers for the day. | INTEGER | | No | |
| soroban_pct_ledgers_in_surge | Percentage of Soroban-containing ledgers that experienced surge pricing for the day. Calculated as 100 * soroban_surge_ledger_count / soroban_total_ledgers. | FLOAT | | No | |
| total_pct_ledgers_in_surge | Percentage of all ledgers for the day where at least one transaction (Classic or Soroban) experienced surge pricing. | FLOAT | | No | |
| fee_pool | Sum of fee_pool across all ledgers for the day. Represents all fees collected across the network for the day. | INTEGER | | No | |
| airflow_start_ts | Timestamp when the Airflow DAG run started. Used for pipeline metadata and debugging. | STRING | | No | |