GET
/
v1
/
farcaster
/
trends
/
users
curl --request GET \
  --url https://api.dune.com/api/v1/farcaster/trends/users \
  --header 'X-Dune-Api-Key: <x-dune-api-key>'
{
  "cancelled_at": "2024-12-20T11:04:18.724658237Z",
  "execution_ended_at": "2024-12-20T11:04:18.724658237Z",
  "execution_id": "01HKZJ2683PHF9Q9PHHQ8FW4Q1",
  "execution_started_at": "2024-12-20T11:04:18.724658237Z",
  "expires_at": "2024-12-20T11:04:18.724658237Z",
  "is_execution_finished": true,
  "next_offset": 100,
  "next_uri": "https://api.dune.com/api/v1/execution/01HKZJ2683PHF9Q9PHHQ8FW4Q1/results?offset=100&limit=100",
  "query_id": 1234,
  "result": {
    "metadata": {
      "column_names": [
        "Rank",
        "Project",
        "Volume"
      ],
      "column_types": [
        "double",
        "varchar",
        "bigint"
      ],
      "datapoint_count": 1000,
      "execution_time_millis": 1000,
      "pending_time_millis": 1000,
      "result_set_bytes": 1000,
      "row_count": 10,
      "total_result_set_bytes": 10000,
      "total_row_count": 1000
    },
    "rows": [
      {}
    ]
  },
  "state": "QUERY_STATE_COMPLETED",
  "submitted_at": "2024-12-20T11:04:18.724658237Z"
}
  • Query can be found here
  • Scheduled to update every 30 minutes
  • You can apply filters like WHERE, IN, AND/OR upon results
  • Learn about user tiers in this article

​
Use Cases

  • Recommend trending users based on engagement, domains, or onchain activity
  • Curate feeds that segment users by type (developer, artist, memecoin trader, etc.)
  • Filter out likely bot users (high number of casts, low engagement, low onchain activity)

​
Column Descriptions

ColumnDescriptionType
fid_active_tier_namename of farcaster tier this weekstring
fid_active_tierfarcaster user tier this weekinteger
fid_active_tier_lastfarcaster user tier last weekinteger
fidfarcaster user idinteger
fnamefarcaster username of userstring
account_ageage of account in daysinteger
channelsnumber of casted in channels in the last weekinteger
top_channelstop casted in channelsarray(string)
top_domainstop casted domainsarray(string)
top_engagerstop cast engagersarray(string)
followerstotal number of followersinteger
wow_followersweek over week change in number of followersinteger
castsnumber of casts in the last weekinteger
wow_castsweek over week change in number of castsinteger
engagementengagement on user casts in the last weekinteger
wow_engageweek over week change in number of engageinteger
total_transactionstotal number of wallet transactionsinteger
trading_volume_usdtotal NFT and DEX trading volume (USD)integer
contracts_deployedtotal number of deployed contractsinteger
got_likesnumber of likes in the last weekinteger
wow_likesweek over week change in number of likesinteger
got_recastsnumber of recasts in the last weekinteger
wow_recastsweek over week change in number of recastsinteger
got_repliesnumber of replies in the last weekinteger
wow_repliesweek over week change in number of repliesinteger
addressesuser verified addressesarray(string)

Headers

​
X-Dune-Api-Key
string
required

API Key for the service

Query Parameters

​
api_key
string

API Key, alternative to using the HTTP header X-Dune-Api-Key

​
allow_partial_results
boolean

This enables returning a query result that was too large and only a partial result is available. By default allow_partial_results is set to false and a failed state is returned.

​
columns
string

Specifies a comma-separated list of column names to return. If omitted, all columns are included. Tip: use this to limit the result to specific columns, reducing datapoints cost of the call.

​
filters
string

Expression to filter out rows from the results to return. This expression is similar to a SQL WHERE clause. More details about it in the Filtering section of the doc. This parameter is incompatible with sample_count.

​
ignore_max_datapoints_per_request
boolean

There is a default 250,000 datapoints limit to make sure you don't accidentally spend all your credits in one call. To ignore the max limit, you can add ignore_max_datapoints_per_request=true

​
limit
integer

Limit number of rows to return. This together with 'offset' allows easy pagination through results in an incremental and efficient way. This parameter is incompatible with sampling (sample_count).

​
offset
integer

Offset row number to start (inclusive, first row means offset=0) returning results from. This together with 'limit' allows easy pagination through results in an incremental and efficient way. This parameter is incompatible with sampling (sample_count).

​
queryID
integer
required
​
sample_count
integer

Number of rows to return from the result by sampling the data. This is useful when you want to get a uniform sample instead of the entire result. If the result has less than the sample count, the entire result is returned. Note that this will return a randomized sample, so not every call will return the same result. This parameter is incompatible with offset, limit, and filters parameters.

​
sort_by
string

Expression to define the order in which the results should be returned. This expression is similar to a SQL ORDER BY clause. More details about it in the Sorting section of the doc.

Response

200
application/json

OK

The response is of type object.