GET
/
v1
/
farcaster
/
trends
/
channels
curl --request GET \
  --url https://api.dune.com/api/v1/farcaster/trends/channels \
  --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 channel tiers in this article

​
Use Cases

  • Recommend trending channels based on engagement, casters, and/or domains
  • Curate feeds that segment channels by type (small and growing, large and established, influencer led)
  • Filter out likely bot channels (low engagement, no influencers or vips, no “onchain_experts”)

​
Column Descriptions

ColumnDescriptionType
channel_tier_namename of channel tier this weekstring
channel_tierfarcaster channel tier this weekinteger
channel_tier_lastfarcaster channel tier last weekinteger
channelfarcaster channel namestring
channel_ageage of channel in daysinteger
influential_casterstop casters by engagement in channelarray(string)
top_domainstop domains in casts in channelarray(string)
top_casterstop casters by number of casts in channelarray(string)
castersnumber of casts in channels in the last weekinteger
wow_castweek over week change in number of castsinteger
got_castsnumber of casts in channels in the last weekinteger
wow_castweek over week change in number of castsinteger
engagementengagement on channel casts in the last weekinteger
wow_engageweek over week change in number of engagementinteger
onchain_expertsnumber of casters in the last week who have transacted 100+ times everinteger
trading_expertsnumber of casters in the last week who have traded $10k+ in DEX or NFT volume everinteger
contract_expertsnumber of casters in the last week who have deployed 10+ contracts everinteger
active_npcnpc tier users that have casted in the channelinteger
wow_npcweek over week change in number of npc tier castersinteger
active_useractive tier users that have casted in the channelinteger
wow_active_userweek over week change in number of active tier castersinteger
active_starstar tier users that have casted in the channelinteger
wow_starweek over week change in number of star tier castersinteger
active_influencerinfluencer tier users that have casted in the channelinteger
wow_influencerweek over week change in number of influencer tier castersinteger
active_vipvip tier users that have casted in the channelinteger
wow_vipweek over week change in number of vip tier castersinteger
got_repliesnumber of replies in the last weekinteger
wow_replyweek over week change in number of repliesinteger
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

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.