freemartianVaults & Unstaker Count
Updated 2022-06-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with vaults as (
select event_inputs:from as vault_address, event_inputs:to as unstaker, event_inputs:value/pow(10,18) as nft_amount
from ethereum_core.fact_event_logs
where origin_to_address = '0x3e135c3e981fae3383a5ae0d323860a34cfab893'
and origin_from_address = event_inputs:to
)
select vault_address, count(distinct unstaker) as unique_unstakers, sum(nft_amount) as nft
from vaults
where vault_address != '0x0000000000000000000000000000000000000000'
group by vault_address
order by nft desc
Run a query to Download Data