AMOUNT_STAKED | AVERAGE_AMOUNT_STAKED | STAKERS | |
|---|---|---|---|
1 | 207294753.805681 | 7898.522951019 | 38982 |
mondovtotal staking
Updated 2025-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with stake_from_claim as (
SELECT
SUM(raw_amount/POWER(10,18)) as amount_staked,
AVG(raw_amount/POWER(10,18)) as average_amount_staked,
COUNT(DISTINCT origin_from_address) as stakers
FROM ethereum.core.fact_token_transfers t
WHERE origin_function_signature = '0x0768132f'
AND origin_to_address = '0x6571e50e8769d236414f3fb9e9b1d05341f6f79a'
)
SELECT
SUM(raw_amount/POWER(10,18)) + (SELECT amount_staked FROM stake_from_claim) as amount_staked,
AVG(raw_amount/POWER(10,18)) + (SELECT average_amount_staked FROM stake_from_claim) as average_amount_staked,
COUNT(DISTINCT origin_from_address) + (SELECT stakers FROM stake_from_claim) as stakers
FROM ethereum.core.fact_token_transfers
WHERE origin_to_address = lower('0x8E02d37b6Cad86039BDd11095b8c879B907F7D10')
AND origin_function_signature = '0x7b0472f0'
Last run: 2 months ago
1
41B
6s