Type:
development
RETROACTIVE

Amount Requested:

99028.00 DOT

501286.32$

Proposed on:
Nov. 9, 2023
Proposal Awarded on:
None
Expected Delivery
None
Actual Delivery:
None

Status:

completed

substrate-etl Retroactive funding: Q3+Q4 2022-Q1+Q2 2023

by Sourabh Niyogi

Summary:

The substrate-etl index results in two large datasets (crypto_polkadot and crypto_kusama) covering the 2 relay chains and over 70 parachains. This represents Polkadot/Kusama alongside other Web3 ecosystems and supports complex large scale analyses with SQL using BigQuery's lightning-fast query performance on extremely large datasets. Having substrate-etl enables Dune-like analytics to guide business intelligence, inform engineering decision making, and showcase ecosystem growth. Power users include Parity Data (led by Karim Jedda and Pavla Mijic), Subwallet/DotInsights, Web3metrics, Dolpha.com, ChainViz and many data analysts within parachains and outside the ecosystem.

Current Progress and Comments:

A retroactive proposal for one of the necessary components as it’s the core of most of the Polkadot blockchain analytics which is readily available for free. It passed almost unanimously, the only votes against happened due to the fact that it had no verified identity at the beginning of the referendum.