winnie-fsETH: Top 10 Entities vs Others MoM stake/unstake copy
Updated 2024-09-27
999
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 TheLaughingMan / ETH: Top 10 Entities vs Others MoM stake/unstake @ https://flipsidecrypto.xyz/TheLaughingMan/q/Cqjx1uZc5KZW/eth-top-10-entities-vs-others-mom-stake-unstake
-- forked from III-1: Top 10 Entities vs Others MoM @ https://flipsidecrypto.xyz/studio/queries/a5e40dd0-5ea4-4851-b46a-e3da3c975f40
-- forked from Top 10 Entities Leaderboard @ https://flipsidecrypto.xyz/studio/queries/c5adaec7-9a2c-4efc-b10a-82949a4f60ae
---------------------------- GENERATE SAMPLE SPACE ---------------------------------
with wallet_labels as (
SELECT
wallet
, MAX(label) as label
, MAX(sub_label) as sub_label
from (
SELECT
COALESCE(WITHDRAWAL_ADDRESS, 'empty') as wallet
, MAX(PLATFORM) as label
, MAX(PLATFORM_CATEGORY) as sub_label
FROM ethereum.beacon_chain.ez_deposits
WHERE 1=1
GROUP BY 1
--AND WITHDRAWAL_ADDRESS = '0x15dace490e3bee63ba9c2695ea6d29a78360dd96'
UNION ALL
SELECT
COALESCE(WITHDRAWAL_ADDRESS, 'empty') as wallet
, MAX(WITHDRAWAL_ADDRESS_NAME) as label
, MAX(WITHDRAWAL_ADDRESS_CATEGORY) as sub_label
from ethereum.beacon_chain.ez_withdrawals
WHERE 1=1
GROUP BY 1
)
GROUP BY 1
)
,
dates as (
QueryRunArchived: QueryRun has been archived