Eman-RazTop 5 Interchain Tokens By Transaction Count
Updated 2025-01-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with final_table as (with tab1 as (select data:executed:receipt:logs[1]:address as token, id, call:transaction:from as user
from axelar.axelscan.fact_gmp
where call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%'
and (created_at::date between '{{Start_Date}}' and '{{End_Date}}')
and data:executed:receipt:logs[1]:address is not null),
tab2 as (select address, name, symbol
from crosschain.core.dim_contracts)
select name, symbol, count(distinct id) as "Transfers Count", count(distinct user) as "Users Count"
from tab1 left join tab2 on tab1.token=tab2.address
where name is not null
group by 1 ,2)
select name, symbol, "Transfers Count", "Users Count"
from final_table
where "Users Count">=10
order by 3 desc
limit 10
QueryRunArchived: QueryRun has been archived