Number of Transactions | Ink Users | Number of Users | Transaction Fees | User Ratio | |
|---|---|---|---|---|---|
1 | 3404106 | 322776 | 222933 | 3.26204984 | 69.0674 |
Eman-RazTotal Stats
Updated 2025-03-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tab1 as (select count(distinct tx_hash) as "Number of Transactions",
count(distinct from_address) as "Number of Users",
sum(tx_fee) as "Transaction Fees",
from ink.core.fact_transactions
where to_address='0x9f500d075118272b3564ac6ef2c70a9067fd2d3f'
and tx_succeeded='TRUE' and (origin_function_signature='0xe884624b' -- GM_to_a_Fren
or origin_function_signature='0xc0129d43') -- GM
),
tab2 as (select count(distinct from_address) as "Ink Users"
from ink.core.fact_transactions
where tx_succeeded='TRUE')
select "Number of Transactions","Ink Users", "Number of Users", "Transaction Fees", ("Number of Users"/"Ink Users")*100 as "User Ratio"
from tab1 , tab2
Last run: about 1 month ago
1
44B
2s