Drsimon2023-03-06 03:27 AM
Updated 2023-03-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT DISTINCT project_name,NFT_ADDRESS, PLATFORM_NAME,
-- date_trunc('day', block_timestamp) as day,
count(DISTINCT tx_hash) as nft_sales ,
-- avg(PRICE_USD) as avg_price ,
sum(price_usd) as sum_price_usd
--- sum(price) as sum_price_eth
FROM ethereum.core.ez_nft_sales
WHERE
--project_name LIKE 'cryptopunks'AND
price_usd is not NULL
GROUP BY 1 ,2,3
ORDER BY 5 DESC
Run a query to Download Data