mariyaSOL Staker Activity
Updated 2022-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with tinyman as (
select swapper , count(tx_group_id) as transactions ,
min(block_timestamp) as first_time
from algorand.swaps
where swap_program = 'tinyman'
group by 1
),
algofi as (
select swapper ,
min(block_timestamp) as first_time
from algorand.swaps
where swap_program = 'wagmiswap'
group by 1
)
select
case when o.first_time > t.first_time then 'used tinyman'
else 'not used tinyman'
end as type ,
count (DISTINCT o.swapper ) as users
from algofi o join tinyman t
on o.swapper = t.swapper
group by 1
Run a query to Download Data