select date_trunc('day', block_timestamp) as block_date,
platform_name,
count(DISTINCT tx_hash) as transaction_counts,
sum(price_usd) as transaction_volumes
from ethereum.core.ez_nft_sales
where block_timestamp >= '2022-10-19'
group by 1, 2
order by 1