with raw as (with k as (select mint -- count(distinct CONTRACT_ADDRESS)
from solana.core.dim_nft_metadata
where project_name ='Aurory')
select block_timestamp, purchaser, k.mint from solana.core.fact_nft_sales m inner join k on m.mint=k.mint)
select date_trunc('month',block_timestamp) as date, count(distinct mint ) as volume
from raw
group by 1 order by 1
limit 100