freemartianTop 5 Inventory Unstaking pools
    Updated 2022-06-14
    with vaults as (
    select contract_address as vault_address, event_inputs:from as unstaker, event_inputs:value/pow(10,18) as nft_amount
    from ethereum_core.fact_event_logs
    where origin_to_address = '0x3e135c3e981fae3383a5ae0d323860a34cfab893'
    and event_inputs:to = '0x0000000000000000000000000000000000000000'
    and block_timestamp > CURRENT_DATE - 60
    )
    select vault_address, sum(nft_amount) as nft, count(distinct unstaker) as unique_unstakers,
    case when vault_address = '0x5d1c5dee420004767d3e2fb7aa7c75aa92c33117' then 'xMILADY'
    when vault_address = '0xe61186dea096349eb5652d45c16079d56d2c2b22' then 'xMANA'
    when vault_address = '0x3e7d590b398a8bd7a12fb6071af197bf74248895' then 'xTUBBY'
    when vault_address = '0xbf9b32dae8c5267c9295e875f8943b1224d12975' then 'xFWY'
    when vault_address = '0x29b145edfa80b20a3f6f79b57ef4b1ca33ad2777' then 'xFROYO'
    end as pool_name
    from vaults
    group by vault_address, pool_name
    order by nft desc
    Limit 5


    Run a query to Download Data