Virtuals

-- Pull fundamental activity data for Virtuals Protocol
SELECT
    date,
    daily_agents,
    spot_dau,
    spot_volume,
    spot_fees,
    fees,
    price
FROM
    art_share.virtuals.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze AI agent activity and user engagement
SELECT
    date,
    daily_agents,
    spot_dau,
    spot_volume,
    spot_volume / NULLIF(spot_dau, 0) as avg_volume_per_user,
    spot_volume / NULLIF(daily_agents, 0) as avg_volume_per_agent,
    spot_dau / NULLIF(daily_agents, 0) as avg_users_per_agent
FROM
    art_share.virtuals.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND daily_agents > 0
ORDER BY
    date ASC

-- Analyze Virtuals Protocol fee structure and distribution
SELECT
    date,
    ecosystem_