zakkisyedActive NFT Traders
Updated 2023-04-06
99
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 sales_by_month AS (
SELECT
BUYER_ADDRESS,
DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,
COUNT(*) AS num_sales
FROM
ethereum.core.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= '2022-01-01'
GROUP BY
1,
2
),
months_active AS (
SELECT
BUYER_ADDRESS,
COUNT(DISTINCT month) AS num_months_active
FROM
sales_by_month
GROUP BY
1
),
active_traders AS (
SELECT
BUYER_ADDRESS
FROM
months_active
WHERE
num_months_active >= 12
)
SELECT
COUNT(DISTINCT ez_nft_sales.BUYER_ADDRESS) AS active_traders,
DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,
Run a query to Download Data