rwa.metrics.perpetual_markets_daily table has one row per RWA perpetual futures market per day. Market details come from rwa.registry.perpetual_markets.
Table Details
| Property | Value |
|---|---|
| Table Name | rwa.metrics.perpetual_markets_daily |
| Unique Key | chain, market_identifier, activity_date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| chain | VARCHAR(16777216) | Blockchain of the market. |
| venue | VARCHAR(16777216) | Venue the market is listed on. |
| asset_class | VARCHAR(16777216) | Asset class of the referenced asset. See Classification. |
| asset_type | VARCHAR(16777216) | Asset type within asset_class. |
| issuer_id | VARCHAR(16777216) | Identifier of the market’s issuer. |
| issuer_name | VARCHAR(16777216) | Name of the market’s issuer. |
| product_id | VARCHAR(16777216) | Identifier of the market’s product. |
| underlying_asset | VARCHAR(16777216) | Ticker of the real world asset the market tracks. |
| market_identifier | VARCHAR(16777216) | Venue-specific identifier of the market. |
| ticker | VARCHAR(16777216) | Symbol of the market. |
| activity_date | TIMESTAMP_NTZ(9) | UTC date. |
| open_interest_usd | FLOAT | Open interest in USD. |
| median_open_interest_usd | FLOAT | Median open interest during the day, in USD. |
| max_open_interest_usd | FLOAT | Maximum open interest during the day, in USD. |
| day_natural_volume | FLOAT | Trading volume in USD. |
| oracle_price_usd | FLOAT | Price of the market in USD. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp this row was first created. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp this row was last updated. |
Sample Query
-- Open interest and volume by venue, last 7 days
SELECT
activity_date,
venue,
SUM(open_interest_usd) AS open_interest_usd,
SUM(day_natural_volume) AS volume_usd
FROM rwa.metrics.perpetual_markets_daily
WHERE activity_date >= CURRENT_DATE - 7
GROUP BY 1, 2
ORDER BY 1 DESC, 3 DESC