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
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
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
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
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.
Last updated