GET
/
v1
/
farcaster
/
trends
/
memecoins
curl --request GET \
  --url https://api.dune.com/api/v1/farcaster/trends/memecoins \
  --header 'X-DUNE-API-KEY: <x-dune-api-key>'
{
  "execution_id": "01HWBTTTV89PHNTNW7BS9TBZ27",
  "query_id": 3662242,
  "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": [
      {
        "word_raw": "DEGEN",
        "related_symbol": "🎩",
        "activity_level": 24807277.002432942,
        "activity_wow": -22679691.683773145,
        "blockchain": "base",
        "buy_volume_week": 69449195.66125394,
        "buy_volume_wow": -19452047.862753436,
        "memecoin_category": "established",
        "casters": 10374,
        "casters_wow": -2641,
        "casts": 138232,
        "casts_wow": -83908,
        "channels": 476,
        "channels_wow": -182,
        "day_pnl": -0.09455416194472792,
        "deployed_days_ago": 109,
        "fdv": 983543127.8897532,
        "financial_score": 627.74,
        "liquidity_usd": 9726985.075777544,
        "liquidity_wow": -237483.66550707817,
        "median_price": 0.02661,
        "month_pnl": 0.7140550503404604,
        "percent_recipient_casters": 0.9253903990746096,
        "percent_recipient_wow": 0.022585942678143955,
        "recipient_casters": 9600,
        "recipient_casters_wow": -2150,
        "rolling_one_months_trades": 848654,
        "sell_volume_week": 68724401.02564587,
        "sell_volume_wow": -20176842.498361513,
        "social_score": 491.56,
        "token_contract_address": "0x4ed4e862860bed51a9570b96d89af5e1b0efefed",
        "total_supply": 36965730333,
        "total_volume_week": 138173596.6868998,
        "total_volume_wow": -39628890.36111495,
        "transfers_one_month": 3583424,
        "week_pnl": -0.18248784976233895
      }
    ]
  },
  "metadata": {
    "column_names": [
      "word_raw",
      "related_symbol",
      "token_contract_address",
      "blockchain",
      "deployed_days_ago",
      "social_score",
      "financial_score",
      "memecoin_category",
      "casters",
      "casters_wow",
      "percent_recipient_casters",
      "percent_recipient_wow",
      "recipient_casters",
      "recipient_casters_wow",
      "casts",
      "casts_wow",
      "channels",
      "channels_wow",
      "activity_level",
      "activity_wow",
      "total_supply",
      "fdv",
      "median_price",
      "day_pnl",
      "week_pnl",
      "month_pnl",
      "liquidity_usd",
      "liquidity_wow",
      "rolling_one_months_trades",
      "transfers_one_month",
      "total_volume_week",
      "total_volume_wow",
      "buy_volume_week",
      "buy_volume_wow",
      "sell_volume_week",
      "sell_volume_wow"
    ],
    "row_count": 1,
    "result_set_bytes": 1029,
    "total_row_count": 51,
    "total_result_set_bytes": 19912,
    "datapoint_count": 34,
    "pending_time_millis": 1445,
    "execution_time_millis": 417705
  },
  "next_uri": "https://api.dune.com/api/v1/execution/01HWBTTTV89PHNTNW7BS9TBZ27/results?limit=1&offset=1&sort_by=casters+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 memecoins and categories in this article

​
Use Cases

  • Recommend trending memecoins based on farcaster engagement, liquidity, volume, or other onchain activity

​
Column Descriptions

Learn more about the score and methodology in this article.

ColumnDescriptionType
word_rawTicker symbol of the tokenstring
related_symbolany symbol or word that is related to the token (i.e. the degen hat or higher arrow)string
token_contract_addressContract address of the tokenstring
blockchainBlockchain on which the token is deployedstring
deployed_days_agoNumber of days since the token was deployedinteger
social_scoreSocial score of the tokeninteger
financial_scoreFinancial score of the tokeninteger
meme_categorycategory of meme based off of social and financial score valuesstring
castersNumber of users who have casted the token tickerinteger
casters_wowChange in the number of casters week over weekinteger
percent_recipient_castersPercentage of casters this week that have received the token beforeinteger
percent_recipient_wowChange in the percentage of recipient casters week over weekinteger
recipient_castersNumber of casters this week that have received the token beforeinteger
recipient_casters_wowChange in the number of recipient casters week over weekinteger
castsNumber of times the token ticker has been castedinteger
casts_wowChange in the number of casts week over weekinteger
channelsNumber of channels the token ticker has been casted ininteger
channels_wowChange in the number of channels week over weekinteger
activity_levelActivity level of the tokeninteger
activity_wowChange in the activity level week over weekinteger
total_supplyTotal supply of the tokeninteger
fdvFully diluted valuation of the tokeninteger
median_priceMedian price of the tokeninteger
day_pnlProfit and loss of the token price in the last 24 hoursinteger
week_pnlProfit and loss of the token price in the last 7 daysinteger
month_pnlProfit and loss of the token price in the last 30 daysinteger
liquidity_usdLiquidity of the token in USDinteger
liquidity_wowChange in liquidity week over weekinteger
rolling_one_months_tradesNumber of trades in the last monthinteger
transfers_one_monthNumber of token transfers in the last monthinteger
total_volume_weekTotal trading volume of the token in the last 7 daysinteger
total_volume_wowChange in total trading volume week over weekinteger
buy_volume_weekTotal buying volume of the token in the last 7 daysinteger
buy_volume_wowChange in total buying volume week over weekinteger
sell_volume_weekTotal selling volume of the token in the last 7 daysinteger
sell_volume_wowChange in total selling volume week over weekinteger

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?

Farcaster ChannelsFarcaster Users