boomer77Total Rewards Withdrew
Updated 2021-12-24
9
1
2
3
4
5
6
7
8
›
⌄
with raw as (select date_trunc('day', block_timestamp) as dt, currency, sum(event_amount_usd) as rewards_usd, SUM(rewards_usd) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_rewards
from terra.reward
where validator = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66' and tx_status = 'SUCCEEDED' and currency is not null
group by 1,2)
select sum(rewards_usd)
from raw
Run a query to Download Data