Drsimonterraforms2- 1w
Updated 2023-03-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
DISTINCT ez_nft_sales.PLATFORM_NAME AS platform_name,
-- ez_nft_sales.PLATFORM_ADDRESS AS platform_address,
COUNT(DISTINCT CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.BUYER_ADDRESS ELSE NULL END) AS buyers_count,
COUNT(DISTINCT CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.SELLER_ADDRESS ELSE NULL END) * -1 AS sellers_count,
COUNT(DISTINCT CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.TX_HASH ELSE NULL END) AS nft_sales_count,
AVG(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.PRICE_USD ELSE NULL END) AS avg_price_usd,
SUM(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.PRICE_USD ELSE NULL END) AS total_sales_usd,
SUM(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.PRICE ELSE NULL END) AS total_sales_eth,
SUM(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.TOTAL_FEES ELSE NULL END) AS total_fees_eth,
SUM(CASE WHEN ez_nft_sales.EVENT_TYPE IN ('bid_won', 'sale', 'redeem') THEN ez_nft_sales.TOTAL_FEES_USD ELSE NULL END) AS total_fees_usd,
DATE_TRUNC('WEEK', ez_nft_sales.BLOCK_TIMESTAMP) AS date
FROM ethereum.core.ez_nft_sales
WHERE ez_nft_sales.PROJECT_NAME LIKE 'terraforms'
AND ez_nft_sales.BLOCK_TIMESTAMP > '2020-01-01'
GROUP BY ez_nft_sales.PLATFORM_NAME,date ORDER BY date DESC
Run a query to Download Data