You can simply put in any keywords, protocol names, contract names or anything else into the search bar at the top to filter the list of available datasets down to only those you might need at that moment.
The search bar also accepts spaces, that way you can construct a multi keyword search.
Let's explore a few examples of querying for tables to further elaborate on this:
Searching for uniswap_v2.will bring up all tables related to the uniswap_v2 schema
Searching for uniswap_v2. evt will bring up only event tables related to the uniswap_v2 schema
Searching for just uniswap will bring up all tables that contain the keyword uniswap in some form.
Always query for data schemas where applicable
Use spaces to filter down for events, calls or specific contracts after a schema.
The query window is where you can work your magic in Dune.
You can input any SQL code and execute it.
You can enable/disable the autocomplete function of the query editor using the gear wheel in the top right corner. The autocomplete feature will only bring up PGSQL keywords and already used tables and aliasses.
A few shortcuts to make working in the query editor easier are provided below.
ctrl + enter
execute the query
ctrl + #
comments out the selected code
ctrl + space
brings up a list of keywords
crtl + z
undoes your last changes
ctrl + y
redoes your last changes
ctrl + f
search for keywords
ctrl + h
search and replace keywords
The query results section contains a table with the results of your query.
You can change the formatting and appearance of your table with the options below the table. We don't currently support hiding individual columns for displaying this table on a dashboard, but we are looking to implement this function soon.
The tick formats follow this logic:
Display the full number and 7 decimals
Only Display whole numbers
Only displays whole numbers with comma separator
Displays the value with decimals points according to the count of zeroes after the dot
Displays the value in an abbreviated format.
Will display decimals of the abbreviated number according to count of zeroes after the dot.
Adheres to the same methods as before, but adds a $ prefix.