SELECT * from solana.core.dim_labels

where ADDRESS_NAME ilike 'DeGods'

SELECT

date(BLOCK_TIMESTAMP) as date,

COUNT(DISTINCT PURCHASER) as buyers,

sum(buyers) over (order by date) as cum_buyers,

COUNT(DISTINCT SELLER) as sellers,

sum(sellers) over (order by date) as cum_sellers,

sum(SALES_AMOUNT) as vol,

sum(vol) over (order by date) as cum_vol,

COUNT(DISTINCT tx_id) as sales_count

from solana.core.fact_nft_sales

where MINT in (SELECT address from nfts)

GROUP by 1