Get Started

Dive into blockchain insights in just 5 minutes! This guide will equip you with the essentials to unlock the power of Flipside Studio. We'll go over how to:

Before we begin, make sure you have a Flipside account ready! If not, you can sign up for free here.


Explore the data

Steps:

  1. Click on the database icon to access data on 26+ protocols

  2. Quick introduction to how Flipside's data is organized:

Data exploration tips:
  • Column details: click on a table to see it's columns, and a data type for each.

  • Table details: hover over a to see the description and link to documentation.

  • Table preview: see sample data without writing any SQL by clicking the Preview icon.

  • Add to query: enter any table name into your SQL with a single mouse click.

  • View docs: hover over a database name and click the "book" icon to go direct to docs.


Query data on Flipside

Steps:

  1. Head to flipside.new or launch the Studio and click "+" to create a new query.

  2. Write some SQL! Unsure where to start? Explore our sample query below for inspiration.

  3. Hit "Run Query" (or CMD+ENTER on Mac / CTRL+ENTER on PC/Linux).

-- Top 8 NFT platforms on Ethereum by total sales in the past 30 days
select
  platform_name,
  count(*) as sales_count
from ethereum.nft.ez_nft_sales
where block_timestamp > current_date - interval '30 days'
group by platform_name
order by sales_count desc
limit 8

Create a Chart

Steps:

  1. Click "Add Chart" right below the query panel.

  2. Choose the chart type that best captures your data's essence. Bar, line, pie?

  3. Define the data points by setting your X and Y axes.


4. Build a Dashboard to share your insights

Steps:

  1. Add your chart to a new or existing dashboard.

  2. Title your dashboard

  3. Any finishing touches: adjust layout, add header, text boxes, images!

  4. Publish (don't worry you can always unpublish)

  5. Share by posting on Twitter/X or via URL.

Last updated