date_trunc('day', block_timestamp) as date,

platform_name,

count(distinct tx_hash) as no_of_txs,

count(distinct buyer_address) as no_of_buyers,

count(distinct seller_address) as no_of_sellers,

count(*) as no_of_sales,

sum(price) as volume,

sum(price_usd) as usd_volume

from ethereum.core.ez_nft_sales

where origin_to_address = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b'

group by 1,2

order by 1,2