Skip to main content
The polygon.predictions.builder_code table provides daily aggregated metrics for Polymarket builder codes, tracking trading volume, active users, and builder rankings. Use this table for:
  • Builder performance analysis and rankings
  • Referral program effectiveness tracking
  • User acquisition attribution
  • Volume analysis by builder

​
Table Columns

Column NameData TypeDescription
projectVARCHARProject name (polymarket).
protocolVARCHARProtocol name (polymarket).
dateDATEDate of the volume data.
builder_nameVARCHARName of the builder.
builder_logoVARCHARURL to the builder’s logo.
is_verifiedBOOLEANWhether the builder is verified.
volume_usdFLOATTrading volume in USD for the day.
active_usersINTEGERNumber of active users for the builder on this day.
daily_rankINTEGERBuilder rank for the day.
_created_atTIMESTAMP_NTZ(9)Record creation timestamp.
_updated_atTIMESTAMP_NTZ(9)Record update timestamp.

​
Sample Queries

  • Top Builders by Volume
Find the top 10 builders by trading volume for the past 30 days:
select
  builder_name,
  is_verified,
  sum(volume_usd) as total_volume_usd,
  sum(active_users) as total_active_users,
  avg(daily_rank) as avg_daily_rank
from polygon.predictions.builder_code
where date >= current_date - interval '30 days'
group by builder_name, is_verified
order by total_volume_usd desc
limit 10

​
Understanding Builder Code Metrics

  • Volume USD: Total trading volume in USD attributed to the builder code for the day
  • Active Users: Number of unique users who traded using this builder code on the day
  • Daily Rank: Ranking of the builder based on volume for that specific day
  • Verified Status: Verified builders have been verified by Polymarket