Farcaster Channels

Get trending farcaster channels that have had casts in the last 14 days

• 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

Column	Description	Type
channel_tier_name	name of channel tier this week	string
channel_tier	farcaster channel tier this week	integer
channel_tier_last	farcaster channel tier last week	integer
channel	farcaster channel name	string
channel_age	age of channel in days	integer
influential_casters	top casters by engagement in channel	array(string)
top_domains	top domains in casts in channel	array(string)
top_casters	top casters by number of casts in channel	array(string)
casters	number of casts in channels in the last week	integer
wow_cast	week over week change in number of casts	integer
got_casts	number of casts in channels in the last week	integer
wow_cast	week over week change in number of casts	integer
engagement	engagement on channel casts in the last week	integer
wow_engage	week over week change in number of engagement	integer
onchain_experts	number of casters in the last week who have transacted 100+ times ever	integer
trading_experts	number of casters in the last week who have traded $10k+ in DEX or NFT volume ever	integer
contract_experts	number of casters in the last week who have deployed 10+ contracts ever	integer
active_npc	npc tier users that have casted in the channel	integer
wow_npc	week over week change in number of npc tier casters	integer
active_user	active tier users that have casted in the channel	integer
wow_active_user	week over week change in number of active tier casters	integer
active_star	star tier users that have casted in the channel	integer
wow_star	week over week change in number of star tier casters	integer
active_influencer	influencer tier users that have casted in the channel	integer
wow_influencer	week over week change in number of influencer tier casters	integer
active_vip	vip tier users that have casted in the channel	integer
wow_vip	week over week change in number of vip tier casters	integer
got_replies	number of replies in the last week	integer
wow_reply	week over week change in number of replies	integer
got_likes	number of likes in the last week	integer
wow_likes	week over week change in number of likes	integer
got_recasts	number of recasts in the last week	integer
wow_recasts	week over week change in number of recasts	integer

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

cancelled_at

string

Timestamp of when the query execution was cancelled, if applicable.

execution_ended_at

string

Timestamp of when the query execution ended.

execution_id

string

Unique identifier for the execution of the query.

execution_started_at

string

Timestamp of when the query execution started.

expires_at

string

Timestamp of when the query result expires.

is_execution_finished

boolean

Whether the state of the query execution is terminal. This can be used for polling purposes.

next_offset

integer

Offset that can be used to retrieve the next page of results.

next_uri

string

URI that can be used to fetch the next page of results.

query_id

integer

Unique identifier of the query.

result

object

The object containing the results and metadata of the query execution

Show child attributes

result.metadata

object

Metadata about the execution of the query, including details like column names, row counts, and execution times.

Show child attributes

result.metadata.column_names

string[]

Names of the columns in the result set.

result.metadata.column_types

string[]

Types of the columns in the result set.

result.metadata.datapoint_count

integer

Results cell count is used for billing/pricing plans here we expose the these values to the user, so that they can track their costs

result.metadata.execution_time_millis

integer

Time in milliseconds that the query took to execute.

result.metadata.pending_time_millis

integer

Time in milliseconds that the query was pending before execution.

result.metadata.result_set_bytes

integer

ResultSetBytes represents the raw data bytes returned by the SQL execution engine, it includes:

• total nr of bytes used on 1 line with all the column names (the header of the result set)
• total nr of bytes for all the row values (the result set of rows)

it doesn't include overheads such as the presence of column names for every row in the JSON result type. it also doesn't include opmitizations such as compression

result.metadata.row_count

integer

Number of rows in the result set for the current page of results.

result.metadata.total_result_set_bytes

integer

Total number of bytes in the result set. This doesn't include the json representation overhead.

result.metadata.total_row_count

integer

Number of rows in the result set for the entire result set.

result.rows

object[]

A list of rows. A row is dictionary of key-value pairs returned by the query, each pair corresponding to a column

Show child attributes

result.rows.{key}

object

state

string

The state of the query execution.

submitted_at

string

Timestamp of when the query was submitted.