Query editor
WITH latest_day AS (SELECT MAX(day) AS max_dayFROM solana_utils.daily_balances),vault_balances AS (SELECTtoken_balance_owner,token_mint_address,token_balanceFROM solana_utils.daily_balancesWHERE token_balance_owner IN ('9DrvZvyWh1HuAoZxvYWMvkf2XCzryCpGgHqrMjyDWpmo','B9spsrMK6pJicYtukaZzDyzsUQLgc3jbx5gHVwdDxb6y','81BgcfZuZf9bESLvw3zDkh7cZmMtDwTPgkCvYu7zx26o','GuWEkEJb5bh8Ai2gaYmZWMTUq8MrFeoaDZ89BrQfB1FZ','Dx8iy2o46sK1DzWbEcznqSKeLbLVeu7otkibA3WohGAj','6QbtpY2jDNcncRFmVf343NThnCdaY8gCAsYATPnYQR9g')AND day = (SELECT max_day FROM latest_day)),token_map AS (-- Original tokensSELECT 'So11111111111111111111111111111111111111112' AS mint, 'wSOL' AS name, 'SOL' AS symbolUNION ALL SELECT 'JupSoLaHXQiZZTSfEWMTRRgpnyFm8f6sZdosWBjx93v', 'JupSol', 'JUPSOL'UNION ALL SELECT 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn', 'JitoSOL', 'JITOSOL'UNION ALL SELECT 'cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij', 'CbBTC', 'CBBTC'UNION ALL SELECT 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So', 'mSOL', 'MSOL'UNION ALL SELECT '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo', 'PYUSD', 'PYUSD'UNION ALL SELECT 'Dso1bDeDjCQxTrWHqUUi63oBvV7Mdm6WaobLbQ7gnPQ', 'dSOL', 'DSOL'UNION ALL SELECT 'vSoLxydx6akxyMD9XEcPvGYNGq6Nn66oqVb3UkGkei7', 'vSOL', 'VSOL'-- NEW tokens found!UNION ALL SELECT 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', 'USDC', 'USDC'UNION ALL SELECT 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', 'USDT', 'USDT'UNION ALL SELECT 'USDSwr9ApdHk5bvJKMjzff41FfuX8bSxdKcR81vTwcA', 'USDS', 'USDS'UNION ALL SELECT '2u1tszSeqZ3qBWF3uNGPFc8TzMk2tdiwknnRMWGWjGWH', 'Token2u1', 'UNKNOWN1'UNION ALL SELECT 'USD1ttGY1N17NEEHLmELoaybftRBUSErhqYiQzvEmuB', 'USD1', 'USD1'UNION ALL SELECT 'CtzPWv73Sn1dMGVU3ZtLv9yWSyUAanBni19YWDaznnkn', 'TokenCtz', 'UNKNOWN2'UNION ALL SELECT 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3', 'TokenHZ1', 'UNKNOWN3'),tvl_by_token AS (SELECTtm.name AS token_name,tm.symbol,SUM(vb.token_balance) AS tvl_tokensFROM vault_balances vbJOIN token_map tm ON vb.token_mint_address = tm.mintGROUP BY tm.name, tm.symbol),latest_prices AS (SELECTtoken_bought_symbol AS symbol,AVG(price) AS price_usdFROM (SELECTtoken_bought_symbol,amount_usd / NULLIF(token_bought_amount, 0) AS priceFROM dex.tradesWHERE blockchain = 'solana'AND block_date >= CURRENT_DATE - INTERVAL '1' DAYAND amount_usd > 0