Overview
The trades tables capture trading activity for RWA tokens across both dedicated RWA platforms and decentralized exchanges.
This includes trades for all asset classes as well as specialized equities trading data.
Methodology
-
RWA Platforms: RWA platforms are tokenization platforms that allow users to buy/sell tokenized assets directly. One example is Ondo Global Markets, where users can buy/sell tokenized assets directly. We currently support Ondo, Dinari, StableStock, Swarm.
-
DEXs: DEXs are decentralized exchanges that allow users to buy/sell tokenized assets directly from liquidity pools. One example is Uniswap V3, where users can buy/sell tokenized assets directly. This includes all EVM and Solana DEXs supported by Allium.
-
Perpetual Futures: Perpetual futures are futures contracts that never expire. We currenly support Hyperliquid HIP-3 (Hyperliquid Improvement Proposal 3) which enables permissionless perpetual futures markets.
The trades tables are currently in Beta. The coverage and metrics supported
will be expanded over time.
Tables
| Table Name | Description |
|---|
crosschain.rwa.trades | All RWA trades across different blockchains and platforms (RWA platforms and DEXs). |
crosschain.rwa.equities_trades | Trades executed on tokenized equities across different blockchains. Filtered from the crosschain.rwa.trades table. |
Table Columns
All RWA trades across different blockchains and platforms. Includes trades from RWA platforms (Ondo, Dinari, StableStock, Swarm, HIP-3) and DEX trades (EVM + Solana).Unique key: unique_id| Column Name | Description |
|---|
chain | The blockchain network where the RWA token is traded (e.g., ethereum, solana, bsc) |
platform_type | The type of platform (rwa_platform or dex) |
platform | The platform where the RWA token is traded (e.g., ondo_global_markets, uniswap_v3) |
asset_class | Top-level V2 classification (rates, equities, credit, fx, commodities, private_funds, real_estate) |
asset_type | Granular V2 sub-classification within the asset class |
issuer | The issuer of the RWA token (e.g., ondo, dinari, swarm) |
product_id | Unique identifier for the RWA product |
token_address | The contract address of the RWA token |
ticker | The ticker of the RWA token |
underlying_ticker | The underlying ticker of the RWA token (e.g., the stock ticker that the token represents) |
name | The name of the RWA token |
side | The side of the trade (buy or sell) |
rwa_side | The RWA-specific trade classification: ‘buy’ (buying RWA with non-RWA token), ‘sell’ (selling RWA for non-RWA token), or ‘rwa_to_rwa’ (trading one RWA token for another) |
amount | The amount of the RWA token traded |
price | The price of the RWA token traded |
usd_amount | The USD value of the RWA token traded in total |
block_timestamp | The timestamp of the block when the trade was executed |
block_number | The number of the block when the trade was executed |
transaction_hash | The hash of the transaction |
transaction_from_address | The address that initiated the transaction |
extra_fields | Additional fields containing trade-specific metadata (variant type) |
unique_id | The unique identifier for the trade |
_created_at | The timestamp when the trade was created |
_updated_at | The timestamp when the trade was last updated |
Trades executed on tokenized equities across different blockchains.Unique key: unique_id| Column Name | Description |
|---|
chain | The blockchain network where the RWA token is traded (e.g., ethereum, solana, bsc) |
platform_type | The type of platform (rwa_platform or dex) |
platform | The platform where the RWA token is traded (e.g., ondo_global_markets, uniswap_v3) |
asset_class | Top-level V2 classification (rates, equities, credit, fx, commodities, private_funds, real_estate) |
asset_type | Granular V2 sub-classification within the asset class |
issuer | The issuer of the RWA token (e.g., ondo, dinari, swarm) |
product_id | Unique identifier for the RWA product |
token_address | The contract address of the RWA token |
ticker | The ticker of the RWA token |
underlying_ticker | The underlying ticker of the RWA token (e.g., the stock ticker that the token represents) |
name | The name of the RWA token |
side | The side of the trade (buy or sell) |
rwa_side | The RWA-specific trade classification: ‘buy’ (buying RWA with non-RWA token), ‘sell’ (selling RWA for non-RWA token), or ‘rwa_to_rwa’ (trading one RWA token for another) |
amount | The amount of the RWA token traded |
price | The price of the RWA token traded |
usd_amount | The USD value of the RWA token traded in total |
block_timestamp | The timestamp of the block when the trade was executed |
block_number | The number of the block when the trade was executed |
transaction_hash | The hash of the transaction |
transaction_from_address | The address that initiated the transaction |
extra_fields | Additional fields containing trade-specific metadata (variant type) |
unique_id | The unique identifier for the trade |
_created_at | The timestamp when the trade was created |
_updated_at | The timestamp when the trade was last updated |
Sample Query
select date(block_timestamp) as date, platform_type, sum(usd_amount) as usd
from crosschain.rwa.trades
group by all
