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>'
{
  "execution_id": "01HVKQK08KDVDKHYDKKKHTJWMC",
  "query_id": 3633428,
  "is_execution_finished": true,
  "state": "QUERY_STATE_COMPLETED",
  "submitted_at": "2024-04-16T15:14:43.606076Z",
  "expires_at": "2024-07-15T15:15:31.475503Z",
  "execution_started_at": "2024-04-16T15:15:11.247805Z",
  "execution_ended_at": "2024-04-16T15:15:31.4755Z",
  "result": {
    "rows": [
      {
        "account_age": 224,
        "addresses": [
          "0x6b0bda3f2ffed5efc83fa8c024acff1dd45793f1",
          "0xb877f7bb52d28f06e60f557c00a56225124b357f",
          "0xa14b4c95b5247199d74c5578531b4887ca5e4909",
          "0xd7029bdea1c17493893aafe29aad69ef892b8ff2",
          "0xd7029bdea1c17493893aafe29aad69ef892b8ff2",
          "0xd7029bdea1c17493893aafe29aad69ef892b8ff2",
          "0x8fc5d6afe572fefc4ec153587b63ce543f6fa2ea"
        ],
        "casts": 161,
        "channels": 42,
        "contracts_deployed": 204,
        "engagement": 71062.86674253445,
        "fid": 3,
        "fid_active_tier": 4,
        "fid_active_tier_last": 4,
        "fid_active_tier_name": "vip",
        "fname": "dwr.eth",
        "followers": 252265,
        "got_likes": 27842,
        "got_recasts": 3342,
        "got_replies": 6003,
        "top_channels": [
          "farcaster",
          "warpcast",
          "product"
        ],
        "top_domains": [
          "docs.farcaster.xyz",
          "warpcast.notion.site"
        ],
        "top_engagers": [
          "warpcastbot",
          "iturner.eth",
          "kidmmo"
        ],
        "total_transactions": 1185,
        "trading_volume_usd": 790785.0209452906,
        "wow_casts": -114,
        "wow_engage": 28414.895986926094,
        "wow_followers": 13987,
        "wow_likes": 4132,
        "wow_recasts": 3342,
        "wow_replies": 2057
      }
    ]
  },
  "metadata": {
    "column_names": [
      "fid_active_tier_name",
      "fid_active_tier",
      "fid_active_tier_last",
      "fid",
      "fname",
      "account_age",
      "channels",
      "top_channels",
      "top_domains",
      "top_engagers",
      "followers",
      "wow_followers",
      "casts",
      "wow_casts",
      "engagement",
      "wow_engage",
      "total_transactions",
      "trading_volume_usd",
      "contracts_deployed",
      "got_likes",
      "wow_likes",
      "got_recasts",
      "wow_recasts",
      "got_replies",
      "wow_replies",
      "addresses"
    ],
    "row_count": 1,
    "result_set_bytes": 1584,
    "total_row_count": 112663,
    "total_result_set_bytes": 55714212,
    "datapoint_count": 30,
    "pending_time_millis": 800,
    "execution_time_millis": 23701
  },
  "next_uri": "https://api.dune.com/api/v1/execution/01HVKQK08KDVDKHYDKKKHTJWMC/results?filters=&limit=10&offset=10&sort_by=followers+desc",
  "next_offset": 10
}
  • 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 for the service, alternative to using the HTTP header X-DUNE-API-KEY.

limit
integer
required

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).

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.

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
execution_id
string

Unique identifier for the execution

query_id
integer

Unique identifier for the query

is_execution_finished
boolean

Flag to indicate if the execution is finished

state
string

State of the query execution

submitted_at
string

Time when the query was submitted

expires_at
string

Time when the query will expire

execution_started_at
string

Time when the execution started

execution_ended_at
string

Time when the execution ended

result
object

results from query

metadata
object

Metadata for the query

next_uri
string

URI to get the next set of results

next_offset
integer

Offset to get the next set of results