flyingfishMATIC staked by ValidatorId
Updated 2022-09-19
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
›
⌄
with cte AS (
SELECT
date_trunc('week', block_timestamp) AS week
, event_inputs:validatorId as validatorId
, sum(event_inputs:amount / pow(10,18)) as stakingAmount
, sum(stakingAmount) OVER (PARTITION BY validatorId ORDER BY week) AS cumulativeStakingAmount
FROM ethereum.core.fact_event_logs
WHERE block_timestamp >= '2022-07-01'
AND contract_address = lower('0xa59c847bd5ac0172ff4fe912c5d29e5a71a7512b')
AND origin_function_signature = '0x6ab15071' -- buyVoucher
AND event_name = 'ShareMinted'
GROUP BY week, validatorId
),
topVal AS (
SELECT validatorId
FROM cte
WHERE week = (SELECT max(week) FROM cte)
ORDER BY cumulativeStakingAmount DESC
LIMIT 9
)
SELECT *
FROM cte
WHERE validatorId IN (SELECT * FROM topVal)
ORDER BY week, validatorId
Run a query to Download Data