select date(block_timestamp), platform_name, count(distinct tx_hash) sales_ct, avg(price_usd) avg_price
from ethereum.core.ez_nft_sales
where block_timestamp >= CURRENT_DATE - 40
--and tx_hash = '0xd2a561a16ef4460ea0d82a763f3d1cb57d1228640e9052bfe80869952023c6a0'
and nft_address = '0x903e2f5d42ee23156d548dd46bb84b7873789e44'
group by 1,2
order by 1,2 asc