akbaridriastablecoin arb 1
Updated 2022-07-27
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
29
30
›
⌄
-- 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 usdt
-- 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 usdc
-- 0xda10009cbd5d07dd0cecc66161fc93d7c9000da1 dai
-- 0x17fc002b466eec40dae837fc4be5c67993ddbd6f frax
-- 0x4d15a3a2286d883af0aa1b3f21367843fac63e07 tusd
-- 0x680447595e8b7b3aa1b43beb9f6098c79ac2ab3f usdd
select
block_timestamp::date as date,
case
when contract_address = '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' then 'USDT'
when contract_address = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' then 'USDC'
else 'Others'
end as label,
sum(raw_amount/pow(10, case when contract_address in ('0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9', '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8') then 6 else 18 end)) as total_volumes,
sum(total_volumes) over (partition by label order by block_timestamp::date) as cumulative,
count(distinct origin_from_address) as total_users
from
arbitrum.core.fact_token_transfers
where
contract_address in (
'0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9',
'0xff970a61a04b1ca14834a43f5de4533ebddb5cc8',
'0xda10009cbd5d07dd0cecc66161fc93d7c9000da1',
'0x17fc002b466eec40dae837fc4be5c67993ddbd6f',
'0x4d15a3a2286d883af0aa1b3f21367843fac63e07',
'0x680447595e8b7b3aa1b43beb9f6098c79ac2ab3f'
)
and
block_timestamp::date >= CURRENT_DATE - 30
group by 1, 2
Run a query to Download Data