Summary 
Proponent: <a href="https://polkadot.subscan.io/account/13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE">Subsquid Lab Official</a> - 13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE Beneficiary: <a href="https://polkadot.subscan.io/account/13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE">Subsquid Lab Official </a>- 13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE
Contact Details:
Subsquid Labs GmbH
6300 Zug, Switzerland
Short description: Ongoing development and maintenance costs for public SQD Archives
Archive raw data: <a href="https://docs.google.com/spreadsheets/d/1qTLup1JU9XPsklciZDeHVbd-EtP1AvdP4zzI5rm4bSU/edit?gid=1549354589#gid=1549354589">Archive Infrastructure Metrics</a> - April, May, June
Requested: $264,838.09
Previous proposals: <a href="referenda/1193">https://polkadot.polkassembly.io/referenda/1193</a>
Motivation
A) Archives
Archives are an important piece of Polkadot and Kusama data infrastructure provided by SQD (formerly Subsquid). They provide access to on-chain data for public chains in the Polkadot ecosystem. They are being used as a data source for Squids and for efficient data exploration and ad-hoc queries.
The Archives, as performant data sources of historical on-chain data, are critical to the operation of backend APIs run by major projects in the Polkadot ecosystem (the list is not exhaustive): 
<ul>
<li>Tanssi Network</li>
<li>Talisman Wallet</li>
<li>Polimec</li>
<li>Polkassembly</li>
<li>Apillon</li>
<li>Hydration</li>
<li>Giant Squid API (maintained by LimeChain, see details below)</li>
<li>SubWallet</li>
<li>FiDi</li>
<li>KodaDot</li>
<li>RMRK</li>
<li>ChainSafe (in particular the Multix multi-sig, as well as other projects)</li>
<li>Phala Network</li>
<li>Stellaswap</li>
<li>Polkascan</li>
</ul>
Since the first quarter of 2024, SQD has transitioned to a paid model for supporting parachains. However, public chains continue to be available for free use. Throughout the second quarter of 2024, we provided a free public data indexing service for Substrate blockchains, allowing interested parties to access indexed data on Substrate Events, Extrinsics, Storage Items, and EVM logs. Below is a list of the public chains we currently support at no cost:
<ul>
<li>polkadot</li>
<li>kusama</li>
<li>asset-hub-kusama</li>
<li>asset-hub-polkadot</li>
<li>bridge-hub-polkadot</li>
<li>collectives-polkadot</li>
<li>rococo</li>
<li>westend-collectives</li>
</ul>
As of Q1 2024, SQD has sunsetted support for Giant Squid, with LimeChain taking over its further development, detailed in the proposal at <a href="treasury/758">https://polkadot.polkassembly.io/treasury/758</a>
B) Contribution
During Q2&rsquo;2024, we made significant contributions to support ink! v5 and address actual use cases that were highly demanded by the community:
<ul>
<li>We provided support for manual finality confirmation in the subsquid/substrate-processor for cases where a chain does not expose finalization details</li>
</ul>
Achievements
Increase in Archival Data Demand and Infrastructure Scaling
During Q2, archival data demand increased approximately ~28,1 times, from 110,6 GiB to 3.095,17 GiB. We addressed the increasing demand for archival data by enhancing our infrastructure's throughput and redundancy through deploying archives to OVHCloud in addition to GCE, while also empowering our maintenance and engineering teams to support the expanded infrastructure effectively.
Mainnet Launch and Decentralization of the SQD Network Enhancing the Polkadot Ecosystem:
In Q2&rsquo;24, we successfully launched the SQD mainnet, a pivotal advancement that significantly strengthens the Polkadot ecosystem's decentralization and resilience. By the end of the quarter, the SQD network comprised 726 Worker Nodes online, securely storing 529 TB of data and serving ~ 9 TB of data a day. This decentralized infrastructure enhances data processing and storage capabilities, ensuring higher security, fault tolerance, and scalability for the Polkadot network.
Advancements in Squid SDK Empowering Polkadot Developers:
<ul>
<li>Manual Finality Confirmation Configuration: Enabled manual configuration of finality confirmation for subsquid/substrate-processor in cases where a parachain does not expose finalization information</li>
</ul>
Cloud API Upgrades:
We upgraded our Cloud API to offer enhanced capabilities that support the growth of the Polkadot ecosystem:
<ul>
<li>Multiple API Tokens Support: Allows for more granular access control and better management of development workflows.</li>
<li>Hasura Integration: Enables more efficient and powerful data querying and manipulation, facilitating the creation of responsive and data-driven applications.</li>
<li>Chain ID and SS58 Prefix support: Enhanced network identification and management for seamless interoperability across Polkadot parachains</li>
</ul>
&nbsp;
<img src="https://i.ibb.co/fzqcqvCf/Screenshot-2025-02-17-120923.png" alt="" width="591" height="369" />
Over the course of Q2 2024:
<ul>
<li>Served a total of 3,505,904,767,634 (~3.19 TiB) of data from the substrate based archives in Q2 2024</li>
<li>Served 301 069 archive requests from substrate based archives in Q2 2024</li>
<li>The highest daily total data transfer recorded for Substrate was 161.646 GiB within a single 24-hour period.</li>
</ul>
Costing
This proposal encompasses the combined costs for running Archives for Polkadot, Kusama, and other public chains, along with the development contributions, amounting to a total of $264,838.09. <a href="https://docs.google.com/spreadsheets/d/1qTLup1JU9XPsklciZDeHVbd-EtP1AvdP4zzI5rm4bSU/edit?gid=1549354589#gid=1549354589">Raw data for Archives can be seen here</a>.
<img src="https://i.ibb.co/9m5K9cKW/Screenshot-2025-02-17-120945.png" alt="" />
<img src="https://i.ibb.co/B2LMJWqw/Screenshot-2025-02-17-120932.png" alt="" />

**Summary**

Proponent: [Subsquid Lab Official](https://polkadot.subscan.io/account/13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE) - 13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE Beneficiary: [Subsquid Lab Official](https://polkadot.subscan.io/account/13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE) \- 13bfKSQXoBn3AMLtZaW6BKv797fqZzsD3PYF6xpJDir3tdoE

Contact Details:

Subsquid Labs GmbH

6300 Zug, Switzerland

Short description: Ongoing development and maintenance costs for public SQD Archives

Archive raw data: [Archive Infrastructure Metrics](https://docs.google.com/spreadsheets/d/1qTLup1JU9XPsklciZDeHVbd-EtP1AvdP4zzI5rm4bSU/edit?gid=1549354589#gid=1549354589) - April, May, June

Requested: $264,838.09

Previous proposals: [https://polkadot.polkassembly.io/referenda/1193](referenda/1193)

**Motivation**

A) Archives

Archives are an important piece of Polkadot and Kusama data infrastructure provided by SQD (formerly Subsquid). They provide access to on-chain data for public chains in the Polkadot ecosystem. They are being used as a data source for Squids and for efficient data exploration and ad-hoc queries.

The Archives, as performant data sources of historical on-chain data, are critical to the operation of backend APIs run by major projects in the Polkadot ecosystem (the list is not exhaustive):  
  

*   Tanssi Network
*   Talisman Wallet
*   Polimec
*   Polkassembly
*   Apillon
*   Hydration
*   Giant Squid API (maintained by LimeChain, see details below)
*   SubWallet
*   FiDi
*   KodaDot
*   RMRK
*   ChainSafe (in particular the Multix multi-sig, as well as other projects)
*   Phala Network
*   Stellaswap
*   Polkascan

Since the first quarter of 2024, SQD has transitioned to a paid model for supporting parachains. However, public chains continue to be available for free use. Throughout the second quarter of 2024, we provided a free public data indexing service for Substrate blockchains, allowing interested parties to access indexed data on Substrate Events, Extrinsics, Storage Items, and EVM logs. Below is a list of the public chains we currently support at no cost:

*   polkadot
*   kusama
*   asset-hub-kusama
*   asset-hub-polkadot
*   bridge-hub-polkadot
*   collectives-polkadot
*   rococo
*   westend-collectives

As of Q1 2024, SQD has sunsetted support for Giant Squid, with LimeChain taking over its further development, detailed in the proposal at [https://polkadot.polkassembly.io/treasury/758](treasury/758)

B) Contribution

During Q2’2024, we made significant contributions to support ink! v5 and address actual use cases that were highly demanded by the community:

*   We provided support for manual finality confirmation in the subsquid/substrate-processor for cases where a chain does not expose finalization details

**Achievements**

**Increase in Archival Data Demand and Infrastructure Scaling**

During Q2, archival data demand increased approximately ~28,1 times, from 110,6 GiB to 3.095,17 GiB. We addressed the increasing demand for archival data by enhancing our infrastructure's throughput and redundancy through deploying archives to OVHCloud in addition to GCE, while also empowering our maintenance and engineering teams to support the expanded infrastructure effectively.

**Mainnet Launch and Decentralization of the SQD Network Enhancing the Polkadot Ecosystem:**

In Q2’24, we successfully launched the SQD mainnet, a pivotal advancement that significantly strengthens the Polkadot ecosystem's decentralization and resilience. By the end of the quarter, the SQD network comprised 726 Worker Nodes online, securely storing 529 TB of data and serving ~ 9 TB of data a day. This decentralized infrastructure enhances data processing and storage capabilities, ensuring higher security, fault tolerance, and scalability for the Polkadot network.

**Advancements in Squid SDK Empowering Polkadot Developers:**

*   Manual Finality Confirmation Configuration: Enabled manual configuration of finality confirmation for subsquid/substrate-processor in cases where a parachain does not expose finalization information

**Cloud API Upgrades:**

We upgraded our Cloud API to offer enhanced capabilities that support the growth of the Polkadot ecosystem:

*   **Multiple API Tokens Support**: Allows for more granular access control and better management of development workflows.
*   **Hasura Integration**: Enables more efficient and powerful data querying and manipulation, facilitating the creation of responsive and data-driven applications.
*   **Chain ID and SS58 Prefix support**: Enhanced network identification and management for seamless interoperability across Polkadot parachains

![](https://i.ibb.co/fzqcqvCf/Screenshot-2025-02-17-120923.png)

Over the course of Q2 2024:

*   Served a total of 3,505,904,767,634 (~3.19 TiB) of data from the substrate based archives in Q2 2024
*   Served 301 069 archive requests from substrate based archives in Q2 2024
*   The highest daily total data transfer recorded for Substrate was 161.646 GiB within a single 24-hour period.

**Costing**

This proposal encompasses the combined costs for running Archives for Polkadot, Kusama, and other public chains, along with the development contributions, amounting to a total of $264,838.09. [Raw data for Archives can be seen here](https://docs.google.com/spreadsheets/d/1qTLup1JU9XPsklciZDeHVbd-EtP1AvdP4zzI5rm4bSU/edit?gid=1549354589#gid=1549354589).

![](https://i.ibb.co/9m5K9cKW/Screenshot-2025-02-17-120945.png)

![](https://i.ibb.co/B2LMJWqw/Screenshot-2025-02-17-120932.png)

Propose and approve a spend of treasury funds.

## Dispatch Origin

Must be [`Config::SpendOrigin`] with the `Success` value being at least
`amount` of `asset_kind` in the native asset. The amount of `asset_kind` is converted
for assertion using the [`Config::BalanceConverter`].

## Details

Create an approved spend for transferring a specific `amount` of `asset_kind` to a
designated beneficiary. The spend must be claimed using the `payout` dispatchable within
the [`Config::PayoutPeriod`].

### Parameters
- `asset_kind`: An indicator of the specific asset class to be spent.
- `amount`: The amount to be transferred from the treasury to the `beneficiary`.
- `beneficiary`: The beneficiary of the spend.
- `valid_from`: The block number from which the spend can be claimed. It can refer to
  the past if the resulting spend has not yet expired according to the
  [`Config::PayoutPeriod`]. If `None`, the spend can be claimed immediately after
  approval.

## Events

Emits [`Event::AssetSpendApproved`] if successful.

- **Problem Statement:** 
  - Ongoing development and maintenance costs for public SQD Archives.

- **Significance:** 
  - Archives are crucial for providing on-chain data in the Polkadot ecosystem, supporting major projects like Tanssi Network, Talisman Wallet, and more.

- **Proposed Solution:** 
  - Requesting $264,838.09 for running Archives for Polkadot, Kusama, and other public chains, including development contributions.

- **Expected Outcomes:** 
  - Enhanced data infrastructure, increased archival data demand, decentralization of the SQD network, and advancements in Squid SDK to empower Polkadot developers.

#1447 SQD (fka Subsquid) - Public data indexing Infrastructure for Polkadot and Kusama (Q2 2024)

No Active Proposals