EVENT_NAME | TYPE | TRANSACTIONS | |
|---|---|---|---|
1 | Bridge To Swell | $10 - $50 | 398 |
2 | Bridge To Swell | $100 - $500 | 539 |
3 | Bridge To Swell | $10k - $100k | 589 |
4 | Bridge To Swell | $1k - $5k | 815 |
5 | Bridge To Swell | $50 - $100 | 191 |
6 | Bridge To Swell | $500 - $1k | 252 |
7 | Bridge To Swell | $5k - $10k | 342 |
8 | Bridge To Swell | Above $100k | 2081 |
9 | Bridge To Swell | Below $10 | 665 |
Afonso_DiazClassifying Deposit Transactions
Updated 2025-04-10
999
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
32
33
34
35
36
›
⌄
with
tokens as (
select
symbol,
decimals,
address as token_address
from
swell.core.dim_contracts
union all
select 'enzoBTC', 8, '0x6a9a65b84843f5fd4ac9a0471c4fc11afffbce4a'
union all
select 'swBTC', 18, '0xd557a21f78045380142a7bbccbca0fe3746a0787'
union all
select 'swBTC', 18, '0xe786314c7ee33bb45aaf72dd374d715da1c414e7'
union all
select 'earnETH', 18, '0x9ed15383940cc380faef0a75edace507cc775f22'
),
pricet as (
select
hour::date as date,
case token_address
when '0x8db2350d78abc13f5673a411d4700bcf87864dde' then 'swBTC'
when '0xfae103dc9cf190ed75350761e95403b7b8afa6c0' then 'rswETH'
when '0x0a6e7ba5042b38349e437ec6db6214aec7b35676' then 'SWELL'
when '0xf951e335afb289353dc249e82926178eac7ded78' then 'swETH'
when '0xecac9c5f704e954931349da37f60e39f515c11c1' then 'LBTC'
Last run: 11 days ago
9
336B
9s