Stablecoins

Schema: Common, Arbitrum, Avalanche, Base, Bsc, Celo, Ethereum, Optimism, Polygon, Solana, Tron, Ton

This schema contains daily metrics around transfer volume, transactions and supply for addresses, apps, and categories across different stablecoins with different filters applied.

Table Schema

Column Name

Description

Filters

Sample Query

-- ethereum stablecoin DAU and token holders by stablecoin
select
    date
    , symbol
    , count(from_address) as dau
    , count(distinct case when stablecoin_supply > 0 then from_address end) as token_holders
from art_share.ethereum.ez_stablecoin_metrics_by_address
group by date, symbol
order by date

-- stablecoin supply by application across all chains on 2024-10-01
select
    app
    , sum(stablecoin_supply) as supply
from art_share.common.ez_stablecoin_metrics_by_address
where date = '2024-10-01' and app is not null
group by date, app
having supply > 0
order by date

-- Adjusted and P2P stablecoin volume and activity
select
    date
    , symbol
    , sum(artemis_stablecoin_transfer_volume) as adjusted_transfer_volume
    , sum(artemis_stablecoin_daily_transactions) as adjusted_txns
    , sum(p2p_stablecoin_transfer_volume) as p2p_transfer_volume
    , sum(p2p_stablecoin_daily_transactions) as p2p_txns
from art_share.common.ez_stablecoin_metrics_by_address
group by date, symbol
order by date

Stablecoins Tracked

We unify symbols of stablecoins that have been bridge.

Arbitrum

Avalanche

Base

Binance Smart Chain (BSC)

Celo

Ethereum

Optimism

Polygon

Solana

TON

Tron

PreviousDeveloper Data

Last updated 20 days ago