0xHaM-dUntitled Query
Updated 2023-04-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
'Blur' as marketplace,
ROUND(COUNT(DISTINCT TX_HASH)/COUNT(DISTINCT BUYER_ADDRESS),0) AS volume,
ROUND(SUM(PRICE)/COUNT(DISTINCT BUYER_ADDRESS),0) AS amount
FROM ethereum.core.ez_nft_sales
WHERE PLATFORM_NAME = 'blur'
UNION ALL
SELECT
'Hyperspace' as marketplace,
ROUND(COUNT(DISTINCT TX_id)/COUNT(DISTINCT PURCHASER),0) AS volume,
ROUND(SUM(SALES_AMOUNT)/COUNT(DISTINCT PURCHASER),0) AS amount
FROM solana.core.fact_nft_sales
WHERE marketplace = 'hyperspace'
Run a query to Download Data