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

# Sui

> Sui Schema Description and Methodology

This schema contains comprehensive on-chain datasets for tracking Sui fundamental data across multiple metrics categories, including network activity, fees, staking, transfers, stablecoins, and developer metrics.

## Available Tables

Sui data is available in several tables:

* **ez\_metrics**: Main aggregated metrics for the Sui network
* **ez\_metrics\_by\_category\_v2**: Basic metrics (DAU, gas fees, transactions) broken down by transaction category
* **ez\_metrics\_by\_application\_v2**: Basic metrics (DAU, gas fees, transactions) broken down by application
* **ez\_metrics\_by\_subcategory**: Basic metrics (DAU, gas fees, transactions) broken down by subcategory
* **ez\_metrics\_by\_contract\_v2**: Basic metrics (DAU, gas fees, transactions) broken down by contract
* **ez\_stablecoin\_metrics\_by\_address\_with\_labels**: Stablecoin metrics by address with labels

*Note: The `by_category`, `by_application`, `by_subcategory`, and `by_contract` tables contain the same basic metrics (daily active users, gas fees, transaction counts) but broken down by different groupings based on transaction data.*

## Table Schema

### Network and Usage Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | chain\_txns | Daily transactions on the Sui network |
| ez\_metrics | chain\_dau | Daily unique users on Sui |
| ez\_metrics | chain\_wau | Weekly unique users on Sui |
| ez\_metrics | chain\_mau | Monthly unique users on Sui |
| ez\_metrics | chain\_avg\_txn\_fee | The average transaction fee on Sui |
| ez\_metrics | returning\_users | The number of returning users on Sui |
| ez\_metrics | new\_users | The number of new users on Sui |
| ez\_metrics | txns | Legacy naming for chain\_txns |
| ez\_metrics | dau | Legacy naming for chain\_dau |
| ez\_metrics | wau | Legacy naming for chain\_wau |
| ez\_metrics | mau | Legacy naming for chain\_mau |
| ez\_metrics | avg\_txn\_fee | Legacy naming for chain\_avg\_txn\_fee |

### Fee and Revenue Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | chain\_fees | The total transaction fees paid on the Sui network |
| ez\_metrics | fees | The total USD value generated from all user-paid fees |
| ez\_metrics | fees\_native | The total native SUI value from all user-paid fees |
| ez\_metrics | fees | Legacy naming for chain\_fees |
| ez\_metrics | fees\_native | Transaction fees in native SUI (legacy naming) |

### Cash Flow Distribution Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | burned\_fee\_allocation | USD value of SUI burned through transaction fees |
| ez\_metrics | burned\_fee\_allocation\_native | Amount of native SUI burned through transaction fees |
| ez\_metrics | revenue | Legacy naming for burned\_fee\_allocation |
| ez\_metrics | revenue\_native | Legacy naming for burned\_fee\_allocation\_native |

### Transfer and Volume Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | chain\_spot\_volume | Total spot DEX volume on Sui |
| ez\_metrics | dex\_volumes | Legacy naming for chain\_spot\_volume |

### Market and Supply Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | price | The price of SUI in USD |
| ez\_metrics | market\_cap | The market cap of SUI in USD |
| ez\_metrics | fdmc | The fully diluted market cap of SUI in USD |
| ez\_metrics | tvl | The total value locked in Sui protocols |
| ez\_metrics | gross\_emissions\_native | The amount of block rewards in native SUI |
| ez\_metrics | mints\_native | Legacy naming for gross\_emissions\_native |
| ez\_metrics | circulating\_supply\_native | The circulating supply of SUI in native tokens |
| ez\_metrics | net\_supply\_change\_native | The net change in the circulating supply of SUI |
| ez\_metrics | premine\_unlocks\_native | The amount of native tokens unlocked from premine |

### Stablecoin Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | stablecoin\_total\_supply | The total supply of stablecoins on Sui |
| ez\_metrics | stablecoin\_txns | The number of stablecoin transactions |
| ez\_metrics | stablecoin\_dau | Daily active users of stablecoins |
| ez\_metrics | stablecoin\_mau | Monthly active users of stablecoins |
| ez\_metrics | stablecoin\_transfer\_volume | The total volume of stablecoin transfers |
| ez\_metrics | stablecoin\_tokenholder\_count | The number of unique stablecoin tokenholders |

### Developer Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | weekly\_commits\_core\_ecosystem | The number of commits to the Sui core ecosystem |
| ez\_metrics | weekly\_commits\_sub\_ecosystem | The number of commits to the Sui sub-ecosystem |
| ez\_metrics | weekly\_developers\_core\_ecosystem | The number of developers who have made commits to the Sui core ecosystem |
| ez\_metrics | weekly\_developers\_sub\_ecosystem | The number of developers who have made commits to the Sui sub-ecosystem |

## Sample Queries

### Basic Network Activity Query

```sql theme={null}
-- Pull fundamental network activity data for Sui
SELECT
    date,
    chain_txns,
    chain_dau,
    chain_fees,
    chain_avg_txn_fee,
    price
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Fee and Revenue Analysis

```sql theme={null}
-- Analyze Sui fee and revenue metrics
SELECT
    date,
    chain_fees,
    fees,
    fees_native,
    burned_fee_allocation,
    burned_fee_allocation_native
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Supply Analysis

```sql theme={null}
-- Track Sui supply changes
SELECT
    date,
    circulating_supply_native,
    gross_emissions_native,
    premine_unlocks_native,
    net_supply_change_native,
    price
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC
```

### Stablecoin Activity

```sql theme={null}
-- Track stablecoin usage on Sui
SELECT
    date,
    stablecoin_total_supply,
    stablecoin_transfer_volume,
    stablecoin_dau,
    stablecoin_txns
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC
```

### User Segmentation Analysis

```sql theme={null}
-- Analyze different user types on Sui
SELECT
    date,
    chain_dau,
    returning_users,
    new_users
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC
```

### Application-specific Analysis

```sql theme={null}
-- Analyze metrics for specific applications on Sui
SELECT
    date,
    app,
    friendly_name,
    category,
    txns,
    dau,
    returning_users,
    new_users
FROM
    art_share.sui.ez_metrics_by_application_v2
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND app IN ('cetus', 'turbos', 'suiswap')
ORDER BY
    app, date ASC
```

### Developer Activity

```sql theme={null}
-- Track developer activity on Sui
SELECT
    date,
    weekly_commits_core_ecosystem,
    weekly_commits_sub_ecosystem,
    weekly_developers_core_ecosystem,
    weekly_developers_sub_ecosystem
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC
```

### TVL and Market Metrics Analysis

```sql theme={null}
-- Analyze Sui TVL and market metrics
SELECT
    date,
    tvl,
    price,
    market_cap,
    fdmc,
    chain_spot_volume
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.