💵Stablecoins

Macro metrics to granular transaction details of Stablecoin movements on chain.

The stablecoin schema is nested under the crosschain database.

Note that the stablecoin transfers table includes stablecoins of other currencies/assets aside from USD. Stablecoins currencies included: usd, cny, xau, eur, chf, jpy, try, cad, idr, mxn, sgd. To filter for the desired stablecoin currencies (e.g. usd), use the currency column and select the currencies based ton their iso-codes.

Tables

Table Name Description

Table Name	Description
`crosschain.stablecoin.transfers`	Transfers of all stablecoins indexed by Allium. Includes all stablecoins on `crosschain.stablecoin.list`.
`crosschain.stablecoin.list`	Table of main stablecoins (inclusive of other currencies) and their respective addresses across various chains.

crosschain.stablecoin.transfers

Transfers of all stablecoins indexed by Allium. Includes all stablecoins on crosschain.stablecoin.list.

crosschain.stablecoin.list

Table of main stablecoins (inclusive of other currencies) and their respective addresses across various chains.

Sample Query

Overview of transfers volume for USD stablecoins all chains indexed by Allium.

select 
    date_trunc('week', block_timestamp) as date,
    chain,
    symbol,
    sum(amount) as daily_volume 
    from crosschain.stablecoin.transfers 
where 1=1 
    and block_timestamp > '2023-01-01'
    and currency = 'usd' -- ISO currency code. 
group by all

Stablecoins List

List of stablecoins included in crosschain.stablecoin.transfers

This list will be continually updated to include new stablecoins and new chains.

Column Name	Description
currency	The ISO currency code (e.g. usd, eur, jpy, xau (gold)) of the stablecoin in lowercasing.
base_asset	The base assets in symbol in lowercasing. (i.e. usdt, usdc, tusd, dai, etc).
symbol	Symbol of the token in lowercasing by default.
name	Name of the token.
chain	Blockchain of the stablecoin. Note that 1 stablecoin may share the same addresses across different blockchains or have different addresses across various blockchain.
address	Address of the stablecoin in the corresponding blockchain.
is_bridge	when , this means that the stablecoin is a bridged entity from wormhole and/or bridges based on their token names.

Column Name

Description

currency

The ISO currency code (e.g. usd, eur, jpy, xau (gold)) of the stablecoin in lowercasing.

base_asset

The base assets in symbol in lowercasing. (i.e. usdt, usdc, tusd, dai, etc).

symbol

Symbol of the token in lowercasing by default.

name

Name of the token.

chain

Blockchain of the stablecoin. Note that 1 stablecoin may share the same addresses across different blockchains or have different addresses across various blockchain.

address

Address of the stablecoin in the corresponding blockchain.

is_bridge

when , this means that the stablecoin is a bridged entity from wormhole and/or bridges based on their token names.

Stablecoin Transfers

The stablecoin transfers table includes transfers from blockchains indexed by Allium.

For non-EVM compatible chains such as Solana, the underlying columns mapping for certains columns are annotated accordingly.

