Query editor
WITH vault_liquidity AS (SELECTvault_token,SUM(COALESCE(free_amount, 0) +COALESCE(exchange_amount, 0)) AS total_liquidityFROM (SELECTvault_token,0 AS free_amount, -- Set free_amount to 0 as it doesn't exist in complete_order0 AS exchange_amount -- Set exchange_amount to 0 as it doesn't exist in complete_orderFROM stormtrade_ton.complete_orderUNION ALLSELECTvault_token,free_amount,exchange_amountFROM stormtrade_ton.trade_notification)GROUP BY 1)SELECTvault_token,total_liquidity / 1e9 AS liquidity_ton, -- Adjust decimals for TON (1e9)total_liquidity / 1e6 AS liquidity_usdt -- Adjust decimals for USDT (1e6)FROM vault_liquidityWHERE vault_token IN ('TON', -- TON native token identifier'USDT' -- USDT jetton identifier)