alirsop:eth-03-Before02
Updated 2022-11-26
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 projects
AS (
SELECT nft_address
,sum(price_usd) AS volume
FROM ethereum.core.ez_nft_sales
WHERE price_usd IS NOT NULL
AND block_timestamp::DATE >='2022-10-21' AND block_timestamp::DATE<='2022-11-25'
GROUP BY 1
ORDER BY 2 DESC limit 7
)
,final
AS (
SELECT seller_address
,Project_name
,count(DISTINCT (tx_hash)) AS Sales_Count
,count(DISTINCT (buyer_address)) AS Buyer_Count
,count(DISTINCT (seller_address)) AS Seller_Count
,sum(price_usd) AS total_volume
,avg(price_usd) AS avg_price
,count(DISTINCT (tokenid)) AS total_nfts
FROM ethereum.core.ez_nft_sales sale
INNER JOIN ethereum.core.dim_labels lab ON sale.nft_address = lab.address
WHERE nft_address IN (
SELECT nft_address
FROM projects
)
AND block_timestamp::DATE >='2022-10-21' AND block_timestamp::DATE<='2022-11-07'
GROUP BY 1
,2
)
SELECT project_name
,count(DISTINCT (seller_address)) AS Sellers
,CASE
WHEN total_volume > 0
AND total_volume <= 10
Run a query to Download Data