SocioCryptostaking actions and actors
Updated 2023-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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,
ACTION,
count(DISTINCT delegator_address) as n_deleg,
count(DISTINCT validator_address) as n_valid,
sum(amount) as amnt,
count(DISTINCT tx_id) as n_action
FROM terra.core.ez_staking
WHERE tx_succeeded = 'TRUE'
AND date BETWEEN '2023-01-07' AND '2023-01-21'
GROUP BY date,action,periods
ORDER BY periods DESC