mar1na-catscatscodetx volume by token
Updated 2022-06-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
select
block_timestamp::date as block_date,
case
when mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then 'USDC'
when mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then 'USDT'
when mint = '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' then 'UXD'
when mint = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' then 'USDH'
when mint = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' then 'PAI'
when mint = 'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71' then 'NIRV'
when mint = 'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o' then 'DAI'
when mint = 'FR87nWEUxVgerFGhZM8Y4AggKGLnaXswr1Pd8wZ4kZcp' then 'FRAX'
when mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' then 'UST Portal'
end as token,
count(distinct tx_id) as n_transactions,
sum(amount) as total
from solana.core.fact_transfers
where mint in (
'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', --USDC
'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', --USDT
'7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT', --UXD
'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX', --USDH
'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS', --PAI
'AJ6EVZEePA5HAn58ZRbLCWX3MsK2BKrkT6bJYunuTU71', --NIRV
'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o', --DAI Portal
'FR87nWEUxVgerFGhZM8Y4AggKGLnaXswr1Pd8wZ4kZcp', --FRAX
'9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' --UST Portal
)
group by block_date, token