# πcNFT ecosystem on Solana

This guide will assist you in creating a dashboard on the Top Ledger platform, which displays a variety of key metrics for the cNFT secondary ecosystem on Solana.

Letβs calculate some important metrics for the compressed NFT secondary ecosystem and add them in a dashboard.

## Trade Volume

We will start by calculating the daily cNFT trade volume. The chart below shows the daily trade volume for the cNFT ecosystem.

Additionally, the charts displayed below illustrate the total number of cNFTs traded within the ecosystem, as well as the daily trend in cNFT trading.

Next, we'll review the SQL code behind the charts you've observed. This query operates on the cnft_trades table, which is accessible on the Top Ledger platform.

To begin with, since the cnft_trades table records the amount of SOL (in lamports) used for each cNFT purchase, our first step is to calculate the total SOL amount on a daily basis. Following this, the second part of the query involves converting the SOL volume into USD volume. This is done using our price table (tl_solana.prices), allowing us to determine the daily USD trade volume.

Subsequently, we can aggregate this data over the entire period to ascertain the cumulative trade volume in both SOL and USD. In a similar manner, we can track the daily trend in the number of trades and the total number of trades that have occurred to date.

To calculate the number of cNFT trades, we simply count the unique tx_id entries in the cnft_trades table. This count can then be cumulatively aggregated over time to yield the total number of trades.

## Royalties

Now, let's determine the total royalties paid to creators from cNFT trades within the ecosystem. This can be done in the same query used for trade volume calculation, but instead, we'll focus on a different column, specifically 'royalty'.

We will then present this data using charts as shown below:

In this process, we initially aggregate the royalty data on a daily basis, then convert the SOL volume into USD. Following this, we aggregate these daily amounts over the entire period to determine the cumulative royalty in both USD and SOL for the creators.

Last updated