count(tx_hash) as total_sales_amount,

date_trunc(day,block_timestamp) as days

from optimism.core.ez_nft_sales

where days between '2022-07-1' and '2022-07-30'

group by days