Yousefi_1994Eclipse Score: Third step -> 5 of the best validators based on the voting power and commission rate
Updated 2023-02-09
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 validator_details as (
select 'ISS' as "Validator Name", '🟢 Active' as "Status", 'terravaloper17q3y0exn6ndxkf78rcvj70gp7mrezmdx4z54xu' as "Operator Address", 'terra17q3y0exn6ndxkf78rcvj70gp7mrezmdx4dcgk0' as "Account Address", '1.05%' as "Voting Power", '1' as "Self-Delegation (Luna)", '5,594,673' as "Amount of Delegated (Luna)", '4%' as "Commission"
union all
select 'Humble Beginnings', '🟢 Active', 'terravaloper1rj6xj0lfrksr4uecp7n26l4rzmhqcqcaq3z656', 'terra1rj6xj0lfrksr4uecp7n26l4rzmhqcqcaq7w8yf', '0.39%', '2,000', '2,093,898', '0%'
union all
select 'RockawayX Infra', '🟢 Active', 'terravaloper1yw20fl3fg0hlsq4xkd8w9wfzddpqzuyd74j25r', 'terra1yw20fl3fg0hlsq4xkd8w9wfzddpqzuyd767hys', '0.49%','1', '2,611,182', '20%'
union all
select 'Electron Labs', '🔴 Jailed', 'terravaloper1yejn4qj9uy7xw9e2z5328uxxm5jzgu3etm9v4q', 'terra1yejn4qj9uy7xw9e2z5328uxxm5jzgu3et5f39n', '0.41%', '390', '2,181,598', '8%'
union all
select 'Orbital Command', '🟢 Active', 'terravaloper1lelhxdzwn9ddecv6sv0kcxj5tguurxnzcfs5wf', 'terra1lelhxdzwn9ddecv6sv0kcxj5tguurxnzcxuf76', '2.16%', '1', '12,714,849', '5%'
union all
select 'Supercharged delegation rewards', '🟡 Inactive', 'terravaloper15ky0w3rglcxgvpmkcvcdcd3ml4v7yuut5mk0q3', 'terra15ky0w3rglcxgvpmkcvcdcd3ml4v7yuut556jsz', '0%', '5', '0', '0%'
union all
select 'NodeZombie | 0% Commission and 1% MAX commission', '🟡 Inactive', 'terravaloper1rx8es8n64979ttp23w2hvssm5m0qfdp3a6ayj4', 'terra1rx8es8n64979ttp23w2hvssm5m0qfdp3a43ezx', '0%', '5', '0', '0%'
union all
select 'Notional', '🟡 Inactive', 'terravaloper1a9xxmdm7409sk0hjz4lzfjp52p4uft86lrqp4e', 'terra1a9xxmdm7409sk0hjz4lzfjp52p4uft86lvvu92', '0%', '5', '0', '0%'
union all
select 'USTC Buyback 🔥 | Terra-Aventura', '🔴 Jailed', 'terravaloper15gs5cy87n5jxddf4vq94efre9uwkrt9xaaw9z7', 'terra15gs5cy87n5jxddf4vq94efre9uwkrt9xajzcjd', '0%', '0', '0', '2%'
union all
select 'Zeus Staking', '🔴 Jailed', 'terravaloper1h0z9l64y6alk2kzk8c6z5hq2c40peuhvjg2g0k', 'terra1h0z9l64y6alk2kzk8c6z5hq2c40peuhvj8x4l9', '0%', '0', '0', '0%'
union all
select 'HappyLunatic', '🟢 Active', 'terravaloper1mh6zgqltndg3jq2unqh4nldgameavpm6pzdk8v', 'terra1mh6zgqltndg3jq2unqh4nldgameavpm6pdpthl', '0.52%', '5', '2,747,539', '5%'
union all
select 'Luna Rewards', '🟢 Active', 'terravaloper1hy8lzd38kp0t8662r2vnxsc4ezs3l74506jx02', 'terra1hy8lzd38kp0t8662r2vnxsc4ezs3l745047mle', '0.59%', '369', '3,112,562', '5%'
union all
select 'Vixello', '🟡 Inactive', 'terravaloper13qm5xdmvnexxjplw0dvmxcvqmxqscpavtpm2nn', 'terra13qm5xdmvnexxjplw0dvmxcvqmxqscpavtwhhrq', '0%', '2', '0', '1%'
union all
select 'Bobs-pc', '🟡 Inactive', 'terravaloper1288f4sy7a0vn07ntpdgh3xl3ae94wcntvptlk5', 'terra1288f4sy7a0vn07ntpdgh3xl3ae94wcntvw8zx8', '0%', '0', '0', '0%'
union all
select 'Goliath', '🟢 Active', 'terravaloper1chzrxuuajgp4huaanpwuz63xtc2wyq3mfzpk5f', 'terra1chzrxuuajgp4huaanpwuz63xtc2wyq3mfddty6', '0.61%', '1', '3,097,200', '9%'
union all
select 'Everstake', '🟡 Inactive', 'terravaloper13g7z3qq6f00qww3u4mpcs3xw5jhqwraswraapc', 'terra13g7z3qq6f00qww3u4mpcs3xw5jhqwraswv3q3t', '0%', '6', '0', '10%'
union all
select 'Waltsoft.money', '🟡 Inactive', 'terravaloper1a6n088fsjxp7e63zrh7dvllhelksu6g0wzqal5', 'terra1a6n088fsjxp7e63zrh7dvllhelksu6g0wdvq08', '0%', '4', '0', '5%'
union all
select 'Red Herring', '🔴 Jailed', 'terravaloper1qdspntsxzna8l8sp4ma8x0dyk0q7cgzvfj9vgc', 'terra1qdspntsxzna8l8sp4ma8x0dyk0q7cgzvfaf3ct', '0%', '2', '0', '0%'
Run a query to Download Data