Day Name | Transfers Volume ($ATH) | Transfers Count | Users Count | |
|---|---|---|---|---|
1 | 1 - Mon | 569735468.065304 | 937 | 579 |
2 | 2 - Tue | 746621634.197848 | 1021 | 623 |
3 | 3 - Wed | 2088207369.46888 | 1053 | 695 |
4 | 4 - Thu | 420917676.373914 | 1127 | 671 |
5 | 5 - Fri | 793561339.491776 | 1102 | 651 |
6 | 6 - Sat | 299350822.530965 | 1102 | 697 |
7 | 7 - Sun | 403236083.628865 | 919 | 585 |
Eman-RazActivity Pattern
Updated 4 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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 ($ATH)", 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('0xbe0Ed4138121EcFC5c0E56B40517da27E6c5226B')
or data:executed:receipt:logs[1]:address=lower('0xc87B37a581ec3257B734886d9d3a581F5A9d056c'))
and call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%'
group by 1
order by 1
Last run: 4 days agoAuto-refreshes every 24 hours
7
265B
42s