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:

1. Explore Flipside's Data

2. Query data on Flipside

3. Create a chart

4. Build a dashboard to share your insights

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. Launch the Studio

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

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

   • Hierarchy: blockchain → schemas -> tables

   • Read more on our data modeling approach here.

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.