📈Beta tester FAQ
Onboarding toolkit for testing Openmesh Analytics Platform
Openmesh Query Analytics Walkthrough
What is the URL to the Query platform?
What kind of queries can users write?
SQL queries that generate datasets then those datasets can be used as the data for the charts or visualizations to create dashboards for chart grouping and presentations
What kind of visualizations can be made through queries?
Pie charts, line charts, standard volume charts
Can you customize the charts?
Yes, charts are customizable and interactive and can be sorted by specific features
What does the IDE show?
It will give you a breakdown of our databases, schemas, and tables. As of now, our database is Postgres with one schema and many tables (one ticker/parent table and several daily partition tables)
How many rows can be scanned at once?
10,000 rows, however, you can add aggregates to have access to more data at once.
How can aggregates be added?
Manually through averages, sums, etc. in SQL or through the Superset tool.
Is my data private?
Yes, you have the option of staying anonymous or will be able to connect your MetaMask wallet in the future to save your visualizations to your account in the future.
How do I save my data?
You can save your data as an image, create a permalink to share or collaborate with friends or embed the link to an email.
When I share the chart can my friends or colleagues access the original query?
Yes, they can see the original query that generated the chart and the new code of the chart or visualization that our platform generated.
Do I have to pay or is there a free trial?
Everything is completely free! You don’t have to worry about providing any credit card or personal information. You can utilize this tool as much as you’d like without ever needing to pay.
Where is Openmesh data stored? Where do queries pull data from?
We index our data and store it in both Amazon S3 and a Postgres database.
How are my queries answered?
We have connected the Amazon S3 and Postgres databases to a front-end business intelligence tool that allows for queries to be run against the engine.
What tool do we use to allow for complex queries?
We’re using Apache Superset — an open-source data exploration tool designed for high volumes.
What are some example queries the tool can answer?
The query tool should be able to answer the following queries or similar queries:
What was the average close price every hour on Binance BTC.USDT for the past month?
How many trades happened on each exchange for ETH pairs?
How did the bid price/volume change on Coinbase over the last week?
What was the RSI for ADA.USDT on Bybit in November 2022?
Do I need to be familiar with SQL to use the query tool?
No, those familiar with SQL, can jump straight into the SQL lab and start writing (SELECT statements only, of course). Meanwhile, those unfamiliar can still use the tables as datasets for creating original visualizations that let you filter out and aggregate time-series data without needing to write a single line of code
I don’t know where to start. What should I do first?
You can watch the YouTube walkthrough to help you get started
Who can I contact for Support?
We've set up a Slack channel for our testers and we will be adding you there, together with our devs.
How can I provide feedback after using the Beta?
You can provide feedback via this form, we are so very thankful for your notes! Be as critical as you’d like.
What kind of Feedback should I provide?
Any and all feedback is appreciated. We love knowing if there were any issues with UI or UX design, computation errors, website glitches, problems with retrieving data from queries, typos, and more. You are the first group to test out our product!
What will you do with the feedback we provide?
We will use your feedback for debugging, improvements, and changes to our backend for a better user experience.
What can I expect next from Openmesh?
We are currently seeking members to join our internal team of developers. We will be considering beta testers, hackathon attendees, and other developers as candidates for roles opening next quarter.
How can I stay up to date with new versions of the Query Tool and upcoming events?
Last updated