OKB price $

Transactions Activity

Dashboard

This dashboard provides a basic overview of network interest from a transaction perspective.

For example, select the "xfi_test" network, set the limit to 500, and choose dates "This week."

The "Txs Types - Txs Values" query dashboard shows the accumulated sum of transaction types. The dominant swaps and mints, along with steady growth, indicate ongoing interest in both usage and liquidity provision.
The "Volumes - Txs Values" section provides detailed value information to help evaluate the significance of transactions.
The "Density - Txs Values" section displays time-series areas of interest for specific operations and volumes.
The "Addresses Interaction" section provides data about the parties involved.
The "Wallets Focused Interactions" section highlights the most interested parties.

Dashboard link: https://warehouse.dex.guru/dashboards/txs_activity

Txs Types

SQL query

This query retrieves and processes transaction data within a specified date range, calculating the count and running sum of transaction values for swap, burn and mint transaction types, grouped and ordered by the block timestamp.

Querying data

Volumes

SQL query

Querying data

Density by Tx Type

SQL query

Querying data

All Parties

SQL query

This query retrieves and processes transaction data from a decentralized exchange (DEX) within a specified date range, including pool and wallet addresses, token addresses and amounts, transaction type, and calculates transaction values and their running sum, ordered by timestamp and transaction value sum.

Querying data

Wallet Focused Interactions

SQL query

This query retrieves transaction data from a decentralized exchange (DEX), including details such as pool and wallet addresses, token addresses and amounts, transaction type, calculates transaction values and their running sum, and orders the results by timestamp in descending order and transaction value sum in ascending order.

Querying data