freemartianVaults & Unstaker Count
    Updated 2022-06-13
    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