Write/fork your first query
Gather the data you need using SQL
From your Studio, you have access to the data on all 26+ protocols supported on Flipside using SQL.
To get started, open a new query in your Studio (an easy way to do this is to visit the url https://flipside.new).
Preview tables
To understand exactly what data is included in a table before you query it, click "Preview":
![](https://docs.flipsidecrypto.xyz/~gitbook/image?url=https%3A%2F%2F3303628914-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-LdEnDLYh6Su5z7LbnEZ%252Fuploads%252F8QiYRX0m68xmQMlwyjC1%252FUntitled%2520design-12.png%3Falt%3Dmedia%26token%3D0d191dc1-7814-4335-b9ae-6c04207ed4fd&width=768&dpr=4&quality=100&sign=1e37992f&sv=1)
This will populate a sample of the table for you instantly in your Studio.
![](https://docs.flipsidecrypto.xyz/~gitbook/image?url=https%3A%2F%2F3303628914-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-LdEnDLYh6Su5z7LbnEZ%252Fuploads%252FdhjXVx7f2Wu3USJmZPrG%252FScreenshot%25202023-12-06%2520at%25208.48.15%2520AM.png%3Falt%3Dmedia%26token%3D6bec45d5-2e66-44ac-963a-bff3c2c250e4&width=768&dpr=4&quality=100&sign=8e6bee3e&sv=1)
Add to query
To auto-populate the name of the table in your query, you can use the double-arrow "Add to query" button:
![](https://docs.flipsidecrypto.xyz/~gitbook/image?url=https%3A%2F%2F3303628914-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-LdEnDLYh6Su5z7LbnEZ%252Fuploads%252FKOMtIsUxrwtgwYIpXcks%252FUntitled%2520design-13.png%3Falt%3Dmedia%26token%3D830a3f10-ff3b-45f8-bf91-e65cc777bd89&width=768&dpr=4&quality=100&sign=177ca44b&sv=1)
Now you understand how to navigate the database and find the tables that contain the data you need, so you're ready to start writing your own SQL queries and generating onchain insights.
But what if you're still not sure what to query?
Fork a query
Analysts have produced hundreds or thousands of community dashboards on every supported protocol, so you've got plenty to take inspiration from!
You can fork a query from any public dashboard you like. Here's how:
Find a dashboard
From the Discover page, choose any dashboard you find interesting.
![](https://docs.flipsidecrypto.xyz/~gitbook/image?url=https%3A%2F%2F3303628914-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-LdEnDLYh6Su5z7LbnEZ%252Fuploads%252FK9s1Y2Ar5PJ1Ro8dmX3R%252FScreenshot%25202023-12-06%2520at%25208.56.50%2520AM.png%3Falt%3Dmedia%26token%3D92fcab33-dcb5-4755-ab69-5d4a18c77425&width=768&dpr=4&quality=100&sign=b3c93a37&sv=1)
Click a chart title
Choose a visualization you'd like to replicate, and click its title. For example, let's click on "SOL volume in period":
![](https://docs.flipsidecrypto.xyz/~gitbook/image?url=https%3A%2F%2F3303628914-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-LdEnDLYh6Su5z7LbnEZ%252Fuploads%252FZcVMfSQ63TJNDuCEyFMv%252FUntitled%2520design-14.png%3Falt%3Dmedia%26token%3D30b62720-f22d-4306-96f0-90270c0544d9&width=768&dpr=4&quality=100&sign=5373990f&sv=1)
Fork the query
Clicking a chart title in a public dashboard will show you the query and resulting table the author used to create it. That can often give you the ideas you need for your own query.
But if you want to use or edit the same query, you can just click "Fork" in the top right corner, which will auto-populate the same query and visualization settings in your studio:
![](https://docs.flipsidecrypto.xyz/~gitbook/image?url=https%3A%2F%2F3303628914-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-LdEnDLYh6Su5z7LbnEZ%252Fuploads%252FCfo4SeNnaXfIfPDdmkn8%252FUntitled%2520design-15.png%3Falt%3Dmedia%26token%3D556c68b1-6618-4301-9704-cfca37649126&width=768&dpr=4&quality=100&sign=30c33d51&sv=1)
Last updated