Flipside Docs

Solana Tables

[Legacy Documentation, Not Maintained, For Reference Only]

Background of Solana

Blockchain: Solana
Solana is a public base-layer blockchain protocol that optimizes for scalability. The goal of the Solana blockchain is to provide a platform that enables developers to create decentralized applications (dApps) without needed to design around performance bottlenecks. Solana features a new timestamp system called Proof of History (PoH) that enables automatically ordered transactions. It also uses Proof of Stake (PoS) consensus algorithm to help secure the network.
The public Github repo with Solana model source code is here.

Current Solana Tables

The current Solana table schemas build concepts laid out in Flipside's event data model. Solana tables are available in Velocity as the solana schema. The tables are built based on the Solana events and transactions information. The following Solana tables are available:

What we have:

  • All native on-chain Solana events dating back to November 28, 2021.
  • Labels for certain common Solana wallet addresses and programs.
  • NFT metadata for top Solana NFT projects.

What we don't have:

  • Off-chain events such as DEX order book transactions and bids on secondary NFT marketplaces.
  • Data before Nov. 28th, 2021. We are in the process of backfilling the Solana tables, earlier data will be made available shortly.
  • Votes anywhere besides the solana.votes_block_agg table and Pyth Oracle transactions.

Solana Labels

Solana labels are available and located in the table solana.labels. To include Solana labels in your analysis, perform a join on address or program ID. Please note that all address labels stored in the solana.labels table are in lower case and that Solana addresses are case sensitive. To join the tables, use the SQL function COLLATE to create a case insensitive JOIN statement.

Solana NFT Tables And Metadata

We have three Solana NFT tables: solana.nfts (mints, sales, etc), solana.nft_metadata (token names, images, attributes, etc), and solana.airdrops (NFT and token airdrops).
The goal of these tables is to create a unified table of on-chain Solana NFT data that makes it easy to compare across and within NFTs. To do this, we have curated metadata from top Solana NFT projects. The metadata is nowhere near comprehensive, we add projects one or two at a time. That being said, we want these tables to be interesting to our community and would love feedback and recommendations for projects to add.

How to Contribute to Our Data

Are there labels or NFT metadata that you would like to see added to our data? Let us know the following information in Discord or via email ([email protected]):
Good: Send us the name of the token/label and the contract address.
Better: Send us the name of the token/label, the contract address, and the project website.
Best: Send us the name, contract address, project website, and example transactions (links to solscan.io). For an NFT, we would appreciate examples of the following transaction types:
  • minting
  • list
  • unlist
  • bid
  • sale
  • any other special thing you can "do" with this NFT (ex: staking)