**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, 6302 Zug, Switzerland - mf@subsquid.io


**Short description:** Ongoing development and maintenance costs for public Subsquid Archives and the Giant Squid API


**Archive raw data:** [Archive Infrastructure Metrics - January, February, March](https://docs.google.com/spreadsheets/d/e/2PACX-1vRW2UJeY6qR2RiCFfBZ70EZ3i45sc03kizxwgXrJdIqfkn6ygDkRDVNElXmzP3bK9ENB5weUyFM9pvP/pubhtml)

**Giant Squid raw data:** [Giant Squid Infrastructure Metrics - January, February, March](https://docs.google.com/spreadsheets/d/e/2PACX-1vRrG2wW7XXcsfgY-AGp-luHvhu5H-uQWd7xcli84celv42g9SctqA6JOMdZOYJCf_3hBvh3VFIf_GfG/pubhtml)

**Requested DOT:** 37196.65 DOT + 12683.35 DOT **= 49880.0 DOT =  $ 224,460.03**

**Previous proposals:** https://kusama.subsquare.io/treasury/proposal/280

### Motivation


**A) Archives**

Archives are an important piece of Polkadot and Kusama data infrastructure provided by Subsquid. They provide access to on-chain data in GraphQL format for all major parachains on Kusama and Polkadot, with more chains getting support as the ecosystem grows. They are being used as a data source for [Squids](https://app.subsquid.io/squids) and for efficient data exploration and ad-hoc queries. An up-to-date list of Archives is kept in a public [Archive Registry](https://github.com/subsquid/archive-registry/blob/main/archives.json).


All archives can be accessed and queried via an web intuitive GraphiQL interface and are often used as developer friendly replacement of a block explorer.


For example, here’s a query for the last ten transfers on Kusama blockchain run against the [Kusama Archive endpoint](https://kusama.explorer.subsquid.io/graphql).

![](https://lh3.googleusercontent.com/u/0/docs/ADP-6oF28QRWrAQx4x6nJNPA_fSg4c73ukxfq-ATwlJOaeMkFcveUEN3abJyXlkg0M5tgxMSU9_hY00ovl7JB0PIaZV25wlpNy9QiYTah8HYt1QcfnmUiLPz61vWbAjWe6yEsIrl_dVS68yi_skDsIhpTHtk0NqWhZ2HakawVgzv13cB0Zz2GFF1uD4WduGKh1cT71w21kf8XhbV9NU8bYkYjJht4UPz5CEmrc-J8V-1g6zjdMK0TWcbRtZE469tyZurbsR6hrxtz3AgcT-yBnIaFSR1RjuDt9cU4ON1EuhAYFfbt_hxKS5eJAmkJnoRN9b98lm3z-ENAW4F4lGD4eaefmLjW0Ni96jVwyx2-0qpj_FCU8M4Jv-ADArSOogQU6E4WMjJ0IXO0G0wvqcpJritTjnVfaMg1BWVP4coevffowL396wjU7-php3xXPT1cYJHRi9hob4LQQUYXeBz_oGA2mcZ-VTw8fonH_Q5H3MWRqaaPttS618JzrkVaeEGScCMF9qJ5tMwBeMFQ9rcG9njN1frHKgaco97oSsZsSygw-OsuCAyBta90ZmHWeHo3ZJqtRNBdE33rEzJlBvlVo4uCVbMnjE_64s5bz2-OQczY8bEdjD6v7g4awrLXZXwx1zdRnHkc5TZsnG65LhbYXzLus-n-drRCSuk-67GihaJrMul5IoKRgHaUJekuQVaFNnL4YhKAGOotb7tvvNCLdDtpfnwZdg_bhGrALNf8b4hGBfJL1_cHPeTeKj2IrsCBVz1cm7EQp6fx5VTXD3oJnwLkx09vmauHqlftCgqfzYjSvL5E2yWRHI5NZa5igjdV9UNPUvj_LB4-NvVx_RCofmUNjC62qj8AUYJH8z7RhIvGmpvpdesVlFgFqlB-VMhPd8emdb6l1089w7jrc3bODqhQuNtEbM)


Over first Quarter of 2023 we've provided a free public data indexing service for ~94 Substrate blockchains (some archives have been dismissed, new ones have been added), so that everyone interested in the projects can publicly access indexed data on Substrate Events, Extrinsics, Storage Items and EVM logs. Here are projects (parachains and mainnets aiming for future parachains slots) we currently support:

- kusama
- polkadot
- moonbase
- gemini_2a_testnet
- rococo
- khala
- astar
- moonriver
- crust
- moonbeam
- karura
- equilibrium
- shiden
- kilt
- bifrost
- statemine
- aleph_zero
- heiko
- acala
- robonomics
- aleph_zero_testnet
- calamari
- kintsugi
- parallel
- shibuya
- phala
- sora
- basilisk
- statemint
- interlay
- litmus
- origin_trail
- bitcountry_pioneer
- integritee
- clover
- picasso
- altair
- bifrost_polkadot
- centrifuge
- hydradx
- subsocial
- efinity
- tanganika
- t0rn
- cere
- litentry
- composable
- bajun
- invarch_tinkernet
- amplitude
- imbue
- foucoco
- phala
- dorafactory
- pichiu
- kabocha
- darwinia
- gmordie
- snow
- frequency_testnet
- peaq
- elysium_testnet
- gear_testnet
- reef
- collectives
- frequency
- pangolin
- myriad
- elysium
- ternoa
- soonsocial
- crab
- myriad_testnet
- polkadex
- kylin
- reef_testnet
- tidechain
- pendulum
- hashed
- joystream
- gear_testnet
- darwinia_2
- mangata_x
- mangata
- polymesh
- nodle
- reef_testnet
- automata
- lagoon
- crust_shadow
- agung
- kico
- gemini_3a_testnet
- mars


**B) Giant Squid**
Giant Squid is a set of open-source GraphQL APIs built with Squid SDK and maintained by Subsquid Labs. The APIs cover the most commonly used data for Pokadot, Kusama and a growing list of major parachains and is used by explorers (such as [Calamar](https://calamar.app/)) and wallets (e.g. [SubWallet](https://www.subwallet.app/)).

The Giant Squid currently consists of two families of endpoints outlined below. The API endpoints for each network and the current status are available at the [Status page](https://docs.subsquid.io/giant-squid-api/statuses/).

**Explorer API. The endpoint URLs follow the convention https://squid.subsquid.io/gs-explorer-${network}/graphql. Support queries on:**
- Blocks
- Events
- Extrinsics
- Calls


**Statistics API. The endpoint URLs follow the convention https://squid.subsquid.io/gs-stats-${network}/graphql. Support queries on:**
- Validator/Collator data
- Account balances
- Staking statistics
- Nomination pools statistics
- Transfers statistics
- Extrinsic statistics

### Achievements

- Launched Giant Squid as a public API service for the community to explore relay and parachain statistics
- Powering ≈ 360 projects in Q1 2023 ( ≈ 500 as of May 2023) including substrate and evm
- Deployed new archives, expanding the list of available networks to 95 (increasing by 200%)

### Statistics and data

![](https://lh3.googleusercontent.com/u/0/docs/ADP-6oE4gjNTMvIJzUcwpsoOS3QhjQOo83ctejXjAysetgejrg1lhMFTJg83864WWJ2El1LC1quSf3qiGLkLTacFV4DksQDzwPOspS8WX-EUrHYfFLrdnmyO1l3n9GoE0ODP1X79e9sKjWOZceqGCrv1P8qyA0Ck7UhCyhRYe0zo0OPCytDffBHmjJywd8t_v8eR5WGw6CC1mo72GC64CY-FolQyFJjTCg8lHTRcwkvDGOqeJy4Zy2n8IdFusb2Ihmp4rALBxWcYbTwIBQZpJkVUvbga6MRIMZq6gABzVuYYki1vwQvHiOltaYJ9Kn_Kcp2GVdEXkEASyfrVpzqaIv2q5w1Y1_3ucUC49n9GeSMcMDVvNcC8tZsbq_xGK8gnKQq02hYaqxUD9KOKGKH8n9GltLdvn-8fij-SmC-jPUlUpy9kwr3TGUrXGU7FMelL3qVYYFCmDQ0J-keg7_Hll4UDg3mn0lMhK5AdY6KkNmV-9DUe8fGcoD_wJebDLsMlM0IbNgDmgpuO7GUWqyXiQ_adbcVoUnnlq9s1ZoHsFVCJvhugIF_kQWIDXDToFG7rRsgv-9fj6vVxUdxY1peBWpYHi-F6zUxynuxDh71L9K3xN-yKzurJBgwdpYvxal4WKKPrtuQZF5P2QCswlfVjAsQFx3BFNfT2G6fGA-pu-AarMDovEYy0lZzrN1TxCDeV3gyUoNDDF16VmTLCoe5XpHxM9-6Z7whEoKYg0BiQfCPgksZwdhKqZg3ICTank0XoGoHZ29dRupaDdxPURzA9fRsgfbh4Pe2J1VVA_1kMIbwmL9HhIo5mpeFSg3vsYVHrsH56qN08-VTUJmdDXJUFRPvcCG-mlH0h94Ez5Rfk_-a0Gr0ly-Q1cUK4AX5SrQzkW2f675xXaEIdO8bphdIJ5Cwz1Oya_do)


![](https://lh3.googleusercontent.com/u/0/docs/ADP-6oHcKHUirSow9ztILPzv7zpT4gfUbiCQkm4lhyF2D4rkv6n17Y1MpD2vgyZFkkm0ABoW50bnxvIzjcozdsEOsq931QV6ZU3v3xk78-EbjH9N58kcgjAFBfQw2ZH5KljU6mU1e4tOTgV-BYq6mbmCTAvpQBnAz9gFKz9HVNwufXEMfo9NWxAv3jCd86AlxC65ZSV-nVBkxc7oypDMXBTCTu92bNJwIeBYvnEIbrL2GDoehA6QqNtuELOfcEh0qDIVmaKC_6jPojGEf4SAL6x8gPleUPxzKuF4OEhmRFUSVJQ0nKKnz85GO4D5aDa1_m9TaHsBPduI6acO8BNTn3dO8sTsKxVUmp3PLs_XDr4GR-OfGNFRUcSYoFUWwWit9wXGFhFRoRKZTOFSmIcPuQ6OgxB4iX6-C6dKvHiU5DAxbQT6Wold-LuxkImXqNIH9DqmS9VihqE3lhghVYq3EtYoZlx_M6uuEqVIegDKLv9lk6tzMptw0cVyypXCtts-l0Rd9lnFNF493PhBcuzOo3Pqge0tI27B00K-bX9fMGcJ21EHkZo139IxsUYn8n5T9yXiUGARQVCg55Xt5X9tIwPEcc2OPj1QEsWEGp4yY59qm33-x9lkFE918FkceS-aZee5p-s6VL88_J-1APszBWHtFYg55S8-UAfWKYlhXpQ8Y26ZL3WEoNUFUv-UQpPJ65hwfjbdc4K6_vyQ_VYMAEdgLV3u9G2wkTyQTs005dbWGGYxBFI7ga-eTohLmQ3E0iBTYsyOG6YMOWVsyz8U3IQWKCZ3x_lO8GBcjX37qvLhgZ1sjRumjA8-9XI1CsKU3BfGMlm2ASYlkvtnWzAW2drTKyCiRbcFEwjs6d1NXBywyJ-Ql-RCdEZuawc3REVBvBFDssO-EdRfvixZRojAiYZl1JWIvMc)

**Over the course of Q1 2023:**


- Served a total of 162,509,254.3 (~162.5 million) queries to the substrate based archives in Q1 2023
- Served ~54m monthly archive requests for substrate based archives and ~ 400m monthly archive requests in total  including EVM Archives
- The highest daily total responses have been 2.3m in a single 24 hour period for substrate and 12.3m including EVM Archives
- The daily queries confirm a growing trend, only partly due to the deployment of new Archives (which initially are not very busy)



Giant Squid is a new service, and has been launched in mid-January, here are two charts showing its quick adoption by the community, as an index of its success:
 

![](https://lh3.googleusercontent.com/u/0/docs/ADP-6oE6P3xTCMJPooMU0MvARg2aj2tyo6nFO1Trp6VLFMJUjWyPpRQCa863ecVmszBYwCTubrai3-qcKjjbyJlp9T9KEwUB9SjEG_S5iSCxWgiO7PPpuB8rou4z7r6BGOVS7CUVOnekq68fCxgZGcvaAhjYG-tf4-L3ywlnsMvMaSVVtorlJL8payuS3uhGXSnQyR0fYJivtevwnON5ybqqKos3iwBJswvjiEO8Oq7eYw9B6v283IH0x-AuHJdCEQitMc-bUFXDlNOwSn-UROoZ7gs9PN_v-cbjAoIKK2DQ4_9d4k5Bng9UXzQGJWz3RWm2GVv_L1iTBoszQAxLyxWKh_KGMClpv1ny7lYnUpIQQXaieG5AxofDBI4F1Wf1YcJtKoVmVrXOntW1gn4SVDmhVMXIargBQ2lTRHIaFpAJu9SLWDEUrdDVJeaCa-tHW4_GYZPpu9XTEnDIid8Q4e4zOxlyQuNF4Em4Ahg7hHuRreZ0LJ7FYTYCLCYLbe5M1h9p91nzBEyzwuzSHBuMVZL1jy9kdL3c5kODbkYFyl03UjiLze0K5VQN-H3YjmfJO60jVRg91u0sHn9Wh2-_Ed_j_BCrAJINxeNsVg_0rR2bl0WglUGlHjuvBqtJDqp6BI-hDZgaCVIB5shxJX7E9r2sC8NtaTudIxkfMgxHRmpllFsZ5fnZLkuWcwgPh3XRADfJjtdrI_gupEtiMAac4QxezN5NiTDUx2j0TUWTdGOTeCdwhwSKflouslRzQROLh8nwyB3Y9m3mJOkhHf9s9DS3163Qu82LNeNocue2bXfWzNHiCUTIJnorQf8DK-juX_c2iC-rXAl3wLTeYrbKOD_O4ShcGrrZFibhjlOZkHak0nvt160CSG04x3VJUoTLBVRnYAP4Yy401vgiLqKq1jHIBhv-QHs)


![](https://lh3.googleusercontent.com/u/0/docs/ADP-6oHjyacO1spY-9wlFrIDas5cFnC1wLmsFP4_ioJYwM5GcfTDH2zq1DaIlolqgkUKzYueUjWbbZw1JYcpUAuIlbM4P44q3z-VNnfaJjDnC66Q4ESiqzSCDt0rqtO-6I5YDQW56QttazehxFVxj_VC1eeKYYHjDlapyN1pykcYbG8ulFCj0hZJko84zQFU5SuiYIrwY_YGp3bUPO3_o2iuygXD7oCLSgOCbpjTXlQBPK4SwFFtIDWB5hadunJoA7dYMJ-iVvO4RCn-329h6CXaVea8TRte_XayYfndo4MFAl8caJYFqBb-Hln7Y3bM8Osf22o9LBJMg1Mr7pDJkKPEcnTLU1KrgnxOQLPIIzvSW-VLss11CuVTXXNxYUGN_bECPqp93yHkNTNeAQlL4AdS5is30AFpIrKU6fMZmHTlkyR5YStSg_UiJ-8e-ijgVTUx-F5CG7gp8092K-XCoeq-G4OBHHZTLkDAC1Gv_UZymwL4_kIg5JD-2SzENgD7P5WepX9ndV-xxYb_j_1qccvlZLQEiJuJJ3bkO-rp0OmPuy3YnXfNee951bUKqdCEdLDEFqtIxXwea82NUH4IBJwlwSgou4EP4pwVX6zhbrpdvS2gbTucFzEtDsntnjLFz5_ufEWiPtw782og5etoB8lWa9AyP4JqmtrXxmKgbb-AbKGPhbzIPq0xs8dRBOi7Du1RQbYWGpks3Mal7s8obHm1qz5AlGX3rtvvcXoZJ2GPnGwDpiAQkyxxCkLb9pnNtCJGAGw8z-po7sKuhWVXTGDUvHcpEi_gQJwq7CEINcMoOvU5wBCLubH7CafpfRuJp8zw8XZi4K7NaxLegPiGHmL0ZvIJOerE-xdPmtuO97XZaXAdMz8dtGzoT2DwOIQLaYROKk80j2amgMle05Jf0_UBlSSVnsg)

### Costing

This proposal includes the combined costs for running Giant Squid and Archives for Polkadot, Kusama and their Parachains,which amounts to a total of  **49880.0 DOT**.  Raw data for Archives can be seen [here.](https://docs.google.com/spreadsheets/d/e/2PACX-1vRW2UJeY6qR2RiCFfBZ70EZ3i45sc03kizxwgXrJdIqfkn6ygDkRDVNElXmzP3bK9ENB5weUyFM9pvP/pubhtml#) Raw data for Giant Squid can be seen [here](https://docs.google.com/spreadsheets/d/e/2PACX-1vRrG2wW7XXcsfgY-AGp-luHvhu5H-uQWd7xcli84celv42g9SctqA6JOMdZOYJCf_3hBvh3VFIf_GfG/pubhtml).

The proposal is submitted towards the Polkadot treasury. Here is a summary of the running costs for Archives, in a tabular format:

![](https://lh5.googleusercontent.com/hMGw1_fcQS-UVysIvwl15gChgc-hELoOM4qZ_lemjXNh7tLVHhKcknj_a8VOoj9lucyyrDP0B0UPqImxn6JlkaU1l-uwHgP19V35xvZ7vYHKlaZ39Lv8MtmDCy6QPXrnsmVZFxgEBu7GiiPNluXijNc)


Giant Squid running costs:

![](https://lh5.googleusercontent.com/FG5Q6qTSErhhNOMTkS4GrEgzzk9TBCqmIsb0tJb-32ez62d1wAA9kNGszf2tbDFDgFR5uMjVsAOnprgH0Yo_YGivVLHky3Rg32eU4Zw8QsaC5e1xGHhFi-ac18Co-Kmw9QEH-z5cLEWi4FmMunMQiaw)

You can read the full report[ here](https://docs.google.com/document/d/e/2PACX-1vTa-xOKI7UdGXcTDybuTekej7LqAjqXBqPPrctJv3FfF9GO5xTblUB5FTa0in6MNj68JFLj-NRMJ6lI/pub).




The proposal from Subsquid Lab Official outlines ongoing development and maintenance costs for public Subsquid Archives and the Giant Squid API. It covers the provision of archives, a crucial component of Polkadot and Kusama data infrastructure, offering access to on-chain data for various parachains. Additionally, the Giant Squid API provides GraphQL endpoints for exploring relay and parachain statistics, supporting a wide range of projects. The proposal seeks funding for the continued operation and expansion of these services. Overall, it aims to enhance accessibility and usability of on-chain data for developers and users within the Polkadot and Kusama ecosystems.

Polkadot's sponsorship of the two-day Soulbound event during the Bali Blockchain Summit in August demonstrated significant benefits for Polkadot, as evidenced by the aftermovie and other success metrics.

The Bali Polkadot community organized 9 bi-weekly BlockTalk meet-ups, engaging over 270 participants, to share updates on Polkadot, the crypto market, and Blockchain and Web3 concepts.

Establishment of the Polkadot Sanctuary in Bali, providing a rent-free space as a central hub for Polkadot enthusiasts to access resources and foster collaboration.

Five Polkadot Ambassador Candidates have been onboarded to expand Polkadot's network and drive adoption in Bali, with one candidate already becoming a fully-fledged ambassador.

Efforts to persuade the local government to adopt Substrate and utilize the Polkadot ecosystem have been fruitful, creating job opportunities for substrate developers in the region.

The Polkadot community successfully hosted the Polkadot Decoded Viewing Party, drawing 70 attendees and showcasing the technological advancements and possibilities of Polkadot, igniting interest within the local blockchain community.

The Polkadot Sanctuary brand has been established across social media platforms, including Twitter and Telegram, with plans for website reconstruction by year-end.

amount

beneficiary

- Problem Statement: The Polkadot and Kusama data infrastructure provided by Subsquid Labs, including the Subsquid Archives and the Giant Squid API, require ongoing development and maintenance. The intended audience includes developers and users of these services.
- Significance: These services are crucial for accessing on-chain data in GraphQL format for all major parachains on Kusama and Polkadot. They are used as a data source for Squids and for efficient data exploration and ad-hoc queries.
- Proposed Solution: The proposal requests a total of 49880.0 DOT ($224,460.03) from the Polkadot treasury to cover the combined costs for running Giant Squid and Archives for Polkadot, Kusama, and their Parachains.
- Expected Outcomes: The funding will ensure the continued operation and development of these services, which served a total of 162.5 million queries to the substrate-based archives in Q1 2023 and are used by approximately 500 projects as of May 2023.

#15 Subsquid - Public data indexing Infrastructure for Polkadot and Kusama (Q1 2023)

No Active Proposals