Astar Dashboards¶

Overview¶

Astar Network, previously known as Plasm, is a blockchain platform designed for Web3. It is compatible with both EVM (Ethereum Virtual Machine) and WebAssembly, enabling seamless interaction between the two environments. Developers can participate in the Build2Earn program to earn rewards by creating decentralized applications.

Featured Dashboards on Dune¶

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

Astar dApp Staking Overview: This dashboard is designed to provide a quick overview of various aspects of Astar dApp Staking.

Key Tables¶

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

astar.balances
astar.blocks
astar.calls
astar.events
astar.extrinsics
astar.transfers
astar.traces

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

Useful Queries¶

Some useful queries for Astar are provided:

Title	Query	Description
Astar dApp Info by Era	query_3727264	This query provides comprehensive information on decentralized applications (dApps) within the Astar ecosystem, including details about the dApp name, staking statistics, tier levels, and developer profiles, facilitating deeper insights into dApp performance and engagement across different eras.
Astar Reward Info by Era	query_3727888	Explore comprehensive data on rewards distribution within the Astar network, broken down by era to identify trends and patterns.
Astar Staker info by Era	query_3728048	Access a detailed breakdown of staker activities and statistics on the Astar network, categorized by era for historical comparison.

Getting Started with Queries¶

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

sql title="Astar EVM Executed" showLineNumbers SELECT block_number, extrinsic_id, event_id, extrinsic_hash, section, method, json_extract_scalar(data, '$[0]') as tx_from, json_extract_scalar(data, '$[1]') as tx_to, json_extract_scalar(data, '$[2]') as tx_hash, json_extract(data, '$[3]') as tx_success FROM astar.events WHERE block_time >= TIMESTAMP '2024-02-13 00:00:00' and (section = 'ethereum' and method = 'Executed') limit 10000;

Query result:

DuneSQL Reference

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