alitaslimiStaking Overview
Updated 2024-04-01
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
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
staking AS (
SELECT
COUNT(DISTINCT tx_hash) AS txn,
COUNT(DISTINCT decoded_log:user) AS users,
SUM(decoded_log:avaxAmount) / POW(10, 18) AS volume
FROM
avalanche.core.ez_decoded_event_logs
WHERE
tx_status = 'SUCCESS'
AND event_removed = FALSE
AND event_name = 'Submitted'
AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
),
unstaking AS (
SELECT
COUNT(DISTINCT tx_hash) AS txn,
COUNT(DISTINCT decoded_log:user) AS users,
SUM(decoded_log:amount) / POW(10, 18) AS volume
FROM
avalanche.core.ez_decoded_event_logs
WHERE
tx_status = 'SUCCESS'
AND event_removed = FALSE
AND event_name = 'Withdraw'
AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
)
SELECT
staking.txn AS "Staking Transactions",
unstaking.txn AS "Unstaking Transactions",
staking.users AS "Stakers",
unstaking.users AS "Unstakers",
staking.volume AS "Staked Volume",
unstaking.volume AS "Unstaked Volume",
"Staked Volume" - "Unstaked Volume" AS "Net Volume"
FROM
QueryRunArchived: QueryRun has been archived