faralpaTop marketplaces Solana
    Updated 2023-04-13
    with nfts_market as (

    SELECT
    distinct marketplace,
    count(distinct tx_id) as tx_count,
    count(distinct purchaser) as buyers
    from
    solana.core.fact_nft_sales
    where
    date(block_timestamp) between current_date()-61 and current_date()-1
    group by marketplace
    order by buyers DESC
    limit 11
    )


    SELECT
    date(block_timestamp) as date,
    count(distinct tx_id) as tx_count,
    count(distinct purchaser) as buyers,
    marketplace
    from
    solana.core.fact_nft_sales
    where
    date(block_timestamp) between current_date()-61 and current_date()-1
    and marketplace in (select distinct marketplace from nfts_market)
    group by date,marketplace
    Run a query to Download Data