Recently I struggled to find the current-day volume on Hashflow dex (for some fishy stuff) and finally decided to write my first query on dune!

For some basic stuff like calculating the current-day volume it turned out to be that simple:

So first you need to select the engine and it depends on the chain you are writing your query for. Then try to search for the abstraction (tables) for the project you need:

Then you just follow the basic query pattern:

• select some specific column from the table

• from “table you are using”

• and then filter these values by writing “where this and that”

And finally, you can visualization (to add this query result to the dashboard lately or so):

Simple enough, right anon?

collect://

Recently I struggled to find the current-day volume on Hashflow dex (for some fishy stuff) and finally decided to write my first query on dune!

For some basic stuff like calculating the current-day volume it turned out to be that simple:

So first you need to select the engine and it depends on the chain you are writing your query for. Then try to search for the abstraction (tables) for the project you need:

Then you just follow the basic query pattern:

• select some specific column from the table

• from “table you are using”

• and then filter these values by writing “where this and that”

And finally, you can visualization (to add this query result to the dashboard lately or so):

Simple enough, right anon?

collect://