SocioCryptostaking
Updated 2023-01-23Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT date_trunc('day',block_timestamp) as date,
CASE WHEN date between '2023-01-07' AND '2023-01-13' THEN 'before'
WHEN date between '2023-01-15' AND '2023-01-21' THEN 'after'
ELSE 'announcement' END as periods,
sum(CASE WHEN action IN ('Delegate','Redelegate') then amount
ELSE -1*amount END) as net,
sum(net) over (ORDER by date) as cum_net
FROM terra.core.ez_staking
WHERE tx_succeeded = 'TRUE'
AND date between '2023-01-07' AND '2023-01-21'
GROUP BY date, periods
ORDER BY date DESC
Run a query to Download Data