Skip to content

The Polkadot Blockchain Academy is coming to Switzerland in 2025! 👉 Apply Here

✖

Moonbeam Dashboards

Overview

Moonbeam is a fully Ethereum-compatible parachain on the Polkadot network, enabling developers to deploy existing Solidity smart contracts and DApp frontends with minimal changes. It is designed to provide interoperability and compatibility, bridging the gap between Ethereum and Polkadot.

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

  • Moonbeam DEX: Explore decentralized exchange activities and token swaps within the Moonbeam ecosystem.
  • Moonbeam Governance: Detailed insights into governance proposals, voting, and outcomes within the Moonbeam community.

Key Tables

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

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

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

Useful Queries

Some useful queries for Moonbeam are provided:

Title Query Description
Moonbeam Referenda Result query_3679042 Provides details on the results of Moonbeam referenda, including the total aye and nay votes, support, and the result of the referendum.
Moonbeam All Voting Types query_3642417 Offers a comprehensive overview of all voting types on Moonbeam, including standard, split, and split abstain votes, voting conviction, and voting tokens.

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:

sql title="Moonbeam Referenda Result" showLineNumbers SELECT DISTINCT CAST(JSON_EXTRACT_SCALAR(data, '$[0]') AS INTEGER) AS referenda_id, get_href( 'https://moonbeam.subscan.io/referenda_v2/' || CAST(JSON_EXTRACT_SCALAR(data, '$[0]') AS VARCHAR), CAST(JSON_EXTRACT_SCALAR(data, '$[0]') AS VARCHAR) ) AS referenda_id_url, varbinary_to_uint256( from_hex(SUBSTR(JSON_EXTRACT_SCALAR(data, '$[1].ayes'), 3)) ) / POW(10, 18) AS aye_total, varbinary_to_uint256( from_hex(SUBSTR(JSON_EXTRACT_SCALAR(data, '$[1].nays'), 3)) ) / POW(10, 18) AS nay_total, varbinary_to_uint256( from_hex(SUBSTR(JSON_EXTRACT_SCALAR(data, '$[1].support'), 3)) ) / POW(10, 18) AS support, method AS result FROM moonbeam.events WHERE section = 'referenda' AND ( method = 'Confirmed' OR method = 'Rejected' OR method = 'Cancelled' OR method = 'TimedOut' ) ORDER BY referenda_id DESC;

Query result:

DuneSQL Reference

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