Our API supports filtering on all /results
endpoints to refine query results. You can apply filters on both rows and columns to narrow down the data returned by the API. This feature is available for the following endpoints:
Filtering can be effectively used in conjunction with pagination and sorting to further enhance query efficiency and relevance. See an example of filtering in action with this Dune farcaster frame.
filters
string
WHERE
clause. If omitted, all results are returned.<column_name> <operator> <value>
for criteria, for example, block_time >= '2024-03-05 15:03'
.AND
/ OR
, e.g., block_time >= '2024-03-05 15:03' AND (project = 'uniswap' OR project = 'balancer')
.IN
operator is permitted, as in tx_to IN (0x6a3e4b7e23661108aaec70266c468e6c679ae022, 0xdbf89389504e39f03fbb6bdd601aabb6bfbbed71)
.NOT
operator is not supported; using NOT IN
or NOT LIKE
will produce an error."special, column" = 'ABC'
.now() - interval '1' day
are not allowed.block_time > '2023-01-03'
.columns
string
project,block_time,amount_usd
instead of project, block_time, amount_usd
.Example filtered response
Our API supports filtering on all /results
endpoints to refine query results. You can apply filters on both rows and columns to narrow down the data returned by the API. This feature is available for the following endpoints:
Filtering can be effectively used in conjunction with pagination and sorting to further enhance query efficiency and relevance. See an example of filtering in action with this Dune farcaster frame.
filters
string
WHERE
clause. If omitted, all results are returned.<column_name> <operator> <value>
for criteria, for example, block_time >= '2024-03-05 15:03'
.AND
/ OR
, e.g., block_time >= '2024-03-05 15:03' AND (project = 'uniswap' OR project = 'balancer')
.IN
operator is permitted, as in tx_to IN (0x6a3e4b7e23661108aaec70266c468e6c679ae022, 0xdbf89389504e39f03fbb6bdd601aabb6bfbbed71)
.NOT
operator is not supported; using NOT IN
or NOT LIKE
will produce an error."special, column" = 'ABC'
.now() - interval '1' day
are not allowed.block_time > '2023-01-03'
.columns
string
project,block_time,amount_usd
instead of project, block_time, amount_usd
.Example filtered response