feyikemiBenqi Total Stakers
Updated 2024-08-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
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Credit to Yasmin https://flipsidecrypto.xyz/yasmin/q/R2lWu8hkSCJ1/user-staker
WITH Total_Metrics AS (
SELECT
COUNT(DISTINCT decoded_log:user) AS Total_Stakers
FROM avalanche.core.ez_decoded_event_logs
WHERE
tx_status = 'SUCCESS'
AND event_name = 'Submitted'
AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
AND block_timestamp >= '2024-01-01'
),
August AS (
SELECT
COUNT(DISTINCT decoded_log:user) AS Total_Stakers_August
FROM avalanche.core.ez_decoded_event_logs
WHERE
tx_status = 'SUCCESS'
AND event_name = 'Submitted'
AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
AND block_timestamp::date BETWEEN '2024-08-01' AND '2024-08-31'
),
Past_24H AS (
SELECT
COUNT(DISTINCT decoded_log:user) AS Total_Stakers_Past_24H
FROM avalanche.core.ez_decoded_event_logs
WHERE
tx_status = 'SUCCESS'
AND event_name = 'Submitted'
AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
AND block_timestamp >= current_date - INTERVAL '1 day'
)
SELECT
QueryRunArchived: QueryRun has been archived