Skip to main content
POST
/
v1
/
solana
/
dex
/
profiles
/
wallets
/
search-profiles
Search Profiles
curl --request POST \
  --url https://refract.prismapi.io/v1/solana/dex/profiles/wallets/search-profiles \
  --header 'Content-Type: application/json' \
  --header 'X-Api-Key: <api-key>' \
  --data '
{
  "$or": [
    {
      "$and": [
        {
          "metrics.7d.cumulative_pnl": {
            "$gt": 65000,
            "$lt": 100000
          }
        },
        {
          "metrics.30d.max_drawdown": {
            "$lt": 20
          }
        }
      ]
    },
    {
      "metrics.7d.sortino_ratio": {
        "$in": [
          1.5,
          2
        ]
      }
    }
  ]
}
'
{
  "count": 123,
  "cursor": "<string>",
  "data": [
    {
      "wallet_address": "<string>",
      "metadata": {
        "last_trade_at": 123
      },
      "metrics": {
        "30d": {
          "risk_score": 123,
          "consistency_score": 123,
          "largest_win": 123,
          "largest_loss": 123,
          "max_consecutive_wins": 123,
          "max_consecutive_losses": 123,
          "avg_buy_size": 123,
          "avg_sell_size": 123,
          "avg_buy_mcap": 123,
          "avg_sell_mcap": 123,
          "avg_daily_pnl": 123,
          "avg_daily_roi": 123,
          "avg_daily_trade_count": 123,
          "avg_daily_traded_tokens": 123,
          "avg_daily_volume": 123,
          "avg_holding_duration": 123,
          "avg_trade_delta": 123,
          "avg_pnl": 123,
          "avg_roi": 123,
          "avg_token_pnl": 123,
          "avg_token_roi": 123,
          "token_roi_distribution": {
            "gt_500": 123,
            "200_500": 123,
            "0_200": 123,
            "neg50_0": 123,
            "lt_neg50_0": 123
          },
          "trade_count": 123,
          "buy_count": 123,
          "sell_count": 123,
          "position_count": 123,
          "win_count": 123,
          "loss_count": 123,
          "pnl": 123,
          "win_pnl": 123,
          "loss_pnl": 123,
          "volume": 123,
          "buy_volume": 123,
          "sell_volume": 123,
          "winrate": 123,
          "volume_weighted_winrate": 123,
          "roi": 123,
          "volume_weighted_roi": 123,
          "time_weighted_roi": 123,
          "pnl_volume_ratio": 123,
          "token_hit_ratio": 123,
          "win_loss_size_ratio": 123,
          "profit_factor": 123,
          "profit_expectancy": 123,
          "recovery_factor": 123,
          "winrate_stability": 123,
          "winrate_volatility": 123,
          "pnl_stability": 123,
          "pnl_volatility": 123,
          "roi_stability": 123,
          "roi_volatility": 123,
          "sharpe_ratio": 123,
          "sortino_ratio": 123,
          "max_drawdown": 123,
          "risk_of_ruin": 123,
          "turnover": 123
        },
        "14d": {
          "risk_score": 123,
          "consistency_score": 123,
          "largest_win": 123,
          "largest_loss": 123,
          "max_consecutive_wins": 123,
          "max_consecutive_losses": 123,
          "avg_buy_size": 123,
          "avg_sell_size": 123,
          "avg_buy_mcap": 123,
          "avg_sell_mcap": 123,
          "avg_daily_pnl": 123,
          "avg_daily_roi": 123,
          "avg_daily_trade_count": 123,
          "avg_daily_traded_tokens": 123,
          "avg_daily_volume": 123,
          "avg_holding_duration": 123,
          "avg_trade_delta": 123,
          "avg_pnl": 123,
          "avg_roi": 123,
          "avg_token_pnl": 123,
          "avg_token_roi": 123,
          "token_roi_distribution": {
            "gt_500": 123,
            "200_500": 123,
            "0_200": 123,
            "neg50_0": 123,
            "lt_neg50_0": 123
          },
          "trade_count": 123,
          "buy_count": 123,
          "sell_count": 123,
          "position_count": 123,
          "win_count": 123,
          "loss_count": 123,
          "pnl": 123,
          "win_pnl": 123,
          "loss_pnl": 123,
          "volume": 123,
          "buy_volume": 123,
          "sell_volume": 123,
          "winrate": 123,
          "volume_weighted_winrate": 123,
          "roi": 123,
          "volume_weighted_roi": 123,
          "time_weighted_roi": 123,
          "pnl_volume_ratio": 123,
          "token_hit_ratio": 123,
          "win_loss_size_ratio": 123,
          "profit_factor": 123,
          "profit_expectancy": 123,
          "recovery_factor": 123,
          "winrate_stability": 123,
          "winrate_volatility": 123,
          "pnl_stability": 123,
          "pnl_volatility": 123,
          "roi_stability": 123,
          "roi_volatility": 123,
          "sharpe_ratio": 123,
          "sortino_ratio": 123,
          "max_drawdown": 123,
          "risk_of_ruin": 123,
          "turnover": 123
        },
        "7d": {
          "risk_score": 123,
          "consistency_score": 123,
          "largest_win": 123,
          "largest_loss": 123,
          "max_consecutive_wins": 123,
          "max_consecutive_losses": 123,
          "avg_buy_size": 123,
          "avg_sell_size": 123,
          "avg_buy_mcap": 123,
          "avg_sell_mcap": 123,
          "avg_daily_pnl": 123,
          "avg_daily_roi": 123,
          "avg_daily_trade_count": 123,
          "avg_daily_traded_tokens": 123,
          "avg_daily_volume": 123,
          "avg_holding_duration": 123,
          "avg_trade_delta": 123,
          "avg_pnl": 123,
          "avg_roi": 123,
          "avg_token_pnl": 123,
          "avg_token_roi": 123,
          "token_roi_distribution": {
            "gt_500": 123,
            "200_500": 123,
            "0_200": 123,
            "neg50_0": 123,
            "lt_neg50_0": 123
          },
          "trade_count": 123,
          "buy_count": 123,
          "sell_count": 123,
          "position_count": 123,
          "win_count": 123,
          "loss_count": 123,
          "pnl": 123,
          "win_pnl": 123,
          "loss_pnl": 123,
          "volume": 123,
          "buy_volume": 123,
          "sell_volume": 123,
          "winrate": 123,
          "volume_weighted_winrate": 123,
          "roi": 123,
          "volume_weighted_roi": 123,
          "time_weighted_roi": 123,
          "pnl_volume_ratio": 123,
          "token_hit_ratio": 123,
          "win_loss_size_ratio": 123,
          "profit_factor": 123,
          "profit_expectancy": 123,
          "recovery_factor": 123,
          "winrate_stability": 123,
          "winrate_volatility": 123,
          "pnl_stability": 123,
          "pnl_volatility": 123,
          "roi_stability": 123,
          "roi_volatility": 123,
          "sharpe_ratio": 123,
          "sortino_ratio": 123,
          "max_drawdown": 123,
          "risk_of_ruin": 123,
          "turnover": 123
        },
        "3d": {
          "risk_score": 123,
          "consistency_score": 123,
          "largest_win": 123,
          "largest_loss": 123,
          "max_consecutive_wins": 123,
          "max_consecutive_losses": 123,
          "avg_buy_size": 123,
          "avg_sell_size": 123,
          "avg_buy_mcap": 123,
          "avg_sell_mcap": 123,
          "avg_daily_pnl": 123,
          "avg_daily_roi": 123,
          "avg_daily_trade_count": 123,
          "avg_daily_traded_tokens": 123,
          "avg_daily_volume": 123,
          "avg_holding_duration": 123,
          "avg_trade_delta": 123,
          "avg_pnl": 123,
          "avg_roi": 123,
          "avg_token_pnl": 123,
          "avg_token_roi": 123,
          "token_roi_distribution": {
            "gt_500": 123,
            "200_500": 123,
            "0_200": 123,
            "neg50_0": 123,
            "lt_neg50_0": 123
          },
          "trade_count": 123,
          "buy_count": 123,
          "sell_count": 123,
          "position_count": 123,
          "win_count": 123,
          "loss_count": 123,
          "pnl": 123,
          "win_pnl": 123,
          "loss_pnl": 123,
          "volume": 123,
          "buy_volume": 123,
          "sell_volume": 123,
          "winrate": 123,
          "volume_weighted_winrate": 123,
          "roi": 123,
          "volume_weighted_roi": 123,
          "time_weighted_roi": 123,
          "pnl_volume_ratio": 123,
          "token_hit_ratio": 123,
          "win_loss_size_ratio": 123,
          "profit_factor": 123,
          "profit_expectancy": 123,
          "recovery_factor": 123,
          "winrate_stability": 123,
          "winrate_volatility": 123,
          "pnl_stability": 123,
          "pnl_volatility": 123,
          "roi_stability": 123,
          "roi_volatility": 123,
          "sharpe_ratio": 123,
          "sortino_ratio": 123,
          "max_drawdown": 123,
          "risk_of_ruin": 123,
          "turnover": 123
        },
        "1d": {
          "risk_score": 123,
          "consistency_score": 123,
          "largest_win": 123,
          "largest_loss": 123,
          "max_consecutive_wins": 123,
          "max_consecutive_losses": 123,
          "avg_buy_size": 123,
          "avg_sell_size": 123,
          "avg_buy_mcap": 123,
          "avg_sell_mcap": 123,
          "avg_daily_pnl": 123,
          "avg_daily_roi": 123,
          "avg_daily_trade_count": 123,
          "avg_daily_traded_tokens": 123,
          "avg_daily_volume": 123,
          "avg_holding_duration": 123,
          "avg_trade_delta": 123,
          "avg_pnl": 123,
          "avg_roi": 123,
          "avg_token_pnl": 123,
          "avg_token_roi": 123,
          "token_roi_distribution": {
            "gt_500": 123,
            "200_500": 123,
            "0_200": 123,
            "neg50_0": 123,
            "lt_neg50_0": 123
          },
          "trade_count": 123,
          "buy_count": 123,
          "sell_count": 123,
          "position_count": 123,
          "win_count": 123,
          "loss_count": 123,
          "pnl": 123,
          "win_pnl": 123,
          "loss_pnl": 123,
          "volume": 123,
          "buy_volume": 123,
          "sell_volume": 123,
          "winrate": 123,
          "volume_weighted_winrate": 123,
          "roi": 123,
          "volume_weighted_roi": 123,
          "time_weighted_roi": 123,
          "pnl_volume_ratio": 123,
          "token_hit_ratio": 123,
          "win_loss_size_ratio": 123,
          "profit_factor": 123,
          "profit_expectancy": 123,
          "recovery_factor": 123,
          "winrate_stability": 123,
          "winrate_volatility": 123,
          "pnl_stability": 123,
          "pnl_volatility": 123,
          "roi_stability": 123,
          "roi_volatility": 123,
          "sharpe_ratio": 123,
          "sortino_ratio": 123,
          "max_drawdown": 123,
          "risk_of_ruin": 123,
          "turnover": 123
        }
      }
    }
  ]
}
To filter nested fields, use dot notation to specify the full path to the field.metrics.7d.cumulative_pnlmarket.fdvmetadata.symbol
The filter object must be constructed using explicit operators.
  • $and - All conditions must match.
{"$and": [{"field": { "$eq": "value" }}, {"field": { "$gt": "value" }}]}
  • $or - At least one condition must match.
{"$or": [{"field": { "$eq": "value" }}, {"field": { "$gt": "value" }}]}

Authorizations

​
X-Api-Key
string
header
required

Your Prism API key. You can get one for free in the Prism Dashboard.

Body

application/json
​
filter
object

Filter rules to apply. An object following a MongoDB query like syntax.

​
sort
object

Sorting rule to apply.

​
time_windows
enum<string>[]

List of time windows to include in the profile metrics.

Available options:
30d,
14d,
7d,
3d,
1d
​
limit
integer
default:20

Maximum number of results to return.

Required range: 1 <= x <= 100
​
cursor
string

Cursor to return the next page of results.

Response

List of wallet profiles found from the search.

​
count
integer

Total number of matching items

​
cursor
string

Cursor for pagination

​
data
object[]