Eman-Raztotal stats: user & transfers
Updated 2024-07-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select count(distinct id) as "Transfers Count", count(distinct call:transaction:from) as "Users Count"
from axelar.axelscan.fact_gmp
where call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%'
and (data:executed:receipt:logs[1]:address=lower('0xf88baf18fab7e330fa0c4f83949e23f52fececce')
or data:executed:receipt:logs[1]:address=lower('0x02838746d9e1413e07ee064fcbada57055417f21')
or data:executed:receipt:logs[1]:address=lower('0xfd389dc9533717239856190f42475d3f263a270d')
or data:executed:receipt:logs[1]:address=lower('0x8f87a7d376821c7b2658a005aaf190ec778bf37a')
or data:executed:receipt:logs[1]:address=lower('0x9df4ac62f9e435dbcd85e06c990a7f0ea32739a9')
or data:executed:receipt:logs[1]:address=lower('0x80bb30d62a16e1f2084deae84dc293531c3ac3a1')
or data:executed:receipt:logs[1]:address=lower('0xE1537feF008944D1c8DcAfBAcE4DC76D31D22DC5')
or data:executed:receipt:logs[1]:address=lower('0x8429d0AFade80498EAdb9919E41437A14d45A00B'))
and (created_at::date between '{{Start_Date}}' and '{{End_Date}}')
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived