Afonso_DiazGrouping swaps
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
),
pricett 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