PS0G1Share of the staked/unstaked
Updated 2022-09-23
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
›
⌄
select 'Unstake' as type,
count (distinct tx_hash) as Unstake,
count (distinct Origin_to_Address) as Unstakers,
sum (amount) as Unstake_Volume,
sum (amount_usd) as Unstake_USD
from ethereum.core.ez_token_transfers
where BLOCK_TIMESTAMP >= '2022-07-01' and contract_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'
and from_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908' and origin_function_signature = '0x6ab15071' and SYMBOL = 'MATIC'
UNION
select 'Stake' as type,
count (distinct tx_hash) as Stake,
count (distinct Origin_From_Address) as Stakers,
sum (amount) as Stake_Volume,
sum (amount_usd) as Stake_USD
from ethereum.core.ez_token_transfers
where BLOCK_TIMESTAMP >= '2022-07-01' and contract_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'
and to_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908' and origin_function_signature = '0x6ab15071' and SYMBOL = 'MATIC'
Run a query to Download Data