STAKERS | MULTISIGS | STAKED_OLAS | STAKED_USD | |
---|---|---|---|---|
1 | 37 | 37 | 13300 | 23403.40666 |
Sbhn_NPtender-tomato
Updated 2025-01-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH price as (
select hour::date as datee,
avg(price) as usdprice
from crosschain.price.ez_prices_hourly
where symbol = 'OLAS'
group by 1)
select count(DISTINCT from_address) as stakers,
count(DISTINCT concat('0x', right(topics[1],40))) as multisigs,
sum(amount) as staked_olas,
sum(amount*usdprice) as staked_usd,
from base.core.fact_event_logs
join base.core.ez_token_transfers b using(tx_hash)
left join price on block_timestamp::date = datee
where topics[0] = '0xec97633905b1dbe9773a7536e9a986dcf89803e1193934b7b6d76587c68beb40'
and to_address = '0xaea9ef993d8a1a164397642648df43f053d43d85'
Last run: 24 days ago
1
27B
231s