SWAPS | SWAPPERS | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|
1 | 27 | 5 | 2070.909113725 | 69.030303791 |
Afonso_DiazTotal
Updated 2025-04-06
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,
case token_address
when '0x8db2350d78abc13f5673a411d4700bcf87864dde' then 'swBTC'
when '0xfae103dc9cf190ed75350761e95403b7b8afa6c0' then 'rswETH'
when '0x0a6e7ba5042b38349e437ec6db6214aec7b35676' then 'SWELL'
when '0xf951e335afb289353dc249e82926178eac7ded78' then 'swETH'
when '0xecac9c5f704e954931349da37f60e39f515c11c1' then 'LBTC'
when '0x4c9edd5852cd905f086c759e8383e09bff1e68b3' then 'USDe'
when '0x9d39a5de30e57443bff2a8307a4256c8797a3497' then 'sUSDe'
when '0xf6718b2701d4a6498ef77d7c152b2137ab28b8a3' then 'stBTC'
when '0x57e114b691db790c35207b2e685d4a43181e6061' then 'ENA'
when '0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee' then 'weETH'
when '0xa1290d69c65a6fe4df752f95823fae25cb99e5a7' then 'rsETH'
when '0x2416092f143378750bb29b79ed961ab195cceea5' then 'ezETH'
end as symbol,
avg(price) as token_price_usd
from
crosschain.price.ez_prices_hourly
Last run: 20 days ago
1
36B
13s