This schema contains comprehensive datasets for tracking Virtuals Protocol fundamental data across multiple metrics categories, including AI agent activity, trading volume, fee distribution, token economics, and market data for the decentralized AI agent marketplace.

​
Available Tables

Virtuals data is available in two main tables:
  • ez_metrics: Main aggregated metrics for the Virtuals Protocol
  • ez_metrics_by_chain: Chain-specific metrics (currently focused on Base network)

​
Table Schema

​
AI Agent and Activity Metrics

Table NameColumn NameDescription
ez_metricsdaily_agentsThe number of AI agents active on a given day
ez_metricsspot_dauThe number of daily active traders on Virtuals Protocol
ez_metricsdauSame as spot_dau (legacy naming)

​
Trading and Volume Metrics

Table NameColumn NameDescription
ez_metricsspot_volumeThe total trading volume on Virtuals Protocol
ez_metricsvolume_usdSame as spot_volume (legacy naming)
ez_metricsvolume_nativeTrading volume in native token units

​
Fee Structure and Revenue Metrics

Table NameColumn NameDescription
ez_metricsspot_feesThe total amount of fees (in USD) paid by users on Virtuals Protocol
ez_metricsfeesThe sum of all taxes, 1% fee on all trades, and agent fees (in USD) paid on Virtuals Protocol
ez_metricsservice_fee_allocationAll fees paid to AI agents on Virtuals Protocol
ez_metricstreasury_fee_allocationRevenue allocated to the protocol’s treasury. All taxes paid on trades first go to the treasury, then post-bond are distributed across Agent Creator (30%), Agent Affiliates (20%), and Agent subDAO (50%)
ez_metricsfee_fun_usdAgent fees collected in USD (legacy naming)
ez_metricsfee_fun_nativeAgent fees collected in native tokens (legacy naming)
ez_metricstax_usdTax fees collected from trades (legacy naming)
ez_metricsfeesTotal fees collected (legacy naming)

​
Token Supply Metrics

Table NameColumn NameDescription
ez_metricscirculating_supply_nativeThe circulating supply of VIRTUALS tokens in native units
ez_metricsnet_supply_change_nativeThe net change in the circulating supply of VIRTUALS tokens
ez_metricspremine_unlocks_nativeThe amount of native VIRTUALS tokens unlocked from premine

​
Market and Token Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of VIRTUALS token in USD
ez_metricsmarket_capThe market cap of VIRTUALS token in USD
ez_metricsfdmcThe fully diluted market cap of VIRTUALS token in USD
ez_metricstoken_volumeThe trading volume of VIRTUALS token in USD
ez_metricstoken_turnover_circulatingThe turnover of VIRTUALS token based on circulating supply
ez_metricstoken_turnover_fdvThe turnover of VIRTUALS token based on fully diluted valuation

​
Chain-Specific Metrics

Table NameColumn NameDescription
ez_metrics_by_chainchainThe blockchain (currently ‘base’)
ez_metrics_by_chaintrading_volumeTrading volume on the specific chain
ez_metrics_by_chainvolume_nativeTrading volume in native token units
ez_metrics_by_chainai_volumeAI-related trading volume (same as trading_volume)

​
Sample Queries

​
Basic Protocol Activity Query

-- 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

​
AI Agent Activity Analysis

-- 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

​
Fee Distribution Analysis

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