with nft_sales as (
select
split(nft_collection,'.')[2] as name,
*
from flow.core.ez_nft_sales
where block_timestamp >= {{start_date}} and block_timestamp <= {{end_date}}
)
select
name,
count(distinct tx_id) as n_txns,
sum(price) as sale_volume,
count(distinct buyer) as n_wallets_daily
from nft_sales
group by name
order by n_txns desc
limit 10