flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Untitled Query
ramishoow
Untitled Query
Updated 2022-12-15
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
sum
(
amount
)
as
"Most Volume"
,
count
(
distinct
tx_id
)
as
"Transaction"
,
DELEGATOR_ADDRESS
delegator
,
case
when
action
in
(
'Redelegate'
)
then
'Redelegate'
--select sum (amount) as "Most Volume", count (distinct tx_id) as "Transaction", DELEGATOR_ADDRESS delegator, case when action in ('Redelegate') then 'Redelegate'
end
as
TYPE
from
terra
.
core
.
ez_staking
where
tx_succeeded
=
'TRUE'
AND
action
IS
NOT
NULL
group
by
action
,
delegator
order
by
1
desc
limit
10
Results
Run a query to Download Data