Flipside TeamTop entities
Updated 2024-09-12
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
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Sandesh / Top entities @ https://flipsidecrypto.xyz/Sandesh/q/MVPtE64fDRnd/top-entities
-- forked from nakamoto coefficient @ https://flipsidecrypto.xyz/edit/queries/de6fa56e-b57f-465b-95d2-4ac4adf2f47d
with current_validators as
(
select *
from ethereum.beacon_chain.fact_validators
where 1=1
and block_number in ( select max(block_number) from ethereum.beacon_chain.fact_validators)
),
validators_with_names as
(
select
current_validators.*,
deposits.depositor,
deposits.deposit_address,
deposits.platform
from current_validators
left join
ethereum.beacon_chain.ez_deposits deposits
on current_validators.pubkey=deposits.pubkey
),
total_staked_table as
(
select
sum(effective_balance) as total_staked
from ethereum.beacon_chain.fact_validators
where 1=1
and block_number in ( select max(block_number) from ethereum.beacon_chain.fact_validators)
),
top_entities as
(
select
validators.platform,
sum(validators.effective_balance) as amount_staked,
QueryRunArchived: QueryRun has been archived