USER_COUNT | TX_COUNT | TOKEN_COUNT | DEPOSITORS_COUNT | WITHDRAWERS_COUNT | DEPOSITS_COUNT | WITHDRAWALS_COUNT | |
|---|---|---|---|---|---|---|---|
1 | 1042 | 9255 | 14 | 926 | 720 | 5512 | 4392 |
elsinaTotal activity
Updated 2025-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
count(distinct origin_from_address) as user_count,
count(distinct tx_hash) as tx_count,
count(distinct contract_name) as token_count,
count(distinct case when event_name = 'Deposit' THEN origin_from_address END) as depositors_count,
count(distinct case when event_name = 'Withdrawal' THEN origin_from_address END) as withdrawers_count,
count(distinct case when event_name = 'Deposit' THEN tx_hash END) as deposits_count,
count(distinct case when event_name = 'Withdrawal' THEN tx_hash END) as withdrawals_count,
from
swell.core.ez_decoded_event_logs
where
event_name in ('Withdrawal', 'Deposit')
Last run: about 2 months ago
1
34B
2s