> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Builder Code 🌱

> Daily Polymarket builder code volume and activity metrics.

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

<Tabs>
  <Tab title="Top Builders by Volume">
    Find the top 10 builders by trading volume for the past 30 days:

    ```sql theme={null}
    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
    ```
  </Tab>
</Tabs>

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