Query editor
WITH product_registry AS (-- 1. Buscamos dinámicamente qué es SpotSELECT DISTINCT "productId", 'Spot' as categoryFROM nado_ink.SpotEngine_evt_AddOrUpdateProductUNION ALL-- 2. Buscamos dinámicamente qué es PerpSELECT DISTINCT "productId", 'Perps (Derivatives)' as categoryFROM nado_ink.PerpEngine_evt_AddOrUpdateProduct),standard_dexs AS (SELECTdate_trunc('day', block_time) AS day,project,'Spot' AS category,SUM(amount_usd) AS volume_usdFROM dex.tradesWHERE blockchain = 'ink'GROUP BY 1, 2),nado_dex AS (SELECTdate_trunc('day', t.evt_block_time) AS day,'Nado' AS project,-- 3. Aquí ocurre la magia: Usamos la categoría de la tabla registry-- COALESCE sirve por si aparece un ID nuevo que aún no está indexado (fallback)COALESCE(r.category, 'Unknown') AS category,SUM(ABS(t.quoteDelta)) / 1e18 AS volume_usdFROM nado_ink.OffchainExchange_evt_FillOrder t-- 4. El JOIN dinámicoLEFT JOIN product_registry r ON t."productId" = r."productId"AND t."isTaker" = trueGROUP BY 1, 2, 3)SELECT * FROM standard_dexsUNION ALLSELECT * FROM nado_dex-- Recuerda descomentar el filtro que necesites para cada gráficoWHERE category = 'Spot'-- WHERE category = 'Perps (Derivatives)'ORDER BY day DESC, volume_usd DESC