Query Builder

Build custom queries to analyze DeFi protocol data (Aave V3, Uniswap V3) on Arkiv DB-chain

💡

How to use

  • • Select filters to narrow down your results
  • • Choose a visualization type (Table, Bar, Pie, or Line chart)
  • • Click "Execute Query" to run your query against the DB-chain
  • • Export results as CSV or copy as JSON

Query Builder

Query real Aave V3 events stored on Arkiv DB-chain

Protocol: Aave V3 • Listening to live blockchain events

Query all Aave V3 event types

Filter by asset contract address. Matches reserve, asset, collateralAsset, or debtAsset fields.

Filter by user wallet address. Matches user, initiator, or liquidator fields.

Amounts are stored as BigInt strings (in Wei). Example: 1000000 = 1 USDC (6 decimals)

Query Preview (Arkiv attributes):

Main query: WHERE protocol = "aave-v3" | Client-side filters: none | LIMIT 100

⚠️ Arkiv only supports ONE .where() clause. Additional filters applied client-side.

💡 Example Queries:

  • • All Supply events: eventType = "Supply"
  • • Flash loans only: eventType = "FlashLoan"
  • • User activity: user = "0x123..."
  • • Large transactions: minAmount = "1000000000000000000" (1 ETH in Wei)
  • • Liquidations: eventType = "LiquidationCall"
🔍

Ready to Query

Configure your query on the left and click "Execute Query" to see results

Example Queries