GET
/
v1
/
points
/
linea
/
lxp
curl --request GET \
  --url https://api.dune.com/api/v1/points/linea/lxp \
  --header 'X-DUNE-API-KEY: <x-dune-api-key>'
{
  "execution_id": " 01HX5HHMTFZK2JC00FE8FV33EE",
  "query_id": 3672612,
  "is_execution_finished": true,
  "state": "QUERY_STATE_COMPLETED",
  "submitted_at": "2024-05-05T23:31:09.264056Z",
  "expires_at": "2024-08-03T23:34:33.10589Z",
  "execution_started_at": "2024-05-05T23:31:12.553842Z",
  "execution_ended_at": "2024-05-05T23:34:33.105887Z",
  "result": {
    "rows": [
      {
        "L14D_active_tier": "not active",
        "connected_wallets": [
          null
        ],
        "contracts_deployed": 14,
        "current_lxp": 4934,
        "days_old_onchain": 992,
        "dex_volume_usd": 4600.9847997694715,
        "fid": null,
        "fname": "-",
        "nft_volume_usd": 228.8637985996,
        "num_followers": null,
        "num_onchain_txns": 1513,
        "num_quests": 5,
        "on_farcaster": false,
        "times_contracts_called": 29,
        "top_channels": null,
        "top_domains": null,
        "top_engagers": null,
        "wallet": "0x2c21dc4fe422fbadd7dc1eda8ac4d10a8d9ffa2e"
      },
      {
        "L14D_active_tier": "npc",
        "connected_wallets": [
          "0x213616d873093efea758b5deb884ca88a77edbd48db751b27ed0cad68027774f",
          "0x42f36d45381e3f5d9443e872b6192aaf0db55b53",
          "0xd463122fcb41a0a63f3ea4060c9b812dea3f9f53"
        ],
        "contracts_deployed": 582,
        "current_lxp": 4904,
        "days_old_onchain": 980,
        "dex_volume_usd": 137706.3038118183,
        "fid": 217012,
        "fname": "danbir",
        "nft_volume_usd": 1446.9546141276132,
        "num_followers": 31,
        "num_onchain_txns": 12632,
        "num_quests": 5,
        "on_farcaster": true,
        "times_contracts_called": 647,
        "top_channels": [
          "onchain",
          "guild",
          "raffle"
        ],
        "top_domains": [
          "base.org"
        ],
        "top_engagers": [
          "innainna"
        ],
        "wallet": "0x42f36d45381e3f5d9443e872b6192aaf0db55b53"
      },
      {
        "L14D_active_tier": "npc",
        "connected_wallets": [
          "0x662790673de63afe086e0a8692388b17601eccf5",
          "0xcd0d4cdb238eec15fcf4ff9d13d5a59051e507d7"
        ],
        "contracts_deployed": 69,
        "current_lxp": 4882,
        "days_old_onchain": 1383,
        "dex_volume_usd": 26857099.90605816,
        "fid": 190446,
        "fname": "mike0182",
        "nft_volume_usd": 78821.98331677902,
        "num_followers": 24,
        "num_onchain_txns": 11929,
        "num_quests": 5,
        "on_farcaster": true,
        "times_contracts_called": 183,
        "top_channels": [
          "base"
        ],
        "top_domains": [
          "referrals.linea.build"
        ],
        "top_engagers": [
          "youoy"
        ],
        "wallet": "0xcd0d4cdb238eec15fcf4ff9d13d5a59051e507d7"
      },
      {
        "L14D_active_tier": "not active",
        "connected_wallets": [
          "0x7451e319282999940a79bcfa6e74e94d2ce7b96b",
          "0xf0b8bcd1921d37bf83d71ccee40d55a13b98f3c5"
        ],
        "contracts_deployed": 16,
        "current_lxp": 4834,
        "days_old_onchain": 1172,
        "dex_volume_usd": 181373.9776894516,
        "fid": 332387,
        "fname": "sayin",
        "nft_volume_usd": 5244.725172223999,
        "num_followers": null,
        "num_onchain_txns": 4893,
        "num_quests": 5,
        "on_farcaster": true,
        "times_contracts_called": 26,
        "top_channels": null,
        "top_domains": null,
        "top_engagers": null,
        "wallet": "0xf0b8bcd1921d37bf83d71ccee40d55a13b98f3c5"
      },
      {
        "L14D_active_tier": "npc",
        "connected_wallets": [
          "0xc1275b83e32d0b80ad045ee38dee2efbc2d6f5c8",
          "0x76f34d1a4535241ec054b49d969bdb37f444eb38"
        ],
        "contracts_deployed": 101,
        "current_lxp": 4829,
        "days_old_onchain": 1087,
        "dex_volume_usd": 942760.2390544564,
        "fid": 344993,
        "fname": "vitoloeth",
        "nft_volume_usd": 35789.65250788195,
        "num_followers": 11,
        "num_onchain_txns": 10840,
        "num_quests": 5,
        "on_farcaster": true,
        "times_contracts_called": 132,
        "top_channels": null,
        "top_domains": [
          "subsquid.deform.cc"
        ],
        "top_engagers": [
          null
        ],
        "wallet": "0x76f34d1a4535241ec054b49d969bdb37f444eb38"
      }
    ]
  },
  "metadata": {
    "column_names": [
      "wallet",
      "current_lxp",
      "num_quests",
      "on_farcaster",
      "fid",
      "fname",
      "connected_wallets",
      "L14D_active_tier",
      "top_channels",
      "top_domains",
      "top_engagers",
      "num_followers",
      "num_onchain_txns",
      "days_old_onchain",
      "nft_volume_usd",
      "dex_volume_usd",
      "contracts_deployed",
      "times_contracts_called"
    ],
    "column_types": [
      "varbinary",
      "double",
      "bigint",
      "boolean",
      "bigint",
      "varchar",
      "array(varbinary)",
      "varchar(10)",
      "array(varchar)",
      "array(varchar)",
      "array(varchar)",
      "bigint",
      "bigint",
      "bigint",
      "double",
      "double",
      "bigint",
      "bigint"
    ],
    "row_count": 5,
    "result_set_bytes": 1585,
    "total_row_count": 699992,
    "total_result_set_bytes": 93605533,
    "datapoint_count": 90,
    "pending_time_millis": 3289,
    "execution_time_millis": 200552
  },
  "next_uri": "https://api.dune.com/api/v1/execution/01HX5HHMTFZK2JC00FE8FV33EE/results?limit=5&offset=5&sort_by=current_lxp+desc",
  "next_offset": 5
}
  • Query powering this endpoint can be found here
  • Scheduled to update daily
  • Apply filters like WHERE, IN, AND/OR upon results
  • Use a combination of sort_by and limit to grab a subset of results, see pagination and sorting for more info

