Sajjadiiivtt 6
Updated 2023-01-25
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
›
⌄
WITH delegate_data AS (
SELECT
validator_address ,
CASE WHEN validator_address = 'terravaloper1l920a79akuc98hz4389axf9ctcymrf5ays578x' THEN 'WildSage 🧙 0% all 2023!'
WHEN validator_address = 'terravaloper12qvrr6j7u3z5el5uuwg99ftx3jru5py6027gfx' THEN 'Nodeasy'
WHEN validator_address = 'terravaloper120ppepaj2lh5vreadx42wnjjznh55vvktp78wk' THEN 'Allnodes.com ⚡️ Auto-compound (Ledger or Keplr)'
WHEN validator_address = 'terravaloper1k4ef8m95t7eq522evmmuzvfkpla04pezmu4j7k' THEN 'Bit Cat🐱'
WHEN validator_address = 'terravaloper18vnm040mwk0d6plc60v5m9h2376gkcphknuwzs' THEN 'PRISM Protocol'
WHEN validator_address = 'terravaloper1gfajnv0ud3r6kecvzzqm5acd2adntvgwmzzr72' THEN 'infstones'
WHEN validator_address = 'terravaloper1hy99h5xn44jtn76dla93wsps8h2eqsxqah4zhj' THEN 'HEX TRUST'
WHEN validator_address = 'terravaloper10ahmn0ucd9selcv77rwysx5pvd607z04zde7uh' THEN 'StakeLab'
WHEN validator_address = 'terravaloper13g7z3qq6f00qww3u4mpcs3xw5jhqwraswraapc' THEN 'Everstake'
WHEN validator_address = 'terravaloper1a9xxmdm7409sk0hjz4lzfjp52p4uft86lrqp4e' THEN 'Notional'
-- WHEN validator_address IN (
--'terravaloper1n8c73565zd4tme5hhasvtzz8ad4nwxyex0ge7e' , 'terravaloper1a9j2g4z7cs6ag9jpwtrz4vt70j7xqh7lsd8zkz' ,
--'terravaloper1tf2s579f4jpfxc3nm92wl5up2aykpd3zlh8frt' , 'terravaloper17vead9akhss6ammrjraqnfzaqm7w7y999xvlcd' ,
--'terravaloper1wk4mkavc3uk74paz69wjxn9n6ltgaellyve5tg' , 'terravaloper1gk0qflzlph04eav2k37v22z2luzy7tq3zqh4a2' ,
--'terravaloper1yjxvqnaycgf0re2jz7rdsqq85urma88daddp6d'
-- ) THEN 'No Data'
ELSE iff(validator_label IS NULL ,'No Data In Terrasco' ,validator_label) END AS lable ,
sum(amount) AS total_delegate_amount , COUNT(DISTINCT delegator_address) AS delegator_count
FROM
terra.core.ez_staking
WHERE
ACTION = 'Delegate'
AND tx_succeeded = TRUE
GROUP BY
1,2
),
undelegate_data AS (
SELECT
validator_address ,
CASE WHEN validator_address = 'terravaloper1l920a79akuc98hz4389axf9ctcymrf5ays578x' THEN 'WildSage 🧙 0% all 2023!'
WHEN validator_address = 'terravaloper12qvrr6j7u3z5el5uuwg99ftx3jru5py6027gfx' THEN 'Nodeasy'
WHEN validator_address = 'terravaloper120ppepaj2lh5vreadx42wnjjznh55vvktp78wk' THEN 'Allnodes.com ⚡️ Auto-compound (Ledger or Keplr)'
Run a query to Download Data