misaghlbSolana NFT Project Feature - bubblegoose ballers - sales
    Updated 2023-03-27
    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
    Run a query to Download Data