Txn Type | Number of Transactions | Number of Users | Transaction Fees | |
|---|---|---|---|---|
1 | GM | 5841920 | 171288 | 4.2622365 |
2 | GM to a Fren | 1563421 | 132507 | 0.8227714435 |
Eman-RazTotal Stats By Type
Updated 9 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select case
when origin_function_signature='0xe884624b' then 'GM to a Fren'
when origin_function_signature='0xc0129d43' then 'GM'
end as "Txn Type",
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
group by 1
Last run: 9 days ago
2
78B
7s