Moetera cont 11
Updated 2022-12-21
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
31
32
33
34
35
36
›
⌄
-- with base as (select ADDRESS,label from
-- terra.core.dim_address_labels
-- where
-- LABEL_TYPe ilike '%token%' and LABEL in ( 'USDT' ,'usdc', 'UST' , 'ust' ) )
SELECT
'axlUSDT' as type ,
transfer_type, sum(amount/1e6) as amounts,
count(distinct sender) as senders,
count(distinct RECEIVER) as RECEIVERs
from terra.core.ez_transfers
where currency in (
'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF'
)
group by transfer_type
union
-- with base as (select ADDRESS,label from
-- terra.core.dim_address_labels
-- where
-- LABEL_TYPe ilike '%token%' and LABEL in ( 'USDT' ,'usdc', 'UST' , 'ust' ) )
SELECT
'axlUSDC' as type ,
transfer_type, sum(amount/1e6) as amounts,
count(distinct sender) as senders,
count(distinct RECEIVER) as RECEIVERs
from terra.core.ez_transfers
Run a query to Download Data