freemartianTop 5 Inventory Unstaking pools
Updated 2022-06-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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