DAY | TOTAL_LOCKS | UNIQUE_LOCKERS | TOTAL_UNLOCKS | UNIQUE_UNLOCKERS | |
|---|---|---|---|---|---|
1 | 2024-12-18 00:00:00.000 | 2 | 2 | 1 | 1 |
2 | 2024-12-19 00:00:00.000 | 6 | 6 | 0 | 0 |
3 | 2024-12-20 00:00:00.000 | 24 | 24 | 0 | 0 |
4 | 2024-12-21 00:00:00.000 | 30 | 30 | 0 | 0 |
5 | 2024-12-22 00:00:00.000 | 41 | 41 | 1 | 1 |
6 | 2024-12-23 00:00:00.000 | 35 | 35 | 0 | 0 |
7 | 2024-12-24 00:00:00.000 | 41 | 41 | 0 | 0 |
8 | 2024-12-25 00:00:00.000 | 48 | 48 | 0 | 0 |
9 | 2024-12-26 00:00:00.000 | 50 | 50 | 0 | 0 |
10 | 2024-12-27 00:00:00.000 | 52 | 51 | 0 | 0 |
11 | 2024-12-28 00:00:00.000 | 56 | 55 | 0 | 0 |
12 | 2024-12-29 00:00:00.000 | 66 | 65 | 0 | 0 |
13 | 2024-12-30 00:00:00.000 | 60 | 59 | 1 | 1 |
14 | 2024-12-31 00:00:00.000 | 96 | 96 | 0 | 0 |
15 | 2025-01-01 00:00:00.000 | 88 | 88 | 0 | 0 |
16 | 2025-01-02 00:00:00.000 | 109 | 109 | 0 | 0 |
17 | 2025-01-03 00:00:00.000 | 80 | 80 | 0 | 0 |
18 | 2025-01-04 00:00:00.000 | 62 | 62 | 0 | 0 |
19 | 2025-01-05 00:00:00.000 | 50 | 50 | 0 | 0 |
20 | 2025-01-06 00:00:00.000 | 87 | 87 | 0 | 0 |
permarytotal locked & unlocked tokens over time
Updated 2025-04-05
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
26
27
28
29
30
31
›
⌄
with
locked as (
select
date_trunc('day', block_timestamp) as day,
count(distinct tx_hash) as total_locks,
count(distinct origin_from_address) as unique_lockers
from swell.core.ez_decoded_event_logs
where event_name = 'LockCreated'
group by 1
),
unlocked as (
select
date_trunc('day', block_timestamp) as day,
count(distinct tx_hash) as total_unlocks,
count(distinct origin_from_address) as unique_unlockers
from swell.core.ez_decoded_event_logs
where event_name = 'LockRemoved'
group by 1
)
select
coalesce(l.day, u.day) as day,
coalesce(total_locks, 0) as total_locks,
coalesce(unique_lockers, 0) as unique_lockers,
coalesce(total_unlocks, 0) as total_unlocks,
coalesce(unique_unlockers, 0) as unique_unlockers
from locked l
full outer join unlocked u
on l.day = u.day
order by day;
Last run: 2 months ago
...
109
4KB
2s