EnergyWebX Dashboards

Overview

EnergyWebX is a parachain focused on integrating blockchain technology within the energy sector, aiming to enhance energy efficiency and promote renewable energy sources across the Polkadot ecosystem.

Featured Dashboards on Dune

Here you will find a variety of dashboards that help visualize data from the EnergyWebX parachain:

• EnergyWebX: This dashboard provides a comprehensive view of the blockchain activities and energy transactions within the EnergyWebX network.

Key Tables

Data from the EnergyWebX parachain is organized into several key tables:

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

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

Useful Queries

Some useful queries for EnergyWebX are provided:

Title	Query	Description
EnergyWebX Solutions and Groups	query_3810095	Provides a list of solutions and groups created within the EnergyWebX network.
EnergyWebX Operators and Worker	query_3813780	Displays a list of operators and workers connected to the EnergyWebX network.

Getting Started with Queries

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

EnergyWebX Token Lifted & Lowered

WITH
  lift AS (
    SELECT
      date_trunc('day', block_time) AS day,
      SUM(
        CAST(json_extract_scalar(data, '$[1]') AS double) / POWER(10, 18)
      ) AS amount,
      'AVTLifted' AS method
    FROM
      energywebx.events
    WHERE
      method = 'AVTLifted'
    GROUP BY
      date_trunc('day', block_time)
  ),
  lower AS (
    SELECT
      date_trunc('day', block_time) AS day,
      SUM(
        CAST(json_extract_scalar(data, '$[2]') AS double) / POWER(10, 18)
      ) AS amount,
      'AVTLowered' AS method
    FROM
      energywebx.events
    WHERE
      method = 'AvtLowered'
    GROUP BY
      date_trunc('day', block_time)
  )
SELECT
  *
FROM
  lift
UNION ALL
SELECT
  *
FROM
  lower;

Query result:

DuneSQL Referece

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