Trades

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

Trades
Equities Trades

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

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Overview

Methodology

Tables

Table Columns

Sample Query

​Overview

​Methodology

​Tables

​Table Columns

​Sample Query

Overview

Methodology

Tables

Table Columns

Sample Query