LABEL | ACTIVE_USERS | |
|---|---|---|
1 | neptune | 283 |
BlockTrackertop trending contract
Updated 2025-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with all_user as (
SELECT
block_timestamp,
tx_hash,
contract_address,
origin_from_address,
row_number() over (partition by origin_from_address order by block_timestamp) as rank
FROM swell.core.fact_event_logs
WHERE TX_SUCCEEDED
AND block_timestamp :: date >= dateadd(day, -{{past_days}}, current_date())
)
SELECT
label,
count(DISTINCT origin_from_address) as Active_users
FROM all_user a
LEFT JOIN swell.core.dim_labels b
on a.contract_address = b.address
AND label_type not in ('token', 'chadmin')
GROUP by 1
HAVING label is not null
order by 2 desc
limit 100
Last run: 21 days ago
1
17B
1s