TYPE | SYMBOL | TRANSACTIONS | USERS | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|---|---|
1 | Bridge From Swell | ezETH | 2780 | 2101 | 12539935.3805697 | 4510.768122507 |
2 | Bridge From Swell | pzETH | 60 | 46 | 3867557.06051351 | 64459.284341892 |
3 | Bridge From Swell | uBTC | 1455 | 843 | 54377662.150215 | 37372.963677124 |
4 | Bridge To Swell | ezETH | 5033 | 4093 | 14923925.2390232 | 2965.214631238 |
5 | Bridge To Swell | pzETH | 94 | 64 | 8487086.50459716 | 90288.154304225 |
6 | Bridge To Swell | uBTC | 1570 | 892 | 63819494.7066672 | 40649.359685775 |
Afonso_DiazBy Symbol and Type
Updated 2025-05-19
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
case address
when '0xe786314c7ee33bb45aaf72dd374d715da1c414e7' then 'swBTC'
when '0xd557a21f78045380142a7bbccbca0fe3746a0787' then 'swBTC'
when '0x6a9a65b84843f5fd4ac9a0471c4fc11afffbce4a' then 'enzoBTC'
else symbol
end as symbol,
decimals,
address as token_address
from
swell.core.dim_contracts
),
pricet as (
select
hour::date as date,
'pzETH' as symbol,
avg(price) as token_price_usd
from
crosschain.price.ez_prices_hourly
where
blockchain = 'ethereum'
and token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
group by 1, 2
union all
select
hour::date as date,
'uBTC',
avg(price) as token_price_usd
from
crosschain.price.ez_prices_hourly
Last run: 30 days ago
6
418B
42s