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

​
Stablecoin Metrics By Address

Used to understand:
  1. Granular address activity for every stablecoin holders
  2. On chain holder distribution and activity drivers
  3. Broad macro level drivers and trends on chain
Table Schema
Column NameDescription
DATEThe date of identified activity
ADDRESSThe from address of the transfer event associated with the activity identified in the row
ARTEMIS_APPLICATION_ID, ARTEMIS_CATEGORY_ID, APPLICATION, ICON, FRIENDLY_NAME, NAMEA series of metadata columns tagged to the ADDRESS
IS_WALLETIdentifier (0,1) if the ADDRESS is an EOA
CONTRACT_ADDRESSContract address of the stablecoin token
SYMBOLSymbol of the stablecoin token
STABLECOIN_TRANSFER_VOLUMEThe stablecoin transfer volume for the identified DATE, ADDRESS, and CONTRACT_ADDRESS. Three columns exist to identify different filters applies with the following prefixes: P2P, ARTEMIS, None
STABLECOIN_DAILY_TXNSThe daily sum of stablecoins transfers for the identified DATE, ADDRESS, and CONTRACT_ADDRESS. Three columns exist to identify different filters applies with the following prefixes: P2P, ARTEMIS, None
STABLECOIN_SUPPLYThe stablecoin balance rounded to $0.01 of the FROM_ADDRESS for a stablecoin (CONTRACT_ADDRESS) on a particular DATE
CHAINThe chain associated the activity identified in the row
UNIQUE_IDA unique id identifing the row. This is a concatenation of DATE-FROM_ADDRESS-CONTRACT_ADDRESS-CHAIN
Filters
FilterDescription
NoneUnfiltered Stablecoin Activity
ARTEMISAdjusted stablecoin activity is defined as deduped stablecoin activity less intra exchange transfers and MEV. De-dupping is the process of selecting the largest transfer for a transaction. Intra exchange activity is defined as transfers between tagged addresses for the same exchange (e.g. coinbase moving money from a deposit wallet to a cold wallet). The goal is to estimate “real” stablecoin activity.
P2PStablecoin activity between wallets/Externally Owned Accounts (EOAs)
Sample Query 
-- ethereum stablecoin DAU and token holders by stablecoin
select
    date
    , symbol
    , count(address) as dau
    , count(distinct case when stablecoin_supply > 0 then address end) as token_holders
from art_share.ethereum.ez_stablecoin_metrics_by_address_with_labels
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
Table NamesDescriptions
EZ_STABLECOIN_METRICS_BY_ADDRESS_WITH_LABELSSchema identified above. This table provides daily information of an address and stablecoin combination.
EZ_STABLECOIN_METRICSAggregate table down stream of EZ_STABLECOIN_METRICS_BY_ADDRESS_WITH_LABELS. This table is only avaiable in the COMMON schema. For aggregate stablecoin metrics by chain use the EZ_METRICS table.

​
Stablecoin Transfers

Standardized Stablecoin Transaction. Table Schema
Column NameDescription
DATEThe date of identified activity
BLOCK_TIMESTAMPTimestamp of the transaction in UTC
BLOCK_NUMBERBlock Identifier
TX_HASHTransaction Hash
INDEXIndex of the event in the block
CONTRACT_ADDRESSContract address of the stablecoin token
FROM_ADDRESSSender of the transaction
TO_ADDRESSRecipient of the transaction
IS_MINTBoolean identifier of mint event
IS_BURNBoolean identifier of burn event
IS_BRIDGE_MINTBoolean identifier if the transfer is recieving from another chain
IS_BRIDGE_BURNBoolean identifier if the transfer is sending to another chain
AMOUNTDecimal adjusted amount transfered
INFLOWPositive if its a mint, negative if the transfer is a burn
TRANSFER_VOLUME0 if it is a mint or burn otherwise equals amount
Stablecoins Tracked We track metrics across 14 different chains and over 100 different stablecoins
SymbolSymbol in DatabaseContract Address
USDCUSDC0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b
USDTUSDT0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b