GET
/
v1
/
points
/
linea
/
lxp
  • 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, 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
cancelled_at
string

Timestamp of when the query execution was cancelled, if applicable.

execution_ended_at
string

Timestamp of when the query execution ended.

execution_id
string

Unique identifier for the execution of the query.

execution_started_at
string

Timestamp of when the query execution started.

expires_at
string

Timestamp of when the query result expires.

is_execution_finished
boolean

Whether the state of the query execution is terminal. This can be used for polling purposes.

next_offset
integer

Offset that can be used to retrieve the next page of results.

next_uri
string

URI that can be used to fetch the next page of results.

query_id
integer

Unique identifier of the query.

result
object

The object containing the results and metadata of the query execution

state
string

The state of the query execution.

submitted_at
string

Timestamp of when the query was submitted.