ramishoowUntitled Query
Updated 2023-01-08
9
1
2
3
4
›
⌄
select seller_address as "Sellers", count (distinct tx_hash) as "sales", count (distinct tokenid) as "tokens", sum (price) as "eth sale", sum (price_usd) as "usd sale" from ethereum.core.ez_nft_sales
where project_name = 'cryptopunks' and event_type = 'sale' and buyer_address != '0x0000000000000000000000000000000000000000' and tx_hash not in ('0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0')
--where project_name = 'cryptopunks' and event_type = 'sale' and buyer_address != '0x0000000000000000000000000000000000000000' and tx_hash not in ('0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0')
AND PRICE_USD is NOT NULL group by 1 order by 2 DESC limit 10
Run a query to Download Data