EVENT_NAME | TRANSACTIONS | USERS | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|---|
1 | Bridge From Swell | 3353 | 1685 | 109297906.529569 | 34686.736442262 |
2 | Bridge To Swell | 5872 | 3326 | 152998610.425472 | 39140.08964581 |
Afonso_DiazTotal
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: 14 days ago
2
128B
9s