validator_address as "Validators",

sum(CASE WHEN action IN ('Delegate','Redelegate') then amount

ELSE -1*amount END) as "Net Staked Volume"

FROM terra.core.ez_staking a left JOIN terra.core.dim_address_labels b on a.validator_address = b.address

WHERE tx_succeeded = 'TRUE'

AND block_timestamp::date <= CURRENT_DATE-1

GROUP BY 1

order by 2 DESC

limit 10