Question:

Show interesting insights on Algo NFT using the new schema.

Requirements

• Must use the new Algorand schema and cannot use the old flipside_prod_db.algorand
• Must use at least one of the new Algorand NFT tables
• Not required but highly suggested: use a parameterized query. This can look like: collection name, wallet address(wallet address to evaluate a users collection), marketplace, last N number of days.

\n

Methodology:

In order to get the data, the new algorand tables were used. This would made to calculate over a period of time and then overall stats were also displayed for every marketplace and in general ALGO Stats

How to Use?

• The above parameter- date implies the last N days where N= 7 implies data for the last 7 days for the entire dashboard.
• The second one is marketplace. Rand Gallery is the default one. The others are:
  • ‘octorand’
  • ‘atomic swaps’
  • ‘algoxnft’
  • ‘ab2 gallery’
  • ‘shufl’
  • ‘fifa collect’
  • ‘rand gallery’
• To know about a wallet, add the address in the purchaser tab with a 'single quote’
• Lastly, after making the changes , hit apply parameters

Algo NFT stats in the past N days

Algo NFT Marketplace Based Stats

Stats by Wallet