SELECT project_name, contract_address, count(tx_id) as Volume, date_trunc('day', block_timestamp) as days, sum(price_usd) as sales_USD
FROM
ethereum.nft_events
where
days = CURRENT_DATE
and event_type = 'sale'
group by 1,2,4
having sales_usd > 0
order by sales_USD DESC
LIMIT 20