flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Top 10 validator by volume of redelegate
Abolfazl_771025
Top 10 validator by volume of redelegate
Updated 2023-02-10
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
b
.
label
AS
validator
,
sum
(
AMOUNT
*
power
(
10
,
-
DECIMAL
)
)
AS
volume
from
osmosis
.
core
.
fact_staking
A
LEFT
OUTER
JOIN
osmosis
.
core
.
dim_labels
B
ON
A
.
VALIDATOR_ADDRESS
=
B
.
ADDRESS
WHERE
ACTION
=
'redelegate'
GROUP
BY
1
ORDER
BY
2
DESC
LIMIT
10
Results
Run a query to Download Data