OneDataAnalystTotal Stats
Updated 2022-10-30Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH t1 AS (
SELECT BLOCK_TIMESTAMP, MARKETPLACE, PURCHASER, SELLER, MINT, SALES_AMOUNT
FROM solana.core.fact_nft_sales
WHERE SUCCEEDED = 'TRUE'
AND MARKETPLACE IN ('hyperspace', 'coral cube')
)
SELECT
MARKETPLACE,
SUM(SALES_AMOUNT) AS Sales_vol,
COUNT(*) AS Sales,
COUNT(DISTINCT PURCHASER) AS buyers,
COUNT(DISTINCT SELLER) AS Sellers,
SUM(SALES_AMOUNT)/COUNT(DISTINCT BLOCK_TIMESTAMP::DATE) AS Sale_vol_per_day,
COUNT(*)/COUNT(DISTINCT BLOCK_TIMESTAMP::DATE) AS Sales_per_day,
SUM(SALES_AMOUNT)/COUNT(*) AS Sale_vol_per_sale,
COUNT(*)/COUNT(DISTINCT PURCHASER) AS Purchase_per_buyer,
COUNT(DISTINCT BLOCK_TIMESTAMP::DATE) AS age
FROM t1
GROUP BY 1
ORDER BY 1
Run a query to Download Data