Query editor
-- AI Sector: Virtuals Protocol (Base chain)-- Track VIRTUAL token trading as proxy for AI agent ecosystem activityWITH virtuals_trading AS (SELECTCAST(block_time AS date) AS block_date,'Virtuals' AS protocol,SUM(amount_usd) AS volume_usd,SUM(amount_usd * 0.01) AS estimated_fees_usd, -- ~1% platform feeCOUNT(DISTINCT CAST(tx_from AS varchar)) AS active_users,COUNT(*) AS trade_countFROM dex.tradesWHERE (token_bought_symbol = 'VIRTUAL' OR token_sold_symbol = 'VIRTUAL')AND blockchain = 'base'AND block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '90' DAY)AND block_time >= CURRENT_DATE - INTERVAL '90' DAYGROUP BY 1)SELECTblock_date,protocol,volume_usd,estimated_fees_usd,active_users,trade_count,SUM(volume_usd) OVER (ORDER BY block_date) AS cumulative_volumeFROM virtuals_tradingORDER BY block_date DESC