Logo
X1 Explorer by DexGuru
OKB price $

Addresses Activity

Dashboard

This dashboard provides an overview of network interest from a token perspective.

Follow these steps to explore the data: Select the "xfi_test" network, set the limit to 500, and choose the date range "This week."

  1. The "Addresses Count" section displays the total number of unique addresses.
  2. The "Adresses Amount Increse - Unique Addresses Activity" section displays the total number of unique addresses increase.
  3. The "Addresses Interaction" section provides data about the parties involved.
  4. The "Adress To Block Activity" shows active addresses per block.

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

Addresses Count

SQL query
This query counts the number of unique addresses involved in transactions on the specified network, considering both the "to" and "from" addresses, and limits the result to a specified number.
— Unique Addresses
Querying data

Addresses Amount Increase

SQL query
This query retrieves and processes token balance data from a specified network within a given date range, calculating the cumulative value change and increase in distinct holder addresses over time, and limiting the results to a specified number.
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

Address To Block Activity

SQL query
This query retrieves all columns from the logs table of the specified network, ordering the results by block number in descending order, and limits the output to a specified number of rows.
Querying data

Unique Addresses Activity

SQL query
This query retrieves and processes token balance data from a specified network within a given date range, calculating the cumulative value change and increase in distinct holder addresses over time, and limiting the results to a specified number.
Show rows

Querying for data...

Show rows
Querying data

Address To Block Activity

SQL query
This query retrieves all columns from the logs table of the specified network, ordering the results by block number in descending order, and limits the output to a specified number of rows.
Show rows

Querying for data...

Show rows
Querying data

Addresses Interaction

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.
Show rows

Querying for data...

Show rows
Querying data
DexGuru
Block Explorers Powered by DexGuru
DexGuru is an Analytics Platform and Block Explorer for X1.
Back to Dex.guru
©2024 dex.guru
Version Beta 5f58ca9