count(distinct b.buyer) as buyers,

round(sum(b.price),2) as volume,

count(distinct b.tx_id) as trxs

from flow.core.dim_topshot_metadata a

inner join flow.core.fact_nft_sales b on a.nft_id = b.nft_id

where split_part(b.nft_collection, '.', 3) = 'TopShot'

and b.buyer in (select users

from (

select date_trunc('day', date) as days,

users

from (select min(block_timestamp) as date,

buyer as users

from flow.core.fact_nft_sales

where split_part(nft_collection, '.', 3) = 'TopShot'

group by users

)

having days >= current_date - 30

)

)

GROUP by 1

ORDER BY 1