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

# DEX Overview

> Daily metrics per HIP-3 DEX (permissionless perpetual markets)

The `hyperliquid.metrics.dex_overview` table provides daily metrics per HIP-3 DEX on Hyperliquid. This table only includes HIP-3 permissionless perpetual markets — native Hyperliquid perps are excluded. It provides visibility into individual DEX performance on Hyperliquid.

<Info>
  HIP-3 DEXes are permissionless perpetual markets that allow anyone to deploy their own perpetual trading venue on Hyperliquid. Each DEX has its own deployer, fee recipient, and set of markets.
</Info>

## Table Columns

### DEX Identity

| Column Name     | Description                                             |
| --------------- | ------------------------------------------------------- |
| activity\_date  | The date of the activity.                               |
| dex\_name       | The short name/identifier of the HIP-3 DEX.             |
| dex\_full\_name | The full display name of the HIP-3 DEX.                 |
| deployer        | The address of the deployer who created this HIP-3 DEX. |
| fee\_recipient  | The address that receives trading fees for this DEX.    |

### Volume & Trades

| Column Name              | Description                                             |
| ------------------------ | ------------------------------------------------------- |
| volume\_usd              | The daily trading volume in USD for this DEX.           |
| trade\_count             | The daily number of trades on this DEX.                 |
| median\_trade\_size\_usd | The median trade size in USD for this DEX on this day.  |
| avg\_trade\_size\_usd    | The average trade size in USD for this DEX on this day. |

### Users

| Column Name     | Description                                                    |
| --------------- | -------------------------------------------------------------- |
| active\_users   | The number of unique users who traded on this DEX on this day. |
| active\_buyers  | The number of unique buyers on this DEX on this day.           |
| active\_sellers | The number of unique sellers on this DEX on this day.          |

### Markets & Fees

| Column Name             | Description                                                                                         |
| ----------------------- | --------------------------------------------------------------------------------------------------- |
| unique\_markets\_traded | The number of unique perpetual markets traded on this DEX on this day.                              |
| trading\_fees\_usd      | The total trading fees in USD collected by this DEX on this day.                                    |
| deployer\_fees\_usd     | The deployer's share of trading fees in USD for this DEX on this day. Subset of `trading_fees_usd`. |

### Leverage Breakdown

| Column Name                   | Description                                                           |
| ----------------------------- | --------------------------------------------------------------------- |
| high\_leverage\_volume\_usd   | The trading volume in USD on markets with 20x+ max leverage.          |
| medium\_leverage\_volume\_usd | The trading volume in USD on markets with 10-19x max leverage.        |
| low\_leverage\_volume\_usd    | The trading volume in USD on markets with less than 10x max leverage. |

### Lineage

| Column Name                     | Description                           |
| ------------------------------- | ------------------------------------- |
| \_created\_at                   | Row creation timestamp.               |
| \_updated\_at                   | Row last update timestamp.            |
| \_changed\_since\_full\_refresh | Change-tracking flag for row updates. |

## Sample Queries

### Top HIP-3 DEXes by Volume (Last 7 Days)

```sql theme={null}
SELECT 
  dex_name,
  dex_full_name,
  SUM(volume_usd) AS total_volume_usd,
  SUM(trade_count) AS total_trades,
  SUM(trading_fees_usd) AS total_fees_usd
FROM hyperliquid.metrics.dex_overview
WHERE activity_date >= CURRENT_DATE - INTERVAL '7 days'
GROUP BY dex_name, dex_full_name
ORDER BY total_volume_usd DESC
LIMIT 10;
```