Farcaster Users
Get trending farcaster users who have casted in the last 14 days
- Query can be found here
- Scheduled to update every 6 hours
- 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
Column | Description | Type |
---|---|---|
fid_active_tier_name | name of farcaster tier this week | string |
fid_active_tier | farcaster user tier this week | integer |
fid_active_tier_last | farcaster user tier last week | integer |
fid | farcaster user id | integer |
fname | farcaster username of user | string |
account_age | age of account in days | integer |
channels | number of casted in channels in the last week | integer |
top_channels | top casted in channels | array(string) |
top_domains | top casted domains | array(string) |
top_engagers | top cast engagers | array(string) |
followers | total number of followers | integer |
wow_followers | week over week change in number of followers | integer |
casts | number of casts in the last week | integer |
wow_casts | week over week change in number of casts | integer |
engagement | engagement on user casts in the last week | integer |
wow_engage | week over week change in number of engage | integer |
total_transactions | total number of wallet transactions | integer |
trading_volume_usd | total NFT and DEX trading volume (USD) | integer |
contracts_deployed | total number of deployed contracts | 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 |
got_replies | number of replies in the last week | integer |
wow_replies | week over week change in number of replies | integer |
addresses | user verified addresses | array(string) |
Headers
API Key for the service
Query Parameters
API Key for the service, alternative to using the HTTP header X-DUNE-API-KEY.
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 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).
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
.
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
Unique identifier for the execution
Unique identifier for the query
Flag to indicate if the execution is finished
State of the query execution
Time when the query was submitted
Time when the query will expire
Time when the execution started
Time when the execution ended
results from query
Metadata for the query
URI to get the next set of results
Offset to get the next set of results
Was this page helpful?