Day Name | Transfers Volume ($ATH) | Transfers Count | Users Count | |
|---|---|---|---|---|
1 | 1 - Mon | 524256043.913763 | 783 | 502 |
2 | 2 - Tue | 546951057.190481 | 855 | 549 |
3 | 3 - Wed | 1998419020.87029 | 882 | 601 |
4 | 4 - Thu | 277399655.617766 | 922 | 570 |
5 | 5 - Fri | 449086785.947359 | 921 | 583 |
6 | 6 - Sat | 227305245.397509 | 949 | 624 |
7 | 7 - Sun | 344210596.268192 | 787 | 526 |
Eman-RazActivity Pattern
Updated 2025-03-04
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: 29 days agoAuto-refreshes every 24 hours
7
260B
9s