distinct b/s/ turnover

Alexaydistinct b/s/ turnover

Updated 2023-04-13

with mint as (select label, address from solana.core.dim_labels where label = 'degods')

select --date_trunc('day', block_timestamp) as date,

count(distinct purchaser) as total_buyers, count(distinct seller) as total_sellers, count(tx_id) as total_sales

from solana.core.fact_nft_sales a

inner join mint on a.mint = mint.address

where succeeded = 'True'

-- group by seller

--order by selling desc

Run a query to Download Data

flipside