boomer77staking rewards
Updated 2021-07-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with stake as
(SELECT
date_trunc('month', block_timestamp) AS months,
SUM(event_amount_usd) AS amount_stake
FROM terra.staking
WHERE action = 'delegate'
GROUP BY 1),
reward as
(SELECT
date_trunc('month', block_timestamp) AS months1,
SUM(event_amount_usd) AS amount_reward
FROM terra.reward
WHERE action = 'withdraw_delegator_rewards'
GROUP BY 1)
SELECT A.months, A.amount_stake, B.amount_reward
from stake A
join reward B on A.months = B.months1
order by 1 desc
Run a query to Download Data