CHAIN | SWAPPERS | |
|---|---|---|
1 | Swell | 71 |
2 | Ink | 6628 |
hess16. Total Chains
Updated 2025-03-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with base as ( select block_timestamp::Date as date,
'Ink' as chain,
tx_hash,
origin_from_address
from ink.core.fact_event_logs
where origin_to_address = lower('0x652e53C6a4FE39B6B30426d9c96376a105C89A95')
and block_timestamp::Date >= current_date - 7
union
select block_timestamp::Date as date,
'Swell' as chain,
tx_hash,
origin_from_address
from swell.core.fact_event_logs
where origin_to_address = lower('0x652e53C6a4FE39B6B30426d9c96376a105C89A95')
and block_timestamp::Date >= current_date - 7)
select
chain,
count(distinct origin_from_address) as swappers
from base
group by 1
Last run: about 2 months ago
2
27B
1s