GET

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>'

{
  "cancelled_at": "2024-12-20T11:04:18.724658237Z",
  "execution_ended_at": "2024-12-20T11:04:18.724658237Z",
  "execution_id": "01HKZJ2683PHF9Q9PHHQ8FW4Q1",
  "execution_started_at": "2024-12-20T11:04:18.724658237Z",
  "expires_at": "2024-12-20T11:04:18.724658237Z",
  "is_execution_finished": true,
  "next_offset": 100,
  "next_uri": "https://api.dune.com/api/v1/execution/01HKZJ2683PHF9Q9PHHQ8FW4Q1/results?offset=100&limit=100",
  "query_id": 1234,
  "result": {
    "metadata": {
      "column_names": [
        "Rank",
        "Project",
        "Volume"
      ],
      "column_types": [
        "double",
        "varchar",
        "bigint"
      ],
      "datapoint_count": 1000,
      "execution_time_millis": 1000,
      "pending_time_millis": 1000,
      "result_set_bytes": 1000,
      "row_count": 10,
      "total_result_set_bytes": 10000,
      "total_row_count": 1000
    },
    "rows": [
      {}
    ]
  },
  "state": "QUERY_STATE_COMPLETED",
  "submitted_at": "2024-12-20T11:04:18.724658237Z"
}

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.

Column	Description	Type
word_raw	Ticker symbol of the token	string
related_symbol	any symbol or word that is related to the token (i.e. the degen hat or higher arrow)	string
token_contract_address	Contract address of the token	string
blockchain	Blockchain on which the token is deployed	string
deployed_days_ago	Number of days since the token was deployed	integer
social_score	Social score of the token	integer
financial_score	Financial score of the token	integer
meme_category	category of meme based off of social and financial score values	string
casters	Number of users who have casted the token ticker	integer
casters_wow	Change in the number of casters week over week	integer
percent_recipient_casters	Percentage of casters this week that have received the token before	integer
percent_recipient_wow	Change in the percentage of recipient casters week over week	integer
recipient_casters	Number of casters this week that have received the token before	integer
recipient_casters_wow	Change in the number of recipient casters week over week	integer
casts	Number of times the token ticker has been casted	integer
casts_wow	Change in the number of casts week over week	integer
channels	Number of channels the token ticker has been casted in	integer
channels_wow	Change in the number of channels week over week	integer
activity_level	Activity level of the token	integer
activity_wow	Change in the activity level week over week	integer
total_supply	Total supply of the token	integer
fdv	Fully diluted valuation of the token	integer
median_price	Median price of the token	integer
day_pnl	Profit and loss of the token price in the last 24 hours	integer
week_pnl	Profit and loss of the token price in the last 7 days	integer
month_pnl	Profit and loss of the token price in the last 30 days	integer
liquidity_usd	Liquidity of the token in USD	integer
liquidity_wow	Change in liquidity week over week	integer
rolling_one_months_trades	Number of trades in the last month	integer
transfers_one_month	Number of token transfers in the last month	integer
total_volume_week	Total trading volume of the token in the last 7 days	integer
total_volume_wow	Change in total trading volume week over week	integer
buy_volume_week	Total buying volume of the token in the last 7 days	integer
buy_volume_wow	Change in total buying volume week over week	integer
sell_volume_week	Total selling volume of the token in the last 7 days	integer
sell_volume_wow	Change in total selling volume week over week	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

The response is of type object.

Farcaster Channels Farcaster Users

curl --request GET \
  --url https://api.dune.com/api/v1/farcaster/trends/memecoins \
  --header 'X-Dune-Api-Key: <x-dune-api-key>'

{
  "cancelled_at": "2024-12-20T11:04:18.724658237Z",
  "execution_ended_at": "2024-12-20T11:04:18.724658237Z",
  "execution_id": "01HKZJ2683PHF9Q9PHHQ8FW4Q1",
  "execution_started_at": "2024-12-20T11:04:18.724658237Z",
  "expires_at": "2024-12-20T11:04:18.724658237Z",
  "is_execution_finished": true,
  "next_offset": 100,
  "next_uri": "https://api.dune.com/api/v1/execution/01HKZJ2683PHF9Q9PHHQ8FW4Q1/results?offset=100&limit=100",
  "query_id": 1234,
  "result": {
    "metadata": {
      "column_names": [
        "Rank",
        "Project",
        "Volume"
      ],
      "column_types": [
        "double",
        "varchar",
        "bigint"
      ],
      "datapoint_count": 1000,
      "execution_time_millis": 1000,
      "pending_time_millis": 1000,
      "result_set_bytes": 1000,
      "row_count": 10,
      "total_result_set_bytes": 10000,
      "total_row_count": 1000
    },
    "rows": [
      {}
    ]
  },
  "state": "QUERY_STATE_COMPLETED",
  "submitted_at": "2024-12-20T11:04:18.724658237Z"
}

Custom Endpoints

SQL Endpoints

Data Management Endpoints

Preset Endpoints

Farcaster Memecoins

Use Cases

Column Descriptions

Headers

Query Parameters

Response

Custom Endpoints

SQL Endpoints

Data Management Endpoints

Preset Endpoints

​Use Cases

​Column Descriptions

Headers

Query Parameters

Response

Use Cases

Column Descriptions