cloudr3nsavax and avax supply
Updated 2023-08-06
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
sum(avax_amount*multiplier)*pow(10,-18) as total_avax,
sum(savax_amount*multiplier)*pow(10,-18) as total_savax
--,event_name
from
(SELECT
case when event_name='Redeem' then -1 else 1 end as multiplier,
case when event_name in ('Submitted','Redeem') then decoded_log:avaxAmount
when event_name='AccrueRewards' then decoded_log:value
else 0 end as avax_amount,
case when event_name in ('Submitted','Redeem') then decoded_log:shareAmount
else 0 end as savax_amount,
event_name
FROM
avalanche.core.ez_decoded_event_logs
WHERE
contract_address='0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
and event_name in ('Submitted','AccrueRewards', 'Redeem')
)
--group by event_name
/*
Submitted: avaxAmount, shareAmount
Redeem: avaxAmount, shareAmount, unlockRequestedAt
AccrueRewards: value
*/
Run a query to Download Data