yasminDistribution by Number of Transactions
Updated 2024-06-09
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
user_transactions AS (
SELECT
seller_address AS user,
COUNT(DISTINCT tx_hash) AS Sale
FROM
near.nft.ez_nft_sales
WHERE
block_timestamp::date >= '{{Start_Date}}'
AND block_timestamp::date <= '{{End_Date}}'
AND NFT_ADDRESS = '{{project_name}}'
GROUP BY
seller_address
UNION ALL
SELECT
buyer_address AS user,
COUNT(DISTINCT tx_hash) AS Sale
FROM
near.nft.ez_nft_sales
WHERE
block_timestamp::date >= '{{Start_Date}}'
AND block_timestamp::date <= '{{End_Date}}'
AND NFT_ADDRESS = '{{project_name}}'
GROUP BY
buyer_address
)
SELECT
CASE
WHEN Sale = 1 THEN '1 trade'
WHEN Sale BETWEEN 2 AND 5 THEN '2-5 trades'
WHEN Sale BETWEEN 6 AND 10 THEN '6-10 trades'
WHEN Sale BETWEEN 11 AND 20 THEN '11-20 trades'
WHEN Sale BETWEEN 21 AND 50 THEN '21-50 trades'
WHEN Sale > 50 THEN '50+ trades'
END AS user_type,
COUNT(DISTINCT user) AS user_count
QueryRunArchived: QueryRun has been archived