select

block_timestamp,

tx_hash,

matic_value,

event_inputs:from as seller,

event_inputs:to as buyer,

event_inputs:tokenId as token_id,

contract_address as nft_collection

from polygon.core.fact_event_logs logs

join polygon.core.fact_transactions transactions using(tx_hash)

where event_inputs:tokenId is not null

and event_inputs:from != '0x0000000000000000000000000000000000000000'

and event_inputs:to !='0x0000000000000000000000000000000000000000'

and matic_value > 0

and tx_status = 'SUCCESS'

and event_name = 'Transfer'

and block_timestamp::date <= current_date - 1

select

nft_collection,

case

when nft_collection = '0x4d544035500d7ac1b42329c70eb58e77f8249f0f' then 'League of Kingdoms ITEM'

when nft_collection = '0xa5f1ea7df861952863df2e8d1312f7305dabf215' then 'ZED Horse'

when nft_collection = '0x41471dbdb78bbbe9ffde673055ba299bf414b366' then 'NFT SKY'

when nft_collection = '0x119fa524d7f5105f8941257d988e775c4d8dcb7b' then 'DragonAgeCollectibles'

when nft_collection = '0x8fbeee065d7f626f771a7dd2120cf831639e469f' then 'StackOS NFT 7'

when nft_collection = '0x35f8aee672cde8e5fd09c93d2bfe4ff5a9cf0756' then 'Rarible'

when nft_collection = '0x9754d2ad494482088bb2c5bf9043f57170f791f2' then 'Cosmo Hamsters'

when nft_collection = '0xc93c53de60d1a28df01e41f5bc04619039d2ef4f' then 'League of Kingdoms Skin'

when nft_collection = '0xde2a32e5363d01a89e3624442f8f5c43f38fc53a' then 'Polygon Warrior'

when nft_collection = '0x80a44a37b9198f5fa5c2f4ef2748cf109a288174' then 'StackOS NFT Genesis'

end as "NFT Collection Nname",

count(distinct tx_hash) as "Number of NFT Sales",

sum(matic_value) as "Volume of NFT Sales (MATIC)"