Elprognerd AXL token staking
Updated 2023-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
SELECT
date_trunc('week', block_timestamp) as day,
action,
sum(
CASE
when action LIKE 'delegate' then amount / 1e6
end
) as "Deligation volume",
sum(
CASE
when action LIKE 'undelegate' then amount / 1e6
end
) as "Undeligation volume"
FROM
axelar.core.fact_staking
WHERE
action in ('delegate', 'undelegate')
AND currency LIKE 'uaxl'
and block_timestamp >= '2022-09-12'
GROUP BY
1,
2
order by
1
Run a query to Download Data