elsinaFlash bounty Luna :tokens with more than 10 transfer
Updated 2022-10-07
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
›
⌄
with luna_transfer as (
select
tx:body:messages[0]:from_address as from_address,
case
when tx:body:messages[0]:amount[0]:denom = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4' then 'axlUSDC'
when tx:body:messages[0]:amount[0]:denom = 'ibc/BC8A77AFBD872FDC32A348D3FB10CC09277C266CFE52081DE341C7EC6752E674' then 'axlWETH'
when tx:body:messages[0]:amount[0]:denom = 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF' then 'axlUSDT'
when tx:body:messages[0]:amount[0]:denom = 'uluna' then 'Luna'
else null
end "Coin",
case
when tx:body:messages[0]:amount[0]:denom = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4' then tx:body:messages[0]:amount[0]:amount/1e6
when tx:body:messages[0]:amount[0]:denom = 'ibc/BC8A77AFBD872FDC32A348D3FB10CC09277C266CFE52081DE341C7EC6752E674' then tx:body:messages[0]:amount[0]:amount/1e18
when tx:body:messages[0]:amount[0]:denom = 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF' then tx:body:messages[0]:amount[0]:amount/1e6
when tx:body:messages[0]:amount[0]:denom = 'uluna' then tx:body:messages[0]:amount[0]:amount/1e6
ELSE NULL
end "Volume"
from terra.core.fact_transactions
where tx:body:messages[0]:"@type" = '/cosmos.bank.v1beta1.MsgSend' and TX_SUCCEEDED = true and "Volume" is not NULL
)
select
"Coin",count(DISTINCT from_address) as "# unique Senders", sum("Volume") as "Transfered Volume", count(1) as "# Transfers"
from
luna_transfer
group by
"Coin"
having
"# Transfers" > 10
Run a query to Download Data