mattkstewTracking USDC & USDT on Solana 4
Updated 2022-06-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
Case
when mint like 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'
when mint like 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'
when mint like '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' then 'UXD'
when mint like 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'
when mint like 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'PAI'
when mint like 'NRVwhjBQiUPYtfDT5zRBVJajzFQHaBUNtC7SNVvqRFa' then 'NIRV'
when mint like '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' then 'UST'
END as Stablecoin,
sum(amount)
from solana.core.fact_transfers
where mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',
'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' ,'7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT',
'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX', 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS',
'NRVwhjBQiUPYtfDT5zRBVJajzFQHaBUNtC7SNVvqRFa' , '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i')
group by 1
Run a query to Download Data