Skip to main content
  • 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 channels cast in during the last weekinteger
top_channelstop channels cast inarray(string)
top_domainstop domains castarray(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 engagementsinteger
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)