rackhael02 - NEAR 1
Updated 2023-02-01
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
›
⌄
-- THE PATH TO DECENTRALIZATION
-- NEAR has expressed its goals to decentralize in 2023. Simply put: are these efforts working?
-- Create a stylish, refined dashboard that enables viewers to assess both individual validators on NEAR, and validation as a whole (bonus points if you find a way to enable parameters or dropdowns that display different validators).
-- As ever, you are welcome to draw on past/existing work that explores governance on NEAR, as long as you provide credit to your original sources.
-- Ensure your dashboard can answer the question: is NEAR becoming more decentralized, or less?
-- Note: make sure your dashboard can load within a few seconds! Submissions that take a while to load will not score as highly.
With staking as (
SELECT tx_hash
FROM near.core.fact_actions_events_function_call
WHERE method_name ilike '%stake%'
),
stake_actions as (
SELECT
block_timestamp,
tx_hash as tx,
tx_receiver as validator,
tx_signer as delegator,
tx:actions[0]:FunctionCall:deposit/pow(10,24) near_staked
FROM near.core.fact_transactions
WHERE tx_hash in (select * from staking)
),
dominant_validators as (
)
Run a query to Download Data