Skip to content
On this page


Using GeniiData, you can query blockchain data using SQL, and the results can be used to create amazing data visualizations using our charts and graphs.

  • Recent: Displays recently-viewed Worksheets list
  • My Worksheets: Displays all created folders and Worksheets
  • Folders: Displays the folder list. Click on 'Folders' to view the embedded Worksheets.
  • Click Search to search for Worksheets, Folders, and Dashboard.
  • Click the search result to enter the corresponding operation page.


Add folder

  • Click on +Folder, enter the Folder name, and Click Create Folder.

Modify and Delete Folders

  • Click the folder name. Users can modify or delete the folder name in the displayed drop-down list.
  • A double-check is performed when deleting to confirm the action.
  • If Delete is selected, the folder is deleted.
  • If Cancel is selected, the folder is not deleted, and the pop-up is closed.

Add Worksheets

  • Click on +Worksheets to enter the worksheet operation interface.
  • Worksheets will be split up into four parts

Worksheets and Datasets

  • Worksheets
  • Datasets
  • Decoded Projects: Supporting contract data from opensea, x2y2, etc
  • Common Data: Supporting ETL related to the NFT marketplace, such as trades & price
  • My Dataset: All the tables submitted by the user can be viewed in the My Dataset
  • Double-click the table name or field name to send the corresponding information to the SQL input box

SQL Input Box

  • Support Spark SQL
  • Support SQL layout in one click (Format)
  • Support light/dark mode

Result & Chart


  • Click run ( or ctrl+enter ) to view the execution progress
  • The data will be displayed in the resulting command if the query succeeds.
  • Data Results can be downloaded in CSV format.
  • The results can be added to the Dashboard.

Configuration items:

  • Displays the execution time for SQL
  • Time of the last execution
  • Adjustable table Title, field name, decimal place, thousandth place, etc


  • Support charts such as Bar, Horizontal Bar, Area, Scatter, Line, Pie and Counter

Example: Bar Chart

  • Click on Chart Type to quickly switch the chart type (Bar, Area, Scatter, Line)
  • The chart can be quickly added to the Dashboard.
  • Data
    • Support adjusting chart names
    • X-axis and Y-axis are mandatory, and multiple columns can be added to the Y-axis (click on +Add column)
    • Group by (optional)
  • Appearance
    • X-axis or Y-axis names can be added.
    • The X-axis is in reverse order. By default, the data is in positive order.
    • Enabling Right Y-axis
      • Double Y-axis
      • Line and column mix data
  • Advanced features
    • Support changing indicator names and graphs
    • Supports alignment adjustment (left alignment by default). If you select the right alignment, the right Y-axis will be enabled first.
    • Support changing the indicator color
  • Chart options
    • Show Legend is opened by default.
    • Enable stacking, Normalize to percentage, and Show data labels are closed by default
  • Delete Chart
    • Users can delete charts at the end of the configuration items.
      • Double confirmation is required when deleting the chart
    • Note: If the chart is referenced by the Dashboard, it cannot be deleted. It can be deleted only after Chart is unbound from the Dashboard.
      • following the path by clicking"Worksheets"->"Chart" -> "Add to dashboards"

Worksheets Name Drop-down List

  • Support adjusting the name of the worksheet
  • Quickly moving worksheets into folders.
  • Support replicating the current worksheets
  • Support deleting worksheets. Double confirmation is required when deleting.
  • Displaying
    • Command/Ctrl + Ente — Run query
    • ⌘ + shift + O / ctrl + alt + O — Format query