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')
    AND PRICE_USD is NOT NULL group by 1 order by 5 DESC limit 10
    --and buyer_address != '0x0000000000000000000000000000000000000000' and tx_hash not in ('0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0')

    Run a query to Download Data