Txns Count | Users Count | Txn Count per User | |
|---|---|---|---|
1 | 47480660 | 231012 | 205.533306 |
Eman-Raztotal stats
Updated 2025-03-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with tab3 as (with tab1 as (select distinct address
from kaia.core.dim_labels
where label_type='games' and project_name='superwalk'),
tab2 as (select block_timestamp, tx_hash, origin_from_address, origin_to_address
from kaia.core.fact_event_logs)
select block_timestamp, tx_hash, origin_from_address
from tab1 left join tab2 on tab1.address=tab2.origin_to_address)
select count(distinct tx_hash) as "Txns Count",
count(distinct origin_from_address) as "Users Count",
count(distinct tx_hash)/count(distinct origin_from_address) as "Txn Count per User"
FROM TAB3
where block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
Last run: 28 days agoAuto-refreshes every 24 hours
1
30B
198s