zakkisyedWash Trading
    WITH
    transfer_counts AS (
    SELECT
    DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week,
    NFT_ADDRESS,
    NFT_FROM_ADDRESS AS seller_address,
    NFT_TO_ADDRESS AS buyer_address,
    SUM(
    CASE
    WHEN ERC1155_VALUE IS NULL THEN 1
    ELSE 0
    END
    ) AS nft_count
    FROM
    ethereum.core.ez_nft_transfers
    WHERE
    BLOCK_TIMESTAMP >= '2022-01-01'
    AND ERC1155_VALUE IS NULL
    GROUP BY
    1,
    2,
    3,
    4
    ),
    filter1 AS (
    SELECT
    week,
    NFT_ADDRESS,
    seller_address,
    buyer_address,
    SUM(nft_count) AS nft_count
    FROM
    transfer_counts
    WHERE
    seller_address <> buyer_address
    GROUP BY
    Run a query to Download Data