Builder Code 🌱 - Allium Documentation Hub

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 Details

Property	Value
Table Name	`polygon.predictions.builder_code`
Table Status	Beta 🌱
Unique Key	`date`, `builder_name`
Clustering Key(s)	`date`

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	Project name (polymarket).
protocol	VARCHAR(16777216)	Protocol name (polymarket).
date	DATE	Date of the volume data.
builder_name	VARCHAR(16777216)	Name of the builder.
builder_logo	VARCHAR(16777216)	URL to the builder’s logo.
is_verified	BOOLEAN	Whether the builder is verified.
volume_usd	FLOAT	Trading volume in USD for the day.
active_users	NUMBER(38,0)	Number of active users for the builder on this day.
daily_rank	VARCHAR(16777216)	Builder rank for the day.
_created_at	TIMESTAMP_NTZ(9)	Record creation timestamp.
_updated_at	TIMESTAMP_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