zakkisyedUntitled Query
Updated 2021-10-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
SUM(event_amount_usd) AS Total_USD,
SUM(event_amount) AS Total_LUNA,
DATE_TRUNC('week', block_timestamp) AS Week,
action
FROM terra.staking
WHERE validator_address = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6'
--AND Action != 'undelegate'
AND Week >= '2021-05-30'
GROUP BY WEEK, action
ORDER BY WEEK ASC
Run a query to Download Data