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>'
{
  "execution_id": "01HVKQK08KDVDKHYDKKKHTJWMC",
  "query_id": 3633434,
  "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": [
      {
        "active_influencer": 41,
        "active_npc": 9922,
        "active_star": 4749,
        "active_user": 6555,
        "active_vip": 11,
        "channel": "zora",
        "channel_age": 225,
        "channel_tier": 4,
        "channel_tier_last": 4,
        "channel_tier_name": "stadium",
        "engagement": 986141.8744016357,
        "casters": 27055,
        "wow_casters": 3058,
        "onchain_experts": 13562,
        "trading_experts": 5664,
        "contract_experts": 5015,
        "got_casts": 70056,
        "got_likes": 1897359,
        "got_recasts": 610489,
        "got_replies": 684280,
        "influential_casters": [
          "mikedemarais.eth",
          "six",
          "flexasaurusrex"
        ],
        "top_casters": [
          "ameenullah",
          "yoonje",
          "samuray07",
          "omid77",
          "ako1988",
          "hank68",
          "ayla1638",
          "maryamtab",
          "ilannnnnnnnkatin",
          "woww"
        ],
        "top_domains": [
          "zora.co",
          "farcaster.manifold.xyz",
          "frames.poster.fun"
        ],
        "wow_active_user": 101,
        "wow_cast": 8356,
        "wow_engage": 175460.7229972462,
        "wow_influencer": -6,
        "wow_likes": 420394,
        "wow_npc": -3690,
        "wow_recasts": 180216,
        "wow_reply": 25247,
        "wow_star": 82,
        "wow_vip": -2
      }
    ]
  },
  "metadata": {
    "column_names": [
      "channel_tier_name",
      "channel_tier",
      "channel_tier_last",
      "channel",
      "channel_age",
      "influential_casters",
      "casters",
      "wow_casters",
      "onchain_experts",
      "trading_experts",
      "contract_experts",
      "got_casts",
      "wow_cast",
      "engagement",
      "wow_engage",
      "active_npc",
      "wow_npc",
      "active_user",
      "wow_active_user",
      "active_star",
      "wow_star",
      "active_influencer",
      "wow_influencer",
      "active_vip",
      "wow_vip",
      "got_replies",
      "wow_reply",
      "got_likes",
      "wow_likes",
      "got_recasts",
      "wow_recasts",
      "top_domains",
      "top_casters"
    ],
    "row_count": 1,
    "result_set_bytes": 763,
    "total_row_count": 7940,
    "total_result_set_bytes": 1278003,
    "datapoint_count": 28,
    "pending_time_millis": 1110,
    "execution_time_millis": 26170
  },
  "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 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 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

Was this page helpful?

Dune Farcaster EndpointsFarcaster Memecoins