mondovstakers categories
999
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 ggAVAX as (
SELECT
'ggAVAX' as token,
sum(decoded_log:assets/pow(10,18)) as amount_staked,
count(DISTINCT decoded_log:owner) as stakers
FROM avalanche.core.ez_decoded_event_logs e
WHERE contract_address = lower('0xA25EaF2906FA1a3a13EdAc9B9657108Af7B703e3')
AND event_name = 'Deposit'
),
-- forked from cloudr3n / GoGoPool - sAVAX Holders @ https://flipsidecrypto.xyz/cloudr3n/q/0y_ebWFVgx76/gogopool---savax-holders
filter as (
select tx_hash, decoded_log:shareAmount*pow(10,-18)*(-1) as amount,
decoded_log:user as user
FROM
avalanche.core.ez_decoded_event_logs
WHERE
contract_address='0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
and event_name in ('Redeem')
),
txto as (
SELECT
block_timestamp,
tx_hash,
decoded_log:value*pow(10,-18) as amount,
decoded_log:to as user
FROM
avalanche.core.ez_decoded_event_logs
WHERE
contract_address=lower('0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be')
and event_name='Transfer'
and decoded_log:to!='0x0000000000000000000000000000000000000000'
),
txfrom as (
Run a query to Download Data