greyswancollections
    Updated 2023-11-22
    select
    date_trunc('week', block_timestamp) as week,
    label as collection,
    count (distinct purchaser),
    count (distinct seller),
    count (TX_ID) as sales,
    sum (SALES_AMOUNT) as volume
    from
    solana.nft.fact_nft_sales
    left join solana.core.dim_labels on mint = address
    where
    succeeded = true
    and block_timestamp > current_date - 60
    group by
    label,
    date_trunc('week', block_timestamp)
    order by
    date_trunc('week', block_timestamp) desc,
    count (distinct purchaser) desc,
    count (distinct seller) desc
    Run a query to Download Data