List of Example Queries

The framework we have built is infinitely customizable and one can add new queries with just a few lines of code and less than 5 minutes. But we made a few of them so we can demonstrate the extent. Here is the list of them.

User Transactions

Param Name	Explanation
numberOfTransactions	Total number of transactions done by the user
numberOfTransactionsTo	See the transactions where the user is in the "to" side of the tx
numberOfTransactionsFrom	See the transactions where the user is in the "from" side of the tx
numberOfErc20Transactions	Total number of ERC20 transfers done by the user
numberOfNftTransactions	Total number of NFT transfers done by the user
numberOfSpecificErc20Transactions	Total number of transfers done by the user on a specific ERC20 contract. Requires address in the query
numberOfSpecificNftTransactions	Total number of transfers done by the user on a specific NFT contract. Require address in the query.
numberOfContractInteractions	Number of contract interactions done by the user on a specific contract. Require address in the query.
numberOfContractInteractionsSent	Number of contract interactions done by the user on a specific contract where the user is in the "from" part of the tx. Require address in the query.
everHeldERC20	Has the user ever held ERC20 Tokens
everHeldNft	Has the user ever held NFT Tokens
walletAge	Age of the wallet (since the first transaction)

Governance

Param Name	Explanation
everCastedVote	If the user has ever casted a vote in a governance contract.
numberOfProposalsCreated	The number of proposals created by the user in a governance contract.
numberOfVotesCasted	Total number of votes casted by a user in governance contracts accross the chain.

DeFi

Param Name	Explaination
stakedTokens	Number of tokens staked by the user
numberOfStakingTransactions	Number of stake transactions done by the user
numberOfPolygonBridges	Number of transactions done by the user on the polygon bridge.
numberOfWithdraws	Number of withdraw transactions done by the user.
numberOfBorrows	Number of borrow transactions done by the user.
numberOfApprovals	Number of approvals transactions done by the user.
numberOfClaims	Number of claim transactions done by the user
numberOfDeposits	Number of deposit transactions done by the user
numberOfOutStandingPayments	Number of outstanding payments left for the user.
numberOfOutStandingDays	Number of average outstanding days the payments have been there.
compoundUsage	Number of times the user has interacted with the compound contracts.

NFTs

Param Name	Explanation
numberOfMints	Number of NFTs minted by a user
numberOfNFTsHeld	Number of NFTs held by the user
numberOfOpenseaTransactions	Number of opensea transactions done by the user
numberOfBluechipsHeld	Number of bored apes or cryptopunks held by the user

While technically any quereis can be treated as a bonker and be used for negative XP, we have built special queries like `penaltyForMinting` for eg, which sees if the user flips / sells / swaps tokens veryh soon after airdrop.