keshanUniswap phishing NFT steals
Updated 2022-07-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT date_trunc(HOUR, t.block_timestamp) AS TIME,
count(t.nft_from_address) AS "Number of steals",
count(DISTINCT t.nft_from_address) AS "Number of unique victims",
t.project_name,
sum(MINT_PRICE_USD) AS mint_usd,
sum(MINT_PRICE_ETH) AS mint_eth
FROM ethereum.core.ez_nft_transfers t
LEFT JOIN ethereum.core.ez_nft_mints m ON m.nft_address=t.nft_address
AND m.tokenid=t.tokenid
WHERE t.nft_to_address in ('0xa9bba21e5b16f9b135eb185a4f8d2618edad8db1',
'0x09b5027ef3a3b7332ee90321e558bad9c4447afa',
'0x3cafc86a98b77eedcd3db0ee0ae562d7fe1897a2',
'0x24a4b33bfa8e32b3456f95381de429c11c2c6fd6')
GROUP BY TIME,
t.project_name
Run a query to Download Data