Farcaster Memecoins
Get trending farcaster memecoins that have been casted
- 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
API Key for the service
Query Parameters
API Key, alternative to using the HTTP header X-Dune-Api-Key
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.
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.
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.
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 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).
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.
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
Timestamp of when the query execution was cancelled, if applicable.
Timestamp of when the query execution ended.
Unique identifier for the execution of the query.
Timestamp of when the query execution started.
Timestamp of when the query result expires.
Whether the state of the query execution is terminal. This can be used for polling purposes.
Offset that can be used to retrieve the next page of results.
URI that can be used to fetch the next page of results.
Unique identifier of the query.
The object containing the results and metadata of the query execution
The state of the query execution.
Timestamp of when the query was submitted.
Was this page helpful?