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 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 casters in channels in the last weekinteger
wow_castersweek over week change in number of castersinteger
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