mondovstaking
Updated 2025-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with stake_from_claim as (
SELECT
date_trunc('hour', block_timestamp) as hour,
'Claim & Stake' as type,
SUM(raw_amount/POWER(10,18)) as 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'
GROUP BY 1
)
SELECT
date_trunc('hour', block_timestamp) as hour,
'Stake' as type,
SUM(raw_amount/POWER(10,18)) as amount_staked,
COUNT(DISTINCT origin_from_address) as stakers
FROM ethereum.core.fact_token_transfers
WHERE origin_to_address = lower('0x8E02d37b6Cad86039BDd11095b8c879B907F7D10')
AND origin_function_signature = '0x7b0472f0'
GROUP BY 1
UNION ALL
SELECT * FROM stake_from_claim
QueryRunArchived: QueryRun has been archived