-- Punk Vault (NFTX) Token address: '0x269616d549d7e8eaa82dfb17028d0b212d11232a' symbol = 'nftx_token'
select PLATFORM_NAME,
CASE
when NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' then 'NEW_Version'
when NFT_ADDRESS = '0x6ba6f2207e343923ba692e5cae646fb0f566db8d' then 'OLD_Version'
end as Type,
sum(TX_FEE_USD) as PLATFORM_Gained
from ethereum.core.ez_nft_sales
where
PROJECT_NAME = 'cryptopunks'
and EVENT_TYPE = 'sale' and Price_usd is not null
group by 1,2