nitsDaily Staking
Updated 2022-12-01
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT date(block_timestamp) as day, count(DISTINCT tx_id) as total_txs,
count(DISTINCT delegator_address) as total_delegations,
sum(amt_staked) as net_staked,
sum(net_staked) over (order by day) as cum_staked
from
(SELECT *, case when action = 'Undelegate' then amount*(-1) else amount end as amt_staked
from terra.core.ez_staking
where tx_succeeded = TRUE and block_timestamp >= CURRENT_DATE - {{N}})
GROUP by 1
-- LIMIT 100
Run a query to Download Data