Column Descriptions

ColumnDescriptionType
walletUser wallet which hold LXP pointsstring
current_lxpCurrent Linea Voyage LXP balancedouble
num_questsNumber of quests completed by the user to obtain LXPinteger
on_farcasterIndicates if the wallet is connected to a Farcaster accountboolean
fidFarcaster ID for the connected wallet userinteger
fnameFarcaster name for the connected wallet userstring
connected_walletsList of wallet addresses connected to the userarray(string)
L14D_active_tierThe active tier of the connected wallet user over the last 14 days. Possible values are “vip”, “influencer”, “star”, “active”, “npc”, and “not active”string
top_channelsTop 3 channels where connected wallet user is activearray(string)
top_domainsTop 3 domains frequented casted by the connected wallet userarray(string)
top_engagersTop 3 users who engage with this connected wallet userarray(string)
num_followersNumber of followers the connected wallet user has on Farcasterinteger
num_onchain_txnsNumber of on-chain transactions performed by the connected wallet userinteger
days_old_onchainOnchain age of the connected wallet users; days since the first onchain transactioninteger
nft_volume_usdVolume of NFT transactions in USD of the connected wallet userdouble
dex_volume_usdVolume of DEX transactions in USD of the connected wallet userdouble
contracts_deployedNumber of smart contracts deployed by the connected wallet userinteger
times_contracts_calledNumber of times the connected wallet user’s deployed contracts were calledinteger

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