with nfts as (
SELECT * from solana.core.dim_labels
where ADDRESS_NAME = 'bubblegoose ballers'
)
select
date(block_timestamp) as date,
sum(SALES_AMOUNT) as sol_vol, sum(sol_vol) over (order by date) as vol_cumu,
COUNT(DISTINCT PURCHASER) as buyers, COUNT(DISTINCT seller) as sellers,
count(DISTINCT tx_id) as tx_count
from solana.fact_nft_sales
where mint in (select address from nfts)
and date >= '2022-06-13'
group by date