Polimec Dashboards

Overview

Polimec offers a decentralized, transparent, and compliant method for fundraising, ensuring that stakeholder incentives are aligned both during and after the fundraising process.

Featured Dashboards on Dune

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

• Polimec: A comprehensive analysis of Polimec, including: Staking, Funding, Asset Analysis.

Key Tables

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

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

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

Useful Queries

Some useful queries for Polimec are provided:

Title	Query	Description
Polimec Latest Collator Info	query_3776548	Find the latest collator information on Polimec
Plimec All Evaluations	query_3802921	Get all evaluation information for all projects on Polimec
Polimec All Funding Participations	query_3850228	Get all funding participation information for all projects on Polimec

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:

Polimec Latest Reward Distribution

WITH latest_round AS (
  SELECT
    MAX(CAST(JSON_EXTRACT_SCALAR(data, '$[0]') AS BIGINT)) AS start_block
  FROM
    polimec.events
  WHERE
    section = 'parachainStaking'
    AND method = 'NewRound'
),
summed AS (
  SELECT
    MAX(block_time) AS latest_time,
    JSON_EXTRACT_SCALAR(JSON_PARSE(data), '$[0]') AS delegator,
    SUM(
      CAST(JSON_EXTRACT_SCALAR(data, '$[1]') AS BIGINT) / POW(10, 10)
    ) AS reward
  FROM
    polimec.events
  WHERE
    section = 'parachainStaking'
    AND method = 'Rewarded'
    AND CAST(block_number AS BIGINT) >= (
      SELECT
        start_block
      FROM
        latest_round
    )
  GROUP BY
    JSON_EXTRACT_SCALAR(JSON_PARSE(data), '$[0]')
)
SELECT
  latest_time,
  delegator,
  get_href(
    'https://explorer.polimec.org/polimec/account/' || delegator,
    CONCAT(
      SUBSTR(delegator, 1, 4),
      '...',
      SUBSTR(delegator, LENGTH(delegator) - 3)
    )
  ) AS delegator_url,
  reward
FROM
  summed
ORDER BY
  reward DESC;

Query result:

DuneSQL Referece

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