Column Name	Description	Example
chain	Blockchain of the transfer.	ethereum
token_type	Token Standard. (E.g. erc20, trc20, spl)	erc20
from_address	Address where the token is being transferred from. *Sender address (not token account) for Solana.	0x8ebad4aa179cb14c8939ef8d3785859a7cf45673
to_address	Address where the token is being transferred to. *Receipient address (not token account) for Solana.	0x61da7961439f671ddc02b18ce0575cc585c3dcd9
token_address	Token address of the asset transferred. *Token mint for Solana.	0xdac17f958d2ee523a2206206994597c13d831ec7
token_name	Name of the asset transferred.	Tether USD
token_symbol	Symbol of the asset transferred.	USDT
raw_amount	Amount of tokens moved (unnormalized).	1993200000
amount	Amount of token moved, normalized.	1993.2
usd_amount	USD value of the amount of tokens transferred.	1995.1932
transaction_from_address	The address of the sending party of this transaction. *Signer address for Solana.	0x8ebad4aa179cb14c8939ef8d3785859a7cf45673
transaction_to_address	The address of the receiving party of this transaction (could be a contract address). *Null for Solana	0x4f391c202a906eed9e2b63fdd387f28e952782e2
transaction_hash	Transaction hash that this transfer belongs to.	0xeb63929f60bf8a6013fcdbe6af3a6687652ecbebb53f08da08f91f24d9980e19
block_timestamp	The time when the block that contains this transaction was included on the blockchain.	2020-05-04 04:34:53
block_number	The block number that the corresponding transaction of this transfer belongs to. *Block Height for Solana.	9997570
block_hash	The block hash that the corresponding transaction of this transfer belongs to.	0x31ba5abf842755faebb7dbdd2f7a6d3d017351807b735c8eb19f4002ff9c2a5c
unique_id	Unique id generated to each transfer.	txn-0xeb63929f60bf8a6013fcdbe6af3a6687652ecbebb53f08da08f91f24d9980e19_log_index-89
currency	The ISO currency code (e.g. usd, eur, jpy, xau (gold)) of the stablecoin in lowercasing.	usd
base_asset	The base assets in symbol in lowercasing. (i.e. usdt, usdc, tusd, dai, etc).	usdt
is_bridge	when , this means that the stablecoin is a bridged entity from wormhole and/or bridges based on their token names.	FALSE

Column Name

Description

Example

chain

Blockchain of the transfer.

ethereum

token_type

Token Standard. (E.g. erc20, trc20, spl)

erc20

from_address

Address where the token is being transferred from. *Sender address (not token account) for Solana.

0x8ebad4aa179cb14c8939ef8d3785859a7cf45673

to_address

Address where the token is being transferred to. *Receipient address (not token account) for Solana.

0x61da7961439f671ddc02b18ce0575cc585c3dcd9

token_address

Token address of the asset transferred. *Token mint for Solana.

0xdac17f958d2ee523a2206206994597c13d831ec7

token_name

Name of the asset transferred.

Tether USD

token_symbol

Symbol of the asset transferred.

USDT

raw_amount

Amount of tokens moved (unnormalized).

1993200000

amount

Amount of token moved, normalized.

1993.2

usd_amount

USD value of the amount of tokens transferred.

1995.1932

transaction_from_address

The address of the sending party of this transaction. *Signer address for Solana.

0x8ebad4aa179cb14c8939ef8d3785859a7cf45673

transaction_to_address

The address of the receiving party of this transaction (could be a contract address). *Null for Solana

0x4f391c202a906eed9e2b63fdd387f28e952782e2

transaction_hash

Transaction hash that this transfer belongs to.

0xeb63929f60bf8a6013fcdbe6af3a6687652ecbebb53f08da08f91f24d9980e19

block_timestamp

The time when the block that contains this transaction was included on the blockchain.

2020-05-04 04:34:53

block_number

The block number that the corresponding transaction of this transfer belongs to. *Block Height for Solana.

9997570

block_hash

The block hash that the corresponding transaction of this transfer belongs to.

0x31ba5abf842755faebb7dbdd2f7a6d3d017351807b735c8eb19f4002ff9c2a5c

unique_id

Unique id generated to each transfer.

txn-0xeb63929f60bf8a6013fcdbe6af3a6687652ecbebb53f08da08f91f24d9980e19_log_index-89

currency

The ISO currency code (e.g. usd, eur, jpy, xau (gold)) of the stablecoin in lowercasing.

usd

base_asset

The base assets in symbol in lowercasing. (i.e. usdt, usdc, tusd, dai, etc).

usdt

is_bridge

when , this means that the stablecoin is a bridged entity from wormhole and/or bridges based on their token names.

FALSE

Last updated 1 month ago