zakkisyedWash Trading
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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