Query editor
WITH actions_daily AS (SELECTdate_trunc('day', from_iso8601_timestamp(createdat)) AS day,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 active_walletsFROM dune.yieldxyz.dataset_utila_yield_report_entriesGROUP BY 1),revenue_daily AS (SELECTCAST(date AS DATE) AS day,SUM(TRY_CAST(totalrevenueamountusd AS DOUBLE)) AS revenue_usdFROM dune.yieldxyz.dataset_utila_yield_revenueGROUP BY 1),ranked_prices AS (SELECTCAST(timestamp AS DATE) AS day,UPPER(symbol) AS symbol,price,ROW_NUMBER() OVER (PARTITION BY CAST(timestamp AS DATE), UPPER(symbol)ORDER BY volume DESC) AS rnFROM prices.dayWHERE UPPER(symbol) IN ('ETH', 'SOL', 'TRX', 'TAO', 'HYPE', 'POL', 'GRAM')AND timestamp >= TIMESTAMP '2025-09-01'),token_prices AS (SELECT day, symbol, priceFROM ranked_pricesWHERE rn = 1),perf_priced AS (SELECTCAST(date AS DATE) AS day,UPPER(tokensymbol) AS symbol,SUM(TRY_CAST(tvltoken AS DOUBLE)) AS tvl_tokenFROM dune.yieldxyz.dataset_utila_yield_performanceGROUP BY 1, 2),perf_daily AS (SELECTpp.day,SUM(pp.tvl_token * CASEWHEN pp.symbol IN ('USDC', 'USDT') THEN 1.0ELSE COALESCE(tp.price, 0)END) AS tvl_total_usd,SUM(pp.tvl_token) FILTER (WHERE pp.symbol IN ('USDC', 'USDT')) AS tvl_stable_usd,COUNT(*) FILTER (WHERE pp.symbol NOT IN ('USDC', 'USDT')AND tp.price IS NULLAND pp.tvl_token > 0) AS unpriced_positionsFROM perf_priced ppLEFT JOIN token_prices tp ON tp.day = pp.day AND tp.symbol = pp.symbolGROUP BY 1