Stablecoins

-- 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