ramishoowUntitled Query
    Updated 2023-01-08
    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