MLDZMNtrade3
Updated 2023-01-11
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
›
⌄
select
PROJECT_NAME,
case
when TO_currency in ('ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4','terra1uc3r74qg44csdrl8hrm5muzlue9gf7umgkyv569pgazh7tudpr4qdtgqh6') then 'USDC'
when TO_currency in ('ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF','terra1rcmvfsn77pd6m04ctqj3wcu66pvrw9p265cdl72w4zarfup2rv7qjxhkzl') then 'USDT'
end as stable_coins,
concat(PROJECT_NAME,'->',stable_coins) as swap_pair,
count(distinct tx_id) as no_txn,
count(distinct TRADER) as no_users,
sum(TO_AMOUNT/1e6) as volume,
avg(TO_AMOUNT/1e6) as avg_volume
from terra.core.ez_swaps s left join terra.core.dim_address_labels a on s.from_currency=a.address
where TO_currency in ('ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4','terra1uc3r74qg44csdrl8hrm5muzlue9gf7umgkyv569pgazh7tudpr4qdtgqh6' --usdc
,'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF','terra1rcmvfsn77pd6m04ctqj3wcu66pvrw9p265cdl72w4zarfup2rv7qjxhkzl') --usdt
and TX_SUCCEEDED='TRUE' and PROJECT_NAME is not null and block_timestamp>='2022-12-25'
group by 1,2,3 having volume >1000
union all
select
PROJECT_NAME,
case
when FROM_currency in ('ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4','terra1uc3r74qg44csdrl8hrm5muzlue9gf7umgkyv569pgazh7tudpr4qdtgqh6') then 'USDC'
when FROM_currency in ('ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF','terra1rcmvfsn77pd6m04ctqj3wcu66pvrw9p265cdl72w4zarfup2rv7qjxhkzl') then 'USDT'
end as stable_coins,
concat(stable_coins,'->',PROJECT_NAME) as swap_pair,
count(distinct tx_id) as no_txn,
count(distinct TRADER) as no_users,
sum(FROM_AMOUNT/1e6) as volume,
avg(FROM_AMOUNT/1e6) as avg_volume
from terra.core.ez_swaps s left join terra.core.dim_address_labels a on s.TO_currency=a.address
where FROM_currency in ('ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4','terra1uc3r74qg44csdrl8hrm5muzlue9gf7umgkyv569pgazh7tudpr4qdtgqh6' --usdc
,'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF','terra1rcmvfsn77pd6m04ctqj3wcu66pvrw9p265cdl72w4zarfup2rv7qjxhkzl') --usdt
and TX_SUCCEEDED='TRUE'
and PROJECT_NAME is not null and block_timestamp>='2022-12-25'
group by 1,2,3 having volume >1000
Run a query to Download Data