keshanUniswap phishing NFT steals
    Updated 2022-07-29
    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