mlhUntitled Query
Updated 2022-11-23Copy Reference Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT date_trunc('month', block_timestamp) as month,
PLATFORM_NAME,
count(DISTINCT tx_hash) as sales,
COUNT(DISTINCT BUYER_ADDRESS) as buyers,
sum(PRICE_USD) as sales_volume,
(sum(PRICE_USD))/(COUNT(DISTINCT BUYER_ADDRESS)) as avg_usd_per_buyer
FROM ethereum.core.ez_nft_sales
WHERE nft_address LIKE lower('0x629A673A8242c2AC4B7B8C5D8735fbeac21A6205')
GROUP BY 1,2
Run a query to Download Data