> For the complete documentation index, see [llms.txt](https://qualitax.gitbook.io/polymesh/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://qualitax.gitbook.io/polymesh/exploring-polymesh-data/assets.md).
# Assets
The metrics below not only offer a snapshot of the current state of assets (as of 05 March 2024 ) but also enable stakeholders to analyze trends over time, assess the diversity of asset types, and understand investor engagement.
| Metric Category | Metric | Metric Description |
| --------------- | -------------------------------------------- | --------------------------------------------------------------- |
| Assets | Nb Assets | Total number of assets on the network |
| Assets | Assets by type | Total number of assets on the network by type |
| Assets | Assets per month per type | Total number of assets created per month, grouped by asset type |
| Assets | Top 10 Assets by investor count | Top 10 assets by investor count |
| Assets | Assets created over the last 30 days by type | Total number of assets created over the last 30 days by type |
| Assets | List of Assets created over the last 30 days | List of assets created over the last 30 days |
## Nb Assets
This metric gives a high-level overview of the ecosystem's size and growth, indicating the adoption and utilization of the Polymesh platform for asset issuance.
**How many assets have been tokenized on the Polymesh network?**
**SQL**
```
SELECT
COUNT(*) as nbAssets
FROM
assets
```
Nb Assets
**GraphQL**
```
query {
assets {
totalCount
}
}
```
##
## Assets by type
This metric is important for understanding the composition of the asset ecosystem, showing which types of assets (e.g., bonds, equities, funds) are most prevalent. This reflects market preferences and regulatory compliance capabilities of Polymesh.
#### How many assets have been tokenized on the Polymesh network by type of asset ?
**SQL**
```
SELECT
type as assetType, COUNT(*) as nbAssets
FROM
assets
GROUP BY type
ORDER BY nbAssets DESC;
```
Assets by type
**GraphQL**
```
query assetGroupedByTypeCount {
assets(orderBy: TYPE_ASC) {
totalCount
groupedAggregates(groupBy: TYPE) {
keys
distinctCount {
ticker
}
}
}
}
```
##
## Assets per month per type
This metric provides insights into growth trends and market dynamics, helping to identify patterns or shifts in the types of assets being created, which could be indicative of broader market or regulatory changes.
#### How many assets have been tokenized per month, grouped by asset type ?
**SQL**
```
SELECT
DATE_TRUNC('month', b.datetime) AS month,
a.type,
COUNT(*) AS total_assets_created
FROM
assets a
JOIN
blocks b ON a.created_block_id::integer = b.block_id
GROUP BY
month,
a.type
ORDER BY
month DESC,
a.type;
```
Assets per month per type
**GraphQL**
```
query {
assets {
nodes {
type
createdBlock {
datetime
}
}
}
}
```
This query retrieves the `type` and `createdBlock.datetime` fields for each asset. The `createdBlock` field represents the block in which the asset was created, and the `datetime` field represents the timestamp of that block.
After executing the query, you can process the results in your application code to group the assets by month and type, and count the total assets created for each group.
{% hint style="info" %}
**Potential improvement #2**
The current Polymesh GraphQL schema could be updated to support the grouping and counting of assets using the `@derivedFrom` directive and some additional queries.
{% endhint %}
## Top 10 Assets by investor count
This metric highlights the most popular or widely held assets, which can be a proxy for market sentiment, perceived value, or investor confidence in certain asset classes or issuances.
#### What are the top 10 assets on Polymesh by number of investors ?
**SQL**
```
WITH AssetCreation AS (
SELECT
DATE_TRUNC('month', b.datetime) AS createdMonth,
a.id AS assetID
FROM
assets a
JOIN
blocks b ON a.created_block_id::integer = b.block_id
),
TopAssets AS (
SELECT
a.id AS assetID,
a.name AS "Asset Name",
a.type AS "Asset Type",
COUNT(DISTINCT ah.identity_id) AS "InvestorCount",
a.total_supply AS "Total Supply"
FROM
assets a
JOIN
asset_holders ah ON ah.asset_id = a.id
GROUP BY
a.id
ORDER BY
"InvestorCount" DESC
LIMIT 10
)
SELECT
t."Asset Name",
t.assetID,
t."Asset Type",
t."InvestorCount",
t."Total Supply",
ac.createdMonth
FROM
TopAssets t
JOIN
AssetCreation ac ON t.assetID = ac.assetID
ORDER BY
t."InvestorCount" DESC;
```
Top 10 Assets by investor count
**GraphQL**
```
query {
assets(
orderBy: HOLDERS_COUNT_DESC
first: 10
) {
nodes {
id
name
type
holders {
totalCount
}
totalSupply
createdBlock {
datetime
}
}
}
}
```
Top 10 Assets by investor count
##
## Assets created over the last 30 days by type
This metric allows stakeholders to track recent activity and interest in different types of assets. This metric is particularly useful for identifying sudden spikes or drops in asset issuance, possibly in response to market or regulatory developments.
#### How many assets created over the last 30 days by type ?
**SQL**
```
SELECT
a.type AS "Asset Type",
COUNT(a.id) AS "Number of Assets Created",
DATE_TRUNC('day', b.datetime) AS "Creation Date"
FROM
assets a
JOIN
blocks b ON a.created_block_id::integer = b.block_id
WHERE
b.datetime >= NOW() - INTERVAL '30 days'
GROUP BY
"Asset Type", "Creation Date"
ORDER BY
"Creation Date" DESC, "Asset Type";
```
Results: none at the time of running the query.
**GraphQL**
```
query {
assets {
nodes {
id
type
createdBlock {
datetime
}
}
}
}
```
This query retrieves all the assets and their corresponding `type` and `createdBlock.datetime` fields. Since the provided schema doesn't support filtering or formatting directly in the query, you will need to handle the filtering and formatting in the application code.
{% hint style="info" %}
**Potential improvement #3**
The current Polymesh GraphQL schema could be updated to support filtering of assets.
{% endhint %}
##
## List of assets created over the last 30 days
This metric provides specific details on recent issuances, offering users immediate insights into the newest assets on the network. This can be valuable for investors looking for new opportunities or analysts monitoring the innovation and evolution of the platform's offerings.
#### What is the list of assets created over the last 30 days on Polymesh ?
**SQL**
```
SELECT
ticker, name, type, funding_round
FROM
assets a
JOIN
blocks b ON a.created_block_id::integer = b.block_id
WHERE
b.datetime >= NOW() - INTERVAL '30 days';
```
**GraphQL**
```
query {
assets {
nodes {
ticker
name
type
fundingRound
createdBlock {
datetime
}
}
}
}
```
This query retrieves all the assets and their corresponding `ticker`, `name`, `type`, `fundingRound`, and `createdBlock.datetime` fields.
Since the provided schema doesn't support filtering directly in the query, you'll need to handle the filtering of assets created within the last 30 days in the application code.
{% hint style="info" %}
**Potential improvement #3**
The current Polymesh GraphQL schema could be updated to support filtering of assets.
{% endhint %}