MoeActivity Pattern copy
Updated 2024-09-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select case when dayofweek(created_at)=0 then 7 else dayofweek(created_at) end||' - '||dayname(created_at) as "Day Name",
sum(amount) as "Transfers Volume ($WAI)", count(distinct id) AS "Transfers Count", count(distinct call:transaction:from) as "Users Count"
from axelar.axelscan.fact_gmp
where created_at::date between '{{Start_Date}}' and '{{End_Date}}'
and (data:executed:receipt:logs[1]:address=lower('0x129ed667bf8c065fe5f66c9b44b7cb0126d85cc3')
-- or data:executed:receipt:logs[1]:address=lower('0xc87B37a581ec3257B734886d9d3a581F5A9d056c')
)
and call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%'
group by 1
order by 1
QueryRunArchived: QueryRun has been archived