-- This spring the Bored Ape Yacht Club Discord and Instagram accounts were hacked. The hackers sent a phishing link to the community. As a result of this phishing scam, users lost some Bored Apes, Mutant Apes, and other assets.
-- How many NFTs were stolen?
-- What is the total value of all NFTs stolen?
-- Show the percentage of compromised wallets that bought back more NFTs from the same collection that was stolen.
select
--trunc(block_timestamp,'day') as date,
platform_name,
project_name,
count(distinct tx_hash) as nfts_stolen_sold,
-- count(distinct buyer_address) as users_compromised,
sum(price_usd) as volume_stolen_sold_usd
from ethereum.core.ez_nft_sales
where seller_address='0x8c7934611b6ad70fbea13a1593de167a4689b9a9'
GROUP BY 1,2
order by 1 asc