STAKERS | STAKED_OLAS | STAKED_USD | |
---|---|---|---|
1 | 0xf4a697253285a02c70de95c9cba5a645061c9e26 | 500 | 1068.75 |
2 | 0xf6e76bd170097e7f305d9ecd098632ab69b69c07 | 500 | 855.625 |
3 | 0xa0d03601ec64fd3b9ddc9975d1f1d436355fae73 | 500 | 1140.625 |
4 | 0x6bd9f43a4402a5910c8e1065a45cbb198253b454 | 500 | 1075.416666667 |
5 | 0xc362756d13e9dcb2c59ddfc8dc260f100bceb9f4 | 500 | 901.458333333 |
6 | 0x23268a34d4ca89b02a6e40414c9c4b3c3c99993c | 500 | 854.583333333 |
7 | 0xb136da9aa24707fd6a49f0bb29d3f1fae09f13f7 | 500 | 903.75 |
8 | 0x5c118887d2d339aa9e6aa37661e426e5f31e3c77 | 500 | 1068.75 |
9 | 0x864c4721c0d1550286c0dd77ce16e415a36e343a | 500 | 996.458333333 |
10 | 0xfe8fd3a9c48e1c92f1db2b98e8682c1c38c10651 | 500 | 860.833333333 |
11 | 0xe42f3cdd29d45260b9ae68d32751251c55772bc6 | 500 | 898.125 |
12 | 0xb77337bc71122bb62999d9dc5724852f9cbca192 | 500 | 854.583333333 |
13 | 0x1ce8801af828837e726b7d5415d6674b4217e1d6 | 500 | 806.875 |
14 | 0x3500ecbdedb4887e45e45a79de5a98581097e736 | 500 | 822.083333333 |
15 | 0xe43d22c424a7d3727403f0348c9a8534499cacbb | 500 | 641.458333333 |
16 | 0xe8dd43c90244ad0fcfd46b0fa329e2f0cb940fed | 500 | 641.458333333 |
17 | 0x2236b805cc6aa7a9f692fd20d470f08919813d3f | 500 | 773.125 |
18 | 0x5ff1bdc2d47d10560ce951415d2afdff646d96fd | 500 | 792.083333333 |
19 | 0xc81124c0b73a727926ff383a896ff5ec9879fe98 | 500 | 1201.458333333 |
20 | 0x93416f9986a1dc086d6649eddcf246d6830edfe2 | 500 | 623.541666667 |
Sbhn_NPadded-yellow
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
›
⌄
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 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)
left join price on block_timestamp::date = datee
where topics[0] = '0xec97633905b1dbe9773a7536e9a986dcf89803e1193934b7b6d76587c68beb40'
and to_address = '0xaea9ef993d8a1a164397642648df43f053d43d85'
group by 1
order by 2 desc
-- select DISTINCT tx_hash, concat('0x', right(topics[1],40)) as multisig,
-- amount
-- from base.core.fact_event_logs
-- join base.core.ez_token_transfers b using(tx_hash)
-- where topics[0] = '0xec97633905b1dbe9773a7536e9a986dcf89803e1193934b7b6d76587c68beb40'
-- and to_address = '0xaea9ef993d8a1a164397642648df43f053d43d85'
Last run: 24 days ago
37
2KB
231s