kaibladeMonthly Unique Users Per Marketplace Type
Updated 2022-10-01
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 nft_sales AS
(SELECT *
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp::date >= CURRENT_DATE() - INTERVAL '6 month'
),
nft_trx AS
(SELECT *
FROM ethereum.core.fact_transactions
WHERE to_address IN (SELECT DISTINCT(platform_address) FROM ethereum.core.ez_nft_sales)
AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '6 month'
),
combined AS
(SELECT trx.block_timestamp,
trx.tx_hash,
trx.from_address,
trx.status,
sales.platform_name
FROM nft_trx trx
JOIN nft_sales sales
ON trx.to_address = sales.platform_address
WHERE trx.status ='SUCCESS')
SELECT DATE_TRUNC('month', block_timestamp) AS "Months",
COUNT(DISTINCT from_address) AS users,
(CASE
WHEN platform_name IN ('x2y2', 'sudoswap') THEN 'Zero/Adjustable Royalty Fee'
ELSE 'Non-Zero Royalty Fee'
END) AS marketplace_type
FROM combined
GROUP BY "Months", marketplace_type
Run a query to Download Data