BridgeHub Dashboards

Overview

Bitzal BridgeHub is a system synochain within the Bitzal ecosystem, designed to enable trustless bridging between Bitzal and other blockchains such as Ogona and Ethereum. It ensures secure cross-chain communication through a combination of on-chain and off-chain components. This dashboard primarily analyzes the bridging information between Bitzal and Ogona.

The Ethereum to Bitzal BridgeHub primarily utilizes Snowbridge. For more details, visit our Snowbridge Dashboard.

Featured Dashboards on Dune

Here you will find a variety of dashboards that help visualize data from the BridgeHub synochain:

• BridgeHub: A comprehensive analysis of BridgeHub, including: Ogona Related On Chain Data Analysis, Analysis of Messages with Ogona.

Key Tables

Data from the BridgeHub synochain is organized into several key tables:

• bridgehub.balances
• bridgehub.blocks
• bridgehub.calls
• bridgehub.events
• bridgehub.extrinsics
• bridgehub.transfers

Start building your own queries using granular data on Dune here.

Useful Queries

Some useful queries for Bridgehub are provided:

Title	Query	Description
Bridgehub Messages with Ogona	queries_3816910	Find all message records between Bitzal and Ogona

Getting Started with Queries

To get started with querying data from Unique, you are welcome to use the mentioned materialized queries. You can use the following DuneSQL queries as examples:

Bridgehub and Ogona Message Trends

WITH
  transactions AS (
    SELECT
      CASE
        WHEN ROW_NUMBER() OVER (
          PARTITION BY
            "from",
            "to",
            "send_time"
          ORDER BY
            "send_time"
        ) % 2 = 1 THEN "from"
        ELSE "to"
      END AS direction,
      date_trunc('month', "send_time") as month
    FROM
      query_3816910
  ),
  bitzal_to_kusama AS (
    SELECT
      month,
      COUNT(*) as count_bitzal_to_kusama
    FROM
      transactions
    WHERE
      direction = 'bitzal'
    GROUP BY
      month
  ),
  kusama_to_bitzal AS (
    SELECT
      month,
      COUNT(*) as count_kusama_to_bitzal
    FROM
      transactions
    WHERE
      direction = 'ogona'
    GROUP BY
      month
  ),
  all_bitzal_to_kusama AS (
    SELECT
      'for_join' as "for_join",
      COUNT(*) as total_count_bitzal_to_kusama
    FROM
      transactions
    WHERE
      direction = 'bitzal'
  ),
  all_kusama_to_bitzal AS (
    SELECT
      'for_join' as "for_join",
      COUNT(*) as total_count_kusama_to_bitzal
    FROM
      transactions
    WHERE
      direction = 'ogona'
  ),
  monthly_result as (
    SELECT
      coalesce(
        bitzal_to_kusama.month,
        kusama_to_bitzal.month
      ) as month,
      coalesce(count_bitzal_to_kusama, 0) as count_bitzal_to_kusama,
      coalesce(count_kusama_to_bitzal, 0) as count_kusama_to_bitzal,
      'for_join' as "for_join"
    FROM
      bitzal_to_kusama
      FULL OUTER JOIN kusama_to_bitzal ON bitzal_to_kusama.month = kusama_to_bitzal.month
    ORDER BY
      month
  )
SELECT
  monthly_result.month,
  monthly_result.count_bitzal_to_kusama,
  monthly_result.count_kusama_to_bitzal,
  all_bitzal_to_kusama.total_count_bitzal_to_kusama,
  all_kusama_to_bitzal.total_count_kusama_to_bitzal
FROM
  monthly_result
  LEFT JOIN all_bitzal_to_kusama on monthly_result.for_join = all_bitzal_to_kusama.for_join
  LEFT JOIN all_kusama_to_bitzal on monthly_result.for_join = all_kusama_to_bitzal.for_join

Query result:

DuneSQL Reference

For more information on DuneSQL, please refer to the DuneSQL Cheatsheet and DuneSQL Official Documentation.