flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
LAVA STAKING REWARDS
0x_spade
LAVA STAKING REWARDS
Updated 2024-08-21
Copy Reference
Fork
9
1
2
3
4
›
⌄
SELECT
TO_CHAR
(
DATE_TRUNC
(
'month'
,
BLOCK_TIMESTAMP
)
,
'YYYY-MM'
)
AS
month
,
SUM
(
amount
)
AS
N_Rewards
,
FROM
lava
.
gov
.
fact_staking_rewards
GROUP
BY
month
ORDER
BY
month
ASC
Results
QueryRunArchived: QueryRun has been archived