TRANSACTIONS | USERS | DAILY_AVERAGE_TRANSACTIONS | DAILY_AVERAGE_USERS | |
|---|---|---|---|---|
1 | 9225 | 3948 | 77.521008 | 33.176471 |
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: 17 days ago
1
33B
24s