Query editor
with Realms as(with transfers as((SELECT"to" as wallet,"tokenId" as token_id,'mint' as action,1 as valueFROM erc721."ERC721_evt_Transfer"where contract_address = '\x7afe30cb3e53dba6801aa0ea647a0ecea7cbe18d'and "from" = '\x0000000000000000000000000000000000000000')union all(SELECT"to" as wallet,"tokenId" as token_id,'gain' as action,1 as valueFROM erc721."ERC721_evt_Transfer"where contract_address = '\x7afe30cb3e53dba6801aa0ea647a0ecea7cbe18d'and "from" != '\x0000000000000000000000000000000000000000')union all(SELECT"from" as wallet,"tokenId" as token_id,'lose' as action,-1 as valueFROM erc721."ERC721_evt_Transfer"where contract_address = '\x7afe30cb3e53dba6801aa0ea647a0ecea7cbe18d'and "from" != '\x0000000000000000000000000000000000000000'))selectwallet,sum(value) as "Realms"fromtransfersgroup by walletorder by "Realms" desc),Loot as(with transfersYesterday as((SELECT"to" as wallet,"tokenId" as token_id,'mint' as action,1 as valueFROM erc721."ERC721_evt_Transfer"where contract_address = '\xff9c1b15b16263c61d017ee9f65c50e4ae0113d7'and "from" = '\x0000000000000000000000000000000000000000')union all(SELECT"to" as wallet,"tokenId" as token_id,'gain' as action,1 as valueFROM erc721."ERC721_evt_Transfer"