with secondary_sales as (
select date_trunc(day,block_timestamp) as dt,
count(*) as sale_count,
sum(price) as eth_volume,
sum(price_usd) as usd_volume,
platform_name
from ethereum.core.ez_nft_sales
where nft_address = lower('{{contract}}') -- SHARI
and origin_from_address != '0x0000000000000000000000000000000000000000'
--and status = 'SUCCESS'
group by 1,5
order by 1 asc
)
select * from secondary_sales