DATE | OPERATOR | STAKERS | STAKED_OLAS | STAKED_USD | |
---|---|---|---|---|---|
1 | 2024-12-21 00:00:00.000 | alpha 3 | 1 | 500 | 903.75 |
2 | 2024-11-18 00:00:00.000 | alpha 3 | 2 | 1000 | 1644.166666667 |
3 | 2024-11-13 00:00:00.000 | alpha 3 | 1 | 500 | 996.458333333 |
4 | 2025-01-22 00:00:00.000 | alpha 1 | 1 | 100 | 94.760826667 |
5 | 2024-12-13 00:00:00.000 | alpha 2 | 1 | 100 | 191.083333333 |
6 | 2024-11-11 00:00:00.000 | alpha 3 | 2 | 1000 | 2137.5 |
7 | 2024-11-11 00:00:00.000 | alpha 2 | 1 | 100 | 213.75 |
8 | 2024-12-21 00:00:00.000 | alpha 2 | 1 | 100 | 180.75 |
9 | 2024-11-23 00:00:00.000 | alpha 3 | 1 | 500 | 898.125 |
10 | 2024-11-08 00:00:00.000 | alpha 1 | 1 | 100 | 227.375 |
11 | 2025-01-17 00:00:00.000 | alpha 1 | 1 | 100 | 124.916666667 |
12 | 2024-12-27 00:00:00.000 | alpha 3 | 1 | 500 | 773.125 |
13 | 2024-12-08 00:00:00.000 | alpha 1 | 1 | 100 | 211.291666667 |
14 | 2024-11-28 00:00:00.000 | alpha 3 | 1 | 500 | 792.083333333 |
15 | 2024-11-15 00:00:00.000 | alpha 3 | 1 | 500 | 806.875 |
16 | 2024-11-14 00:00:00.000 | alpha 3 | 4 | 2000 | 3418.333333333 |
17 | 2024-12-15 00:00:00.000 | alpha 3 | 1 | 500 | 1140.625 |
18 | 2024-12-19 00:00:00.000 | alpha 1 | 1 | 100 | 192.958333333 |
19 | 2025-01-19 00:00:00.000 | alpha 1 | 1 | 100 | 115.270833333 |
20 | 2024-11-26 00:00:00.000 | alpha 3 | 1 | 500 | 833.333333333 |
Sbhn_NPrural-olive
Updated 2025-01-22
99
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
›
⌄
WITH price as (
select hour::date as datee,
avg(price) as usdprice
from crosschain.price.ez_prices_hourly
where symbol = 'OLAS'
group by 1),
tab1 as (
select DISTINCT tx_hash
from crosschain.olas.ez_olas_staking
limit 100
)
select date_trunc('day',block_timestamp) as date,
case when nft_to_address = '0x95146adf659f455f300d7521b3b62a3b6c4aba1f' then 'alpha 1'
when nft_to_address = '0x2c8a5ac7b431ce04a037747519ba475884bce2fb' then 'alpha 2'
when nft_to_address = '0x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e8' then 'alpha 3' end as operator,
count(DISTINCT from_address) as stakers,
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)
join base.nft.ez_nft_transfers using(tx_hash)
left join price on block_timestamp::date = datee
where topics[0] = '0xec97633905b1dbe9773a7536e9a986dcf89803e1193934b7b6d76587c68beb40'
and to_address = '0xaea9ef993d8a1a164397642648df43f053d43d85'
and nft_from_address = '0xaea9ef993d8a1a164397642648df43f053d43d85'
and nft_to_address in ('0x95146adf659f455f300d7521b3b62a3b6c4aba1f','0x2c8a5ac7b431ce04a037747519ba475884bce2fb','0x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e8')
group by 1,2
Last run: 24 days ago
31
2KB
231s