Query editor
WITH vault_balances AS (SELECTvb.token_balance_owner AS pool_address,vb.token_mint_address,vb.token_balanceFROM solana_utils.daily_balances vbWHERE vb.token_balance_owner IN ('BZi9iPbcpLWDkHs8nNQe5pb9MxLQe8fbgHtypj2pL4UB', -- OMFG/USDC'Cp2nGCWWfqkUmPR3pPKoR376Fti8wuYRFrSWJZq1a9SA', -- META/USDC'3cPJTS5kfD7414aTRPcyBrA55aSx8csCUPWsrS4mnFWV', -- SOL/USDC'9kzZJjAe9LMqL4u12jb3PnkRcyUMkqN1Yk8MKZzGXG8y', -- JupUSD/USDC'8UtawNe4kZLYX6yLo4PKP9BhTWvsLpyDqxsic53tvk8c', -- USDC/USDT'6pJxaniSNha36YFZGrEzeWp74DGeoqETvwZxXnDmUDAG', -- USDC/BIRB'5gmu81XQnZs2ZoxyCS6d1rx6UVPisixcfwKvYYzENb3U', -- SOL/xSOL'CN6rZvMScszwJrQrVgn3SzxKJH5dwLP2YT1VLgthSmuP', -- STAR/USDC'BeUSUnXyV7w9zuYbvtW29ceUYCrihUS5DqiDXXeetCS5', -- HYPE/USDC'BayaJq1ifancLHQVat8VvShtoHA69v9pfG3EMV8KdCQJ', -- USDC/ZC'9om6qG64JaZVbVwrP2ULVq5nLVLqcXz4ToqMKTsfuLyX', -- kySOL/JitoSOL'8SEjGGF1b9G8WcraicAatAmurTDDYixentTQDUoNespP', -- JupUSD/USDC'G7enNSGb5k264XRJCPuUXxAjQrWSEvu9qvWe4rg8ADAv', -- USDC/USDT'7USpQsGyRh9awZXyCFft18Do7di8mraRrfqBcYXLok7C', -- AVICI/USDC'DLdMKytiJvVgivmQBhwfKEU4hgEWjhGURS16kTeEkjPP', -- UMBRA/USDC'4tvQuDY6PK9Pz2v5pmJUXLxAAhLDDk9yxpvLkB8bxjMX', -- SOLO/USDC'9rSi9T6wp14NRzjPHhU83ifwA88vzpchTDDAnjmfoGcE', -- cbBTC/zBTC'7Zsvuaa2RvarcpWruQ5QzYC1aXpN1sfL8rL3JyHp1QvD' -- kySOL/JitoSOL)AND vb.day = (SELECT MAX(day) FROM solana_utils.daily_balancesWHERE token_balance_owner = vb.token_balance_owner)AND vb.token_balance > 0),daily_prices AS (SELECT DISTINCTcontract_address,FIRST_VALUE(price) OVER (PARTITION BY contract_addressORDER BY minute DESC) AS priceFROM prices.usdWHERE blockchain = 'solana'AND minute >= NOW() - INTERVAL '1' HOUR),tvl_with_prices AS (SELECTvb.pool_address,vb.token_mint_address,vb.token_balance,COALESCE(dp.price, 1.0) AS price_usd,vb.token_balance * COALESCE(dp.price, 1.0) AS tvl_usdFROM vault_balances vbLEFT JOIN daily_prices dpON from_base58(vb.token_mint_address) = dp.contract_address)SELECTpool_address,SUM(tvl_usd) AS tvl_usd,