Query editor
WITH action_by_integration AS (SELECTintegrationid,MAX(yieldname) AS yieldname,MAX(yieldtype) AS yieldtype,MAX(tokennetwork) AS network,SUM(TRY_CAST(usdamount AS DOUBLE)) FILTER (WHERE status = 'SUCCESS') AS action_volume_usd,COUNT(*) FILTER (WHERE status = 'SUCCESS') AS successful_actions,COUNT(DISTINCT address) FILTER (WHERE status = 'SUCCESS') AS unique_walletsFROM dune.yieldxyz.dataset_utila_yield_report_entriesGROUP BY 1),revenue_by_integration AS (SELECTintegrationid,SUM(TRY_CAST(totalrevenueamountusd AS DOUBLE)) AS revenue_usdFROM dune.yieldxyz.dataset_utila_yield_revenueGROUP BY 1),latest AS (SELECT MAX(CAST(date AS DATE)) AS max_dayFROM dune.yieldxyz.dataset_utila_yield_performance),latest_prices AS (SELECT symbol, priceFROM (SELECTUPPER(symbol) AS symbol,price,ROW_NUMBER() OVER (PARTITION BY UPPER(symbol)ORDER BY timestamp DESC, volume DESC) AS rnFROM prices.dayWHERE UPPER(symbol) IN ('ETH', 'SOL', 'TRX', 'TAO', 'HYPE', 'POL', 'GRAM')AND timestamp >= NOW() - INTERVAL '7' DAY)WHERE rn = 1),tvl_by_integration AS (SELECTp.integrationid,MAX(p.yieldname) AS yieldname,MAX(p.yieldtype) AS yieldtype,MAX(p.tokennetwork) AS network,MAX(p.tokensymbol) AS tokensymbol,SUM(TRY_CAST(p.tvltoken AS DOUBLE)) AS tvl_tokenFROM dune.yieldxyz.dataset_utila_yield_performance pCROSS JOIN latestWHERE CAST(p.date AS DATE) = latest.max_dayGROUP BY 1),ids AS (SELECT integrationid FROM action_by_integrationUNIONSELECT integrationid FROM revenue_by_integrationUNIONSELECT integrationid FROM tvl_by_integration)SELECT