| day_agg | Day when the ledger fee stats were aggregated. | DATE | | Yes | |
| ledger_sequence | The unique ledger sequence number. This is the grain of the table -- one row per ledger. | INTEGER | | Yes | |
| total_fee_charged | Sum of fee_charged across all transactions (Classic + Soroban) in the ledger. This is the total fees actually paid. | INTEGER | | Yes | |
| max_fee_charged | Maximum fee_charged across all transactions (Classic + Soroban) in the ledger. | INTEGER | | Yes | |
| txn_count | Total number of transactions (Classic + Soroban) in the ledger. | INTEGER | | Yes | |
| failed_txn_count | Number of failed transactions (Classic + Soroban) in the ledger. 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 in the ledger. 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 in the ledger. Unlike effective operation count, this does NOT include fee-bump transactions. | INTEGER | | Yes | |
| classic_txn_count | Number of Classic transactions in the ledger. Classic transactions have resource_fee = 0. | INTEGER | | No | |
| classic_failed_txn_count | Number of failed Classic transactions in the ledger. | INTEGER | | No | |
| classic_total_effective_operation_count | Total number of effective operations across Classic transactions in the ledger. Adds 1 for fee-bump transactions. | INTEGER | | No | |
| classic_total_raw_operation_count | Total number of raw operations across Classic transactions in the ledger. Does NOT include fee-bump transactions. | INTEGER | | No | |
| classic_sum_fee_charged | Sum of fee_charged across Classic transactions. 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 in the ledger. | INTEGER | | No | |
| classic_sum_max_fee | Sum of COALESCE(new_max_fee, max_fee) across Classic transactions. Represents total willingness-to-pay. | INTEGER | | No | |
| classic_max_max_fee | Maximum of COALESCE(new_max_fee, max_fee) across Classic transactions in the ledger. | INTEGER | | No | |
| classic_max_inclusion_fee_per_op | Maximum inclusion fee per operation (fee_charged / effective_txn_operation_count) across Classic transactions. Fee-bump txns add 1 to the operation count. | FLOAT | | No | |
| classic_min_inclusion_fee_per_op | Minimum inclusion fee per operation across Classic transactions in the ledger. | FLOAT | | No | |
| classic_surge_txn_count | Number of Classic transactions in the ledger where fee_charged exceeded the base fee (100 stroops per operation), indicating surge pricing. | INTEGER | | No | |
| classic_surge_operation_count | Total operations in Classic transactions that experienced surge pricing in the ledger. | INTEGER | | No | |
| classic_is_surge_ledger | True if any Classic transaction in the ledger experienced surge pricing. | BOOLEAN | | No | |
| soroban_txn_count | Number of Soroban transactions in the ledger. Soroban transactions have resource_fee > 0. | INTEGER | | No | |
| soroban_failed_txn_count | Number of failed Soroban transactions in the ledger. 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 in the ledger. Adds 1 for fee-bump transactions. | INTEGER | | No | |
| soroban_total_raw_operation_count | Total number of raw operations across Soroban transactions in the ledger. Does NOT include fee-bump transactions. | INTEGER | | No | |
| soroban_sum_fee_charged | Sum of fee_charged across Soroban transactions. 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 in the ledger. | INTEGER | | No | |
| soroban_sum_inclusion_fee_charged | Sum of inclusion_fee_charged across Soroban transactions. 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 in the ledger. | INTEGER | | No | |
| soroban_sum_inclusion_fee_bid | Sum of inclusion_fee_bid across Soroban transactions. 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 in the ledger. | INTEGER | | No | |
| soroban_max_inclusion_fee_per_op | Maximum inclusion fee per operation (inclusion_fee_charged / effective_txn_operation_count) across Soroban transactions in the ledger. | FLOAT | | No | |
| soroban_min_inclusion_fee_per_op | Minimum inclusion fee per operation across Soroban transactions in the ledger. | FLOAT | | No | |
| soroban_sum_resource_fee | Sum of resource_fee (the pre-execution budget for Soroban resource consumption) across Soroban transactions in the ledger. | INTEGER | | No | |
| soroban_max_resource_fee | Maximum resource_fee across Soroban transactions in the ledger. | INTEGER | | No | |
| soroban_min_resource_fee | Minimum resource_fee across Soroban transactions in the ledger. | INTEGER | | No | |
| soroban_sum_non_refundable_resource_fee_charged | Sum of non_refundable_resource_fee_charged across Soroban transactions. 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 in the ledger. | INTEGER | | No | |
| soroban_min_non_refundable_resource_fee_charged | Minimum non_refundable_resource_fee_charged across Soroban transactions in the ledger. | INTEGER | | No | |
| soroban_sum_refundable_resource_fee_charged | Sum of refundable_resource_fee_charged across Soroban transactions. 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 in the ledger. | INTEGER | | No | |
| soroban_min_refundable_resource_fee_charged | Minimum refundable_resource_fee_charged across Soroban transactions in the ledger. | INTEGER | | No | |
| soroban_sum_resource_fee_refund | Sum of resource_fee_refund across Soroban transactions. NOTE: Currently broken -- always 0. | INTEGER | | No | |
| soroban_max_resource_fee_refund | Maximum resource_fee_refund across Soroban transactions. NOTE: Currently broken -- always 0. | INTEGER | | No | |
| soroban_min_resource_fee_refund | Minimum resource_fee_refund across Soroban transactions. NOTE: Currently broken -- always 0. | INTEGER | | No | |
| soroban_sum_rent_fee_charged | Sum of rent_fee_charged across Soroban transactions. 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 in the ledger. | INTEGER | | No | |
| soroban_min_rent_fee_charged | Minimum rent_fee_charged across Soroban transactions in the ledger. Will be 0 for ledgers where all Soroban transactions failed. | INTEGER | | No | |
| soroban_surge_txn_count | Number of Soroban transactions in the ledger where inclusion_fee_charged exceeded the base fee (100 stroops per operation), indicating surge pricing. | INTEGER | | No | |
| soroban_surge_operation_count | Total operations in Soroban transactions that experienced surge pricing in the ledger. | INTEGER | | No | |
| soroban_is_surge_ledger | True if any Soroban transaction in the ledger experienced surge pricing. | BOOLEAN | | No | |
| closed_at | Timestamp in UTC when the ledger closed and was committed to the network. Sourced from history_ledgers. | TIMESTAMP | | No | |
| fee_pool | The total fee pool for the ledger, sourced from history_ledgers. | INTEGER | | No | |
| airflow_start_ts | Timestamp when the Airflow DAG run started. Used for pipeline metadata and debugging. | STRING | | No | |