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 attributed to this builder on this date across all of its builder codes, as published by Polymarket. The value is in outcome shares, not USD.
active_users	NUMBER(38,0)	Number of users who traded through this builder on this date across all of its builder codes, as published by Polymarket.
daily_rank	VARCHAR(16777216)	Builder rank for the day.
builder_code	VARCHAR(16777216)	Builder code (bytes32) carried onchain by the builder’s orders. A builder can own several codes, in use at the same time or one after another; each row shows one of them, and volume_usd and active_users cover all of the builder’s codes. A code stays the same when the builder’s name changes.
unique_id	VARCHAR(16777216)	Unique identifier for the row (format ‘date-YYYY-MM-DD_builder_name-’).
_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_shares,
  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_shares desc
limit 10

Understanding Builder Code Metrics

Volume USD: Trading volume in outcome shares attributed to the builder for the day, across all of its builder codes
Active Users: Number of unique users who traded through the builder on the day, across all of its builder codes
Builder Code: One of the builder’s onchain codes. Daily volume per builder code from onchain fills is in polygon.predictions_onchain.builder_volume_daily
Daily Rank: Ranking of the builder based on volume for that specific day
Verified Status: Verified builders have been verified by Polymarket

EVM

​Table Details

​Table Columns

​Sample Queries

​Understanding Builder Code Metrics

Table Details

Table Columns

Sample Queries

Understanding Builder Code Metrics