{"data_mode":"postgres_live","fallback_active":false,"api_version":"1.1.0","source":"sterling-market-canonical/pools","execution_network":"solana-mainnet-beta","canonical_pair_id":"STM-SJBCUSD","control_chain_id":1492,"control_chain_role":"Sterling orchestration/runtime chain; not a Solana JSON-RPC endpoint","control_chain_rpc_compatible":false,"timestamp_exact":"2026-06-29 21:39:31.934+00","proof_scope":"pool_catalog","schema":"sterling_market_pools_v1","count":3,"pools":[{"pool_id":"BbvR4zUAwZF8LmVFLXNpDy3CxuYcDwd5isoh7CZFAF5G","program_id":"7v9sLrk92NNLLUfXLJw3o7MycZNvwsTK6kLWfWb8vcVA","pair_id":"STM-SJBCUSD","pair_slug":"stm-sjbcusd","quote_onchain_symbol":"SJBC","quote_public_symbol":"SJBCUSD","quote_public_label":"SJBC USD","enabled":true,"lp_mint":"G94nkBm4ntjiEHNzTpd7GRW9J8H5rqrhW83k5RSHZrBZ","canonical_lp_mint":"G94nkBm4ntjiEHNzTpd7GRW9J8H5rqrhW83k5RSHZrBZ","legacy_fee_token_mint":"DnepvMafJZzDtDcevrqbMUCmDqdNhBLjCTUu1xhR4HeL","base_vault":"3mRYBWgBKnQuUyvVDcYFqSeNoQTujTsFGra3GWLof9av","quote_vault":"5z4brtXmcDBhPKLk9YoiZE7fqaourBk26jBuAUHqZDN9","htop_stm_reserve_ata":"2CRon3SyMyvy2i7hourX99kiuoTKpLgQ3ebogrpfDorq","htop_sjbc_reserve_ata":"HEy89xU9gkEi9FXGLvzT61i3pM2kTW5MzvqcCDsB7EmQ","base_vault_balance":"14132.214084464","quote_vault_balance":"1311627719.002127473","htop_stm_balance":"18445685321.786058706","htop_sjbc_balance":"15566034779.287972149","current_live_price_usd":"92811.197959705566907","price_gross_usd":"92811.197959705566907","price_net_usd":"88170.63806172","fee_bps":500,"fee_rate":0.05,"current_live_floor_price_usd":"92500.000000002150","floor_locked":true,"swaps_total":115,"volume_24h_usd":"0","volume_7d_usd":"0","volume_cumulative_usd":"828969950.193183","fees_cumulative_usd":"41448497.509659","fees_paid_cumulative_usd":"41448497.509659","fees_collected_cumulative_usd":"41448497.509659","fees_base_cumulative_ui":"25000.000000002","fees_quote_cumulative_ui":"17959488.264621619","fees_unknown_cumulative_ui":"0","traders_estimated_total":58,"estimated_traders_total":58,"activity_totals":{"swaps_total":115,"volume_cumulative_usd":"828969950.193183","fees_cumulative_usd":"41448497.509659","fees_paid_cumulative_usd":"41448497.509659","fees_collected_cumulative_usd":"41448497.509659","fees_base_cumulative_ui":"25000.000000002","fees_quote_cumulative_ui":"17959488.264621619","fees_unknown_cumulative_ui":"0","traders_estimated":58,"traders_estimated_total":58,"estimated_traders_total":58,"traders_estimated_source":"current_active_snapshot.latest_timestamp","swaps_total_onchain":751,"swaps_total_reconstructed":115,"traders_total_estimated":58,"volume_cumulative_onchain":"54705353526.391375107","volume_cumulative_reconstructed":"828969950.193183","fees_cumulative_onchain_raw":"3129300958044.162054","fees_cumulative_reconstructed":"41448497.509659","onchain_exact":{"swaps_total_onchain":751,"volume_cumulative_onchain":"54705353526.391375107","fees_cumulative_onchain_raw":"3129300958044.162054","fees_paid_cumulative_onchain_raw":"3129300958044.162054","fees_collected_cumulative_onchain_raw":"3129300958044.162054","fees_expected_from_onchain_volume_usd":"2735267676.319569","fees_difference_vs_fee_policy_usd":"3126565690367.842773","fee_ratio_observed":"57.202828541","fee_ratio_expected":"0.05","coherence_status":"separated_due_to_fee_volume_mismatch","fees_base_cumulative_ui":"25000.000000002","fees_quote_cumulative_ui":"17959488.264621619","fees_unknown_cumulative_ui":"0"},"historical_reconstructed":{"current_active_snapshot":{"key":"may2026ActiveSnapshot","label":"828.97M","heading":"2 May 2026","time":"2026-05-02T23:08:53+00:00","current":true,"pool_id":"BbvR4zUAwZF8LmVFLXNpDy3CxuYcDwd5isoh7CZFAF5G","lp_token_mint":"G94nkBm4ntjiEHNzTpd7GRW9J8H5rqrhW83k5RSHZrBZ","base_vault_ui":"14132.216643482","quote_vault_ui":"1307230039.522111893","swaps_total":115,"traders_estimated":58,"volume_usd":"828969950.193183","fees_usd":"41448497.509659","fee_rate":0.05,"fee_bps":500,"implied_pair_price":"92500.000000002","snapshot_source":"sterling_live_session_summary","snapshot_reference":"swap_logs/fee_conversion_log.jsonl","fee_coherence":{"status":"coherent","expected_fees_usd":"41448497.509659","reported_fees_usd":"41448497.509659","difference_usd":"0"}},"historical_snapshots":[{"key":"longActivityDetailedSnapshot","label":"13.8k","heading":"5 Jan 2026","time":"2026-01-05T17:57:56+00:00","current":false,"pool_id":"BbvR4zUAwZF8LmVFLXNpDy3CxuYcDwd5isoh7CZFAF5G","lp_token_mint":"DnepvMafJZzDtDcevrqbMUCmDqdNhBLjCTUu1xhR4HeL","base_vault_ui":"1534849.052461396","quote_vault_ui":"0.00025","swaps_total":13839,"traders_estimated":10641,"volume_usd":"691950000","fees_usd":"34597500","fee_rate":0.05,"fee_bps":500,"implied_pair_price":"0","snapshot_source":"swap_volume_log_legacy","snapshot_reference":"swap_logs/swap_volume_report","fee_coherence":{"status":"coherent","expected_fees_usd":"34597500","reported_fees_usd":"34597500","difference_usd":"0"}},{"key":"headlineDetailedSnapshot","label":"21B","heading":"31 Dec 2025","time":"2025-12-31T18:33:11+00:00","current":false,"pool_id":"BbvR4zUAwZF8LmVFLXNpDy3CxuYcDwd5isoh7CZFAF5G","lp_token_mint":"DnepvMafJZzDtDcevrqbMUCmDqdNhBLjCTUu1xhR4HeL","base_vault_ui":"1001385604.544298291","quote_vault_ui":"1458324.24672327","swaps_total":21,"traders_estimated":16,"volume_usd":"21000000000","fees_usd":"1050000000","fee_rate":0.05,"fee_bps":500,"implied_pair_price":"0.001456306","snapshot_source":"all_pools_snapshot","snapshot_reference":"sterlingdex-adapter/all_pools_snapshot.json","fee_coherence":{"status":"coherent","expected_fees_usd":"1050000000","reported_fees_usd":"1050000000","difference_usd":"0"}},{"key":"feeWindowDetailedSnapshot","label":"98.5M","heading":"25 Dec 2025","time":"2025-12-25T16:17:48+00:00","current":false,"pool_id":"BbvR4zUAwZF8LmVFLXNpDy3CxuYcDwd5isoh7CZFAF5G","lp_token_mint":"DnepvMafJZzDtDcevrqbMUCmDqdNhBLjCTUu1xhR4HeL","base_vault_ui":"38081674.109538101","quote_vault_ui":"13857412.840566749","swaps_total":1812,"traders_estimated":1383,"volume_usd":"98500000","fees_usd":"4530000","fee_rate":0.05,"fee_bps":500,"implied_pair_price":"0.363886651","snapshot_source":"december_2025_pool","snapshot_reference":"reports/december_2025_pool_fee_inventory.json","fee_coherence":{"status":"fee_volume_mismatch","expected_fees_usd":"4925000","reported_fees_usd":"4530000","difference_usd":"395000"}},{"key":"may2025DetailedSnapshot","label":"681M","heading":"1 May 2025","time":"2025-05-01T17:57:56+00:00","current":false,"pool_id":"BbvR4zUAwZF8LmVFLXNpDy3CxuYcDwd5isoh7CZFAF5G","lp_token_mint":"DnepvMafJZzDtDcevrqbMUCmDqdNhBLjCTUu1xhR4HeL","base_vault_ui":"1124848.812461396","quote_vault_ui":"8.08021","swaps_total":12836,"traders_estimated":10641,"volume_usd":"681250000","fees_usd":"30067500","fee_rate":0.05,"fee_bps":500,"implied_pair_price":"0.000007183","snapshot_source":"swap_volume_log_legacy","snapshot_reference":"swap_logs/swap_volume_report","fee_coherence":{"status":"fee_volume_mismatch","expected_fees_usd":"34062500","reported_fees_usd":"30067500","difference_usd":"3995000"}}],"selection_rule":"latest_snapshot_by_timestamp","snapshot_hierarchy":{"selection_rule":"latest_snapshot_by_timestamp","selected_current_snapshot_key":"may2026ActiveSnapshot","selected_current_snapshot_time":"2026-05-02T23:08:53+00:00","latest_available_snapshot_key":"may2026ActiveSnapshot","latest_available_snapshot_time":"2026-05-02T23:08:53+00:00","latest_historical_snapshot_key":"longActivityDetailedSnapshot","latest_historical_snapshot_time":"2026-01-05T17:57:56+00:00","historical_count":4,"historical_sorted_desc":true,"current_is_latest":true}},"estimated_public":{"swaps_total_reconstructed":115,"traders_total_estimated":58,"volume_cumulative_reconstructed":"828969950.193183","fees_cumulative_reconstructed":"41448497.509659","fee_bps":500,"fee_rate":0.05,"fee_model":"fixed_5_percent","source_snapshot_key":"may2026ActiveSnapshot","source_snapshot_time":"2026-05-02T23:08:53+00:00"},"coherence_check":{"public_totals_status":"uses_current_active_snapshot","onchain_fee_volume_status":"separated_due_to_fee_volume_mismatch","onchain_fee_value_not_promoted_to_public_total":true,"active_snapshot_fee_status":"coherent"},"historical_floor_applied":false,"historical_floor_source":"swap_logs/fee_conversion_log.jsonl","fee_bps":500,"fee_rate":0.05,"fee_model":"fixed_5_percent","note":"Totaux publics Sterling separes: onchain_exact conserve les valeurs brutes indexees, estimated_public expose le snapshot actif le plus recent, et historical_reconstructed garde les anciennes fenetres."},"last_trade_signature":"5UGjLD56TJtC2z3URRPo2piNxTQf5DTyn5VYnpcLcxPUqDrsngQ1LYHYBDzYWZ4nS2cco747CHUwQnrPxfP4ZcAX","last_trade_ts":"2026-06-18 07:02:18+00","updated_at":"2026-06-29 21:39:31.934+00","last_chain_sync_at":"2026-06-29 21:39:31.934+00"},{"pool_id":"H7wL6YaVpLDv4FiSs15Tn1eksQ895VNKnXwCb2aCbFb4","program_id":"7v9sLrk92NNLLUfXLJw3o7MycZNvwsTK6kLWfWb8vcVA","pair_id":"wSTRL-SJBCUSD","pair_slug":"wstrl-sjbcusd","pair_label":"wSTRL/SJBCUSD","quote_onchain_symbol":"SJBC","quote_public_symbol":"SJBCUSD","quote_public_label":"SJBC USD","enabled":true,"lp_mint":"FtQVHCSoaSLMcFYAczVXutjB3AHUQowxvPtKUKJwCssM","canonical_lp_mint":"FtQVHCSoaSLMcFYAczVXutjB3AHUQowxvPtKUKJwCssM","legacy_fee_token_mint":null,"config_pda":"Htopqis52g8nGvvkpnG7Z7XZhgBpqtN9huqUyk6LH9gB","authority":"CMqD45Kq5oukPvaMDhzav5RxJqZb1xME1MmV71CzCeTw","base":{"symbol":"wSTRL","name":"Wrapped SterlingChain Currency","mint":"9kugBqSVwBWdASa6rdRWAcgNvkHLreuy6EnEEHumonNh","decimals":6},"quote":{"symbol":"SJBCUSD","name":"SJBC USD","onchain_symbol":"SJBC","public_symbol":"SJBCUSD","public_label":"SJBC USD","mint":"EsNo61QodqHCRjkTGJDeqyK7N4Hunip5PaTYbpPZEsG2","decimals":9},"settlement":{"symbol":"USDC","name":"USD Coin","mint":"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"},"base_mint":"9kugBqSVwBWdASa6rdRWAcgNvkHLreuy6EnEEHumonNh","quote_mint":"EsNo61QodqHCRjkTGJDeqyK7N4Hunip5PaTYbpPZEsG2","base_vault":"BZLrYAqcPxpvXJd37sWUHUBZoikuPDX9dyBNNJTNdbkZ","quote_vault":"vCHw1UktF3adirS2D4CgavT1fupmKo6QCAs4WWiR3CV","fee_vault_base":"f9QFLJ4WoSHBHngBdPG3g2T1fkdi6cR1g4r4STJEgst","fee_vault_quote":"J4w1LHXFrgBisjw8VkjegqBQ9FknVCex5czY4ZNDVfQ1","protocol_debt_ledger":"3nFupH1tDDUPB5xTTCWvpDSyv9UY1R1Y2EHwGqT2hSFC","base_vault_balance":"14500","quote_vault_balance":"1341250000","current_live_price_usd":"92500","price_gross_usd":"92500","price_net_usd":"92222.5","fee_bps":30,"fee_rate":0.003,"current_live_floor_price_usd":"92500","floor_locked":true,"swaps_total":null,"volume_24h_usd":null,"volume_7d_usd":null,"volume_cumulative_usd":null,"fees_cumulative_usd":null,"fees_paid_cumulative_usd":null,"fees_collected_cumulative_usd":null,"fees_base_cumulative_ui":null,"fees_quote_cumulative_ui":null,"fees_unknown_cumulative_ui":null,"traders_estimated_total":null,"estimated_traders_total":null,"activity_totals":{"swaps_total":null,"volume_cumulative_usd":null,"fees_cumulative_usd":null,"note":"Wrapper pool published as a first-class live funded triangle surface. Public swap counters remain unset here until indexed separately."},"status":"LIVE_EXISTING_AMM_POOL","funding_source_flag":"SOUVEREIGN_RESERVE_COFFRE","source_model":"STERLING_L1_GUARANTEE_VAULT","funding_receipt":"https://solscan.io/tx/48VL7VwdbxHb1mUcRaSB9zMyc8h6bjLqEST2HM9aCL4NLWhfFGZx8kDQWDGFLGtzkmU39K4KfzJjot8wCAq9ibon","truth_note":"This funded wrapper pool is live and funded exclusively from sovereign reserve coffre accounts. The existing STM/SJBCUSD live anchor pool remained untouched.","updated_at":"2026-05-23T23:13:22.155940Z","last_chain_sync_at":"2026-05-23T23:13:22.155940Z","public_read_role":"wrapper_leg_first_class_triangle_surface"},{"pool_id":"7ucAL5X51BDHnZKn1zGtxYSKBPfMxknxSLg47yFwWCM2","program_id":"7v9sLrk92NNLLUfXLJw3o7MycZNvwsTK6kLWfWb8vcVA","pair_id":"wSTRL-STM","pair_slug":"wstrl-stm","pair_label":"wSTRL/STM","quote_onchain_symbol":"STM","quote_public_symbol":"STM","quote_public_label":"Sterling Mint","enabled":true,"lp_mint":"2UCcNWHoWjgvacqXgYcmMSpgeZn5w6rcKMXc3zBYMzso","canonical_lp_mint":"2UCcNWHoWjgvacqXgYcmMSpgeZn5w6rcKMXc3zBYMzso","legacy_fee_token_mint":null,"config_pda":"Htopqis52g8nGvvkpnG7Z7XZhgBpqtN9huqUyk6LH9gB","authority":"CMqD45Kq5oukPvaMDhzav5RxJqZb1xME1MmV71CzCeTw","base":{"symbol":"wSTRL","name":"Wrapped SterlingChain Currency","mint":"9kugBqSVwBWdASa6rdRWAcgNvkHLreuy6EnEEHumonNh","decimals":6},"quote":{"symbol":"STM","name":"Sterling Mint","onchain_symbol":"STM","public_symbol":"STM","public_label":"Sterling Mint","mint":"9kued2JXgVk5dzvtipsTdXfBMWihy1E55TwMiXchCoAb","decimals":9},"settlement":{"symbol":"USDC","name":"USD Coin","mint":"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"},"base_mint":"9kugBqSVwBWdASa6rdRWAcgNvkHLreuy6EnEEHumonNh","quote_mint":"9kued2JXgVk5dzvtipsTdXfBMWihy1E55TwMiXchCoAb","base_vault":"5ymWd5AKXrZRKdVouMDJxu3cT7me9snyVB9r53B58UXk","quote_vault":"G61H9rHxvvZunZj768rVKzYc6nbsqKyytWRm7yA4TaVH","fee_vault_base":"EUMd7GgFDRCyp6FkppwBvUzYoH3S1NkEd2katLFNhJZU","fee_vault_quote":"3mg4iqLEqMqji4ohxSh85gY2bojeQG9YdQtAcmapSgeL","protocol_debt_ledger":"XKE9Pv1dmHNNGzK1nmhobtAbcbvWuQH88CauZSpuMrv","base_vault_balance":"14500","quote_vault_balance":"14500","current_live_price_usd":"92500","price_gross_usd":"92500","price_net_usd":"92222.5","fee_bps":30,"fee_rate":0.003,"current_live_floor_price_usd":"92500","floor_locked":true,"swaps_total":null,"volume_24h_usd":null,"volume_7d_usd":null,"volume_cumulative_usd":null,"fees_cumulative_usd":null,"fees_paid_cumulative_usd":null,"fees_collected_cumulative_usd":null,"fees_base_cumulative_ui":null,"fees_quote_cumulative_ui":null,"fees_unknown_cumulative_ui":null,"traders_estimated_total":null,"estimated_traders_total":null,"activity_totals":{"swaps_total":null,"volume_cumulative_usd":null,"fees_cumulative_usd":null,"note":"Wrapper pool published as a first-class live funded triangle surface. Public swap counters remain unset here until indexed separately."},"status":"LIVE_EXISTING_AMM_POOL","funding_source_flag":"SOUVEREIGN_RESERVE_COFFRE","source_model":"STERLING_L1_GUARANTEE_VAULT","funding_receipt":"https://solscan.io/tx/4wSHR9JLPxCAud5Rs9KYu4eo9YGpXBT7pq8gZqsJCsfPfRAPAQ9tfVryWJ8HTDHMs4zAab3NzeEFVAGGRoty6Qvd","truth_note":"This funded parity wrapper pool is live and funded exclusively from sovereign reserve coffre accounts. The existing STM/SJBCUSD live anchor pool remained untouched.","updated_at":"2026-05-23T23:13:22.155940Z","last_chain_sync_at":"2026-05-23T23:13:22.155940Z","public_read_role":"wrapper_leg_first_class_triangle_surface"}]}