ramishoowUntitled Query
Updated 2022-12-15
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
Run a query to Download Data