Colorful Notion successfully onboarded the Polkadot ecosystem into Dune under [<u>OpenGov 366</u>](https://polkadot.polkassembly.io/referenda/366) and continued BigQuery support, covering 8 quarters of activity (Q3 2023-Q2 2025).  This proposal is a renewal covering 3 additional quarters (Q3 2025 - Q1 2026), to ensure that Polkadot continues to be ingested and maintained on Dune and Google BigQuery. &#x20;

This supports:

* supporting data engineering of key migrations of Relay Chain to Polkadot Hub + Kusama Hub, to be executed in July+August
* supporting key Polkadot ecosystem data analysts maintaining existing dashboards and building new dashboards supporting new Polkadot narratives as requested by the community for top 12 parachains and Polkadot Hub

You can see much of our work in the **Highlighted Tweets** below, as well as in on the [Polkadot wiki](https://wiki.polkadot.network/general/dashboards/dune-analytics/).  

Full proposal [here](https://docs.google.com/document/d/1dLbwJvhZ4IYIh0gQT-5D63uc5NzCLDWMr3jbEOUtCFI/edit?tab=t.0#heading=h.v6is2ta0txr1).  &#x20;

Our costs are divided 5/6 Polkadot ($609.8K) and 1/6 Kusama (9,055 KSM).

Whereas the previous year focussed on the heavy workload of onboarding the relay chain, system chains and all Polkadot parachains, the next 9 months will be focussed (1) the key migration of both the Kusama and Polkadot relay chains into Kusama Hub and Polkadot Hub and (2) the top 1 parachains.  &#x20;

We aim to continue showcasing our results for the remainder of 2025 going into early 2026, with highlighted tweets from our past work shown below.


**Highlighted Tweets**
[https://x.com/Polkadot/status/1864626032218620265](https://x.com/Polkadot/status/1864626032218620265) TVL on Polkadot DEX @hydration\_net reaches ATH ✅\_

[https://x.com/Polkadot/status/1866395426695622914](https://x.com/Polkadot/status/1866395426695622914) *NeuroWeb adds 2.4M Knowledge Assets in November, another ATH. @NeuroWebAI is an AI blockchain secured by Polkadot, designed to incentivize knowledge creation & connectivity through Knowledge Mining. Miners get rewarded for contributing knowledge and trusted data to the AI.*

[https://x.com/Polkadot/status/1868621889419219045](https://x.com/Polkadot/status/1868621889419219045) *Utilization of @Bifrost Liquid Staked DOT (vDOT) is at an ATH. vDOT allows holders to participate in Polkadot-based DeFi, while still collecting staking rewards.*

[https://x.com/Polkadot/status/1870121359080133039](https://x.com/Polkadot/status/1870121359080133039) *Extrinsics on Phala Network → ATH 👀 Phala is an L1 secured by Polkadot focusing on privacy-preserving computation. Phala’s AI agents autonomously perform tasks like monitoring data, triggering smart contracts, and interacting w/ dapps. Follow @phalanetwork to learn more ✅*

\_[https://x.com/Polkadot/status/1881633036443455685](https://x.com/Polkadot/status/1881633036443455685) Stablecoin Adoption on Polkadot → ATH USDC + UDST = $114,000,000 Parachains with the most? 1️⃣ AssetHub 2️⃣ @hydration\_net 3️⃣ @MoonbeamNetwork

[https://x.com/Polkadot/status/1846578533784523246](https://x.com/Polkadot/status/1846578533784523246) What they said: "DeFi is ded" What happened: "StellaSwap's incentive campaign goes supernova" TVL of major pairs, including xcUSDC and xcUSDT, have reached ATH @StellaSwap

[https://x.com/Polkadot/status/1849056523214819352](https://x.com/Polkadot/status/1849056523214819352) Mythical Games seamlessly integrates NFTs into titles like NFL Rivals, allowing players to own & trade digital assets like skins—without even knowing they’re NFTs. @EnterTheMythos has issued, burned or transferred 12,000,000+ NFTs since migrating from Ethereum to Polkadot 👀

[https://x.com/Polkadot/status/1850891487774490847](https://x.com/Polkadot/status/1850891487774490847) Liquid Staked DOT on Bifrost (vDOT) continues to expand across the ecosystem, showcasing Polkadot's interoperability. vDOT holders can participate in Polkadot-based DeFi, while still collecting staking rewards. @Bifrost

[https://x.com/Polkadot/status/1851914236215107660](https://x.com/Polkadot/status/1851914236215107660) Knowledge Assets added to @NeuroWebAI reach a record high. What are Knowledge Assets? A container that can describe any digital or physical object, abstract concept, or really any "thing" - here with information integrity & ownership supported by blockchain & decentralized.

[https://x.com/Polkadot/status/1831626673499906106](https://x.com/Polkadot/status/1831626673499906106)

[https://x.com/Polkadot/status/1870121359080133039](https://x.com/Polkadot/status/1870121359080133039) Month by month, participation in Polkadot OpenGov continues to rise 💪 Chart: the number of votes cast (without conviction) by month.

[https://x.com/Polkadot/status/1839626708577657151](https://x.com/Polkadot/status/1839626708577657151) The number of Tokenized T-Bills in the @centrifuge Liquid Treasury Fund continues to grow… So what? T-Bills are backed by the government. Now, they’re on-chain. No banks, no brokers. Just direct access through the decentralized blockchain. Centrifuge, secured by Polkadot.

[https://x.com/filippoweb3/status/1888138037223141839](https://x.com/filippoweb3/status/1888138037223141839) The DEX @hydration\_net is approaching 1B in cumulative volume since Feb 2024 👀 source @Dune\_

[https://x.com/Funkmeister380/status/1886043801333940662](https://x.com/Funkmeister380/status/1886043801333940662) *@colorfulnotion analysed @wormhole bridging into @MoonbeamNetwork -- surprisingly large number of chains, mostly USDT and USDC*

[https://x.com/yaronski/status/1872071494429503918](https://x.com/yaronski/status/1872071494429503918) *bar chart comparison of the 7 referenda's results queried for conviction-free GLMR support on @Dune thanks to @colorfulnotion*

[https://x.com/colorfulnotion/status/1860922090423267666](https://x.com/colorfulnotion/status/1860922090423267666) *@enterthemythos really does have almost 100K MAUs doing NFTs, 14K MAUs doing the Marketplace Verified on @dune -- check it out*

[https://dune.com/substrate/mythos](https://dune.com/substrate/mythos)** [https://x.com/BillLaboon/status/1838866222403731951](https://x.com/BillLaboon/status/1838866222403731951) *The month is not quite over, but assuming no major changes in the next week, Polkadot Treasury spending (light blue bar) for September is at its lowest level of 2024 and net outflow (yellow line) is close to breakeven.*

[https://x.com/Polkadot/status/1877668081276699003](https://x.com/Polkadot/status/1877668081276699003) *No fluff, just data. Check the Polkadot 2024 Dashboard on @Dune for the answer.* [https://dune.com/substrate/2024](https://dune.com/substrate/2024) */ by @colorfulnotion*

[https://x.com/TheKusamarian/status/1829836537439387791](https://x.com/TheKusamarian/status/1829836537439387791) *How much MYTH will you be Airdropped? →* [https://dune.com/substrate/mythos-airdrop-v4](https://dune.com/substrate/mythos-airdrop-v4) *@LeemoXD ↯*

[https://x.com/hydration\_net/status/1850949746372067542](https://x.com/hydration_net/status/1850949746372067542) *vDOT much hydrated The upcoming launch of our Money Market will deliver the next piece in the DeFi lego*

[https://x.com/replghost/status/1841463066850205785](https://x.com/replghost/status/1841463066850205785) *Amazing! The work of a dedicated @Polkadot community member to take the initiative to bring clarity and transparency to the ecosystem. We need people to step up like this, see a problem and solve it. And of course, the dashboard is made possible by the Dune integration completed earlier this year, thanks to @colorfulnotion*

[https://x.com/Polkadot/status/1840861209341673944](https://x.com/Polkadot/status/1840861209341673944) *Have you checked your wallet lately? 👀 Starting today, 10M Myth Tokens will be distributed to over 450K DOT wallets, as approved by the community in 🗳️ OpenGov Ref 643.*

[https://x.com/Polkadot/status/1824015053542035818](https://x.com/Polkadot/status/1824015053542035818) *Interconnectivity between Polkadot parachains continues to grow… Open HRMP Channels ⬆️ HRMP is a protocol that enables and secures cross-chain communication on Polkadot and passes all messages via the Relay Chain 🔄 Polkadot enables an interoperable, and scalable multichain ecosystem, laying the groundwork for the future of Web3*

[https://x.com/colorfulnotion/status/1821897712473927967](https://x.com/colorfulnotion/status/1821897712473927967) *Holy 1337 Batman! @enterthemythos is NAILING it with over 8K active users in a day doing real NFT action. This is NOT hype, check it out:* [https://dune.com/substrate/mythos](https://dune.com/substrate/mythos) *The first charts we've built about a @polkadot parachain that makes us smile about GROWTH. 😀😍🥰*

[https://x.com/Polkadot/status/1821495038104195210](https://x.com/Polkadot/status/1821495038104195210) *👀 what do you see in this chart? …right answers only…*

\_[https://x.com/Polkadot/status/1818539332233277585](https://x.com/Polkadot/status/1818539332233277585) Hydration's Omnipool TVL is at an ATH after tripling in recent months 👀 Omnipool combines all assets in a single pool to allow users to provide only one asset to earn yield while also exponentially enhancing efficiency 🙌 Trade at size, with ease @hydration\_net 🌊

[https://x.com/CryptoCappex/status/1814235269496787163](https://x.com/CryptoCappex/status/1814235269496787163) Delegates from the first #Polkadot DV cohort voted on average in 67% of all completed OpenGov referendums. ChaosDAO \~100% Saxemberg and Kukabi >75% The average participation of the second cohort is 61% in the completed referendums, should it be higher? 🗳️

[https://x.com/0xLurpis/status/1813784553909314003](https://x.com/0xLurpis/status/1813784553909314003) . @Bifrost just spent 23 $KSM to purchase a coretime and renew the @kusamanetwork slot for 28 days for the first time. Based on the price of $KSM, securing the parachain on Kusama for one month only costs $524. Even in the lowest-cost month in 2024, the average cost of @ethereum 's L2 rollup was $38k, which is 73x higher than the shared security cost of Kusama. Data Source: [https://dune.com/queries/2863300/4788854](https://dune.com/queries/2863300/4788854)

[https://x.com/colorfulnotion/status/1808927242803892637](https://x.com/colorfulnotion/status/1808927242803892637) Holy Snowbridge-is-working Batman! Someone sent $2,186,127 (695 ETH) from @ethereum to @polkadot Asset Hub (tx) @colorfulnotion's Snowbridge dashboard: [https://dune.com/substrate/snowbridge](https://dune.com/substrate/snowbridge) Move your ETH assets to Polkadot here: [https://app.snowbridge.network](https://app.snowbridge.network) and join the WETH top holders on Polkadot Asset Hub: [https://assethub-polkadot.subscan.io/foreign\_assets/f1846f14a52715c2a09df52ef8f077c52977dcfd](https://assethub-polkadot.subscan.io/foreign_assets/f1846f14a52715c2a09df52ef8f077c52977dcfd) and beyond =)

[https://x.com/filippoweb3/status/1808490340912926806](https://x.com/filippoweb3/status/1808490340912926806) Hey, Polkadot has 10 users, it's a dead chain🤔 Me👇 Polkadot secured 35 M transactions in June 2024 alone and 300 M transactions in the past year across 50 L1 chains Source @DuneAnalytics

[https://x.com/filippoweb3/status/1805865609881698305](https://x.com/filippoweb3/status/1805865609881698305) The Polkadot Wiki has a new section about @DuneAnalytics , explore Polkadot's data👇 Thanks to @colorfulnotion for the integration

[https://x.com/AstarNetwork/status/1796291000928731174](https://x.com/AstarNetwork/status/1796291000928731174) Track your favourite dApps and current staking rewards on the new @DuneAnalytics dashboard! 🗳️ The next voting period for dApp staking starts in 15 days!

[https://x.com/marvin\_tong/status/1791859775690649709](https://x.com/marvin_tong/status/1791859775690649709) "I heard Phala is the OG in computing and coprocessors, but is it a bit SPAMMY? 🤔" 🙄 All books are open, verify by yourself: [https://dune.com/substrate/phala](https://dune.com/substrate/phala)

[https://x.com/StellaSwap/status/1785972721870094770](https://x.com/StellaSwap/status/1785972721870094770) Our public dashboard on @DuneAnalytics is LIVE! 🎉 You can now access key metrics on StellaSwap on Dune that include; ⭐️ Daily Vols. ⭐️ Pool Breakdown ⭐️ Swap Volume Accounts ⭐️ Active Accounts ⭐️ Swap Txn ⭐️ Unique Accounts 👉 [https://dune.com/substrate/stellaswap](https://dune.com/substrate/stellaswap) Special thanks to @Funkmeister380 @colorfulnotion 🔥

 [https://x.com/0xTaylor\_/status/1780638978749907352](https://x.com/0xTaylor_/status/1780638978749907352) $MYTH airdrop just got a LOT better, LFG!!! Great work @johnwastaken @StakePlusCrypto @ChaosDAO You can check your drop here: [https://dune.com/substrate/mythos](https://dune.com/substrate/mythos) Thanks to @colorfulnotion for the @DuneAnalytics dashboard

[https://x.com/giottodf/status/1771761334809428146](https://x.com/giottodf/status/1771761334809428146) You can follow the distribution of DED on Dune 🙂 [https://x.com/Polkadot/status/1828424728840704161](https://x.com/Polkadot/status/1828424728840704161) L1s secured by Polkadot are more active than ever 💪 Monthly Runtime Upgrades by Chain ⤵️

[https://x.com/colorfulnotion/status/1825026730060546542](https://x.com/colorfulnotion/status/1825026730060546542) By linking Polkadot Staking Dashboard to @duneanalytics dashboards (developed by us @colorfulnotion ), everyone can have a deep look into their staking activity.

[https://x.com/TheDotsMagazine/status/1781559738393678096](https://x.com/TheDotsMagazine/status/1781559738393678096) The $MYTH airdrop dashboard has been updated! Now it has 30k more eligible addresses (mine is one of them) 🎉 Check your wallet address here:

[https://x.com/TheDotsMagazine/status/1770793708885065915](https://x.com/TheDotsMagazine/status/1770793708885065915) $DED SNAPSHOT RECAP 🐦 The snapshot was taken on March 18 at Block 19,952,000. All eligible wallets have already recievied 0.001 DOT on Asset Hub 💀 Polkadot Treasury was NOT included in the snapshot. At Block 19952000 the Treasury had 38,603,060 DOT 🪂 Airdrop date - TBA

[https://x.com/colorfulnotion/status/1770622358686253500](https://x.com/colorfulnotion/status/1770622358686253500) Now on Dune: @hydra\_dx Dashboards showing trading volumes, omnipool asset, account trading patterns, liquidity analytics and more! Please star / share, stay hydrated!\_

[https://x.com/Dune/status/1770087920994603325](https://x.com/Dune/status/1770087920994603325) *Starting today @Polkadot @kusamanetwork and 6 top #parachains are now live on Dune! Our mission is to make crypto data accessible, and we're thrilled to help the #Polkadot ecosystem in partnership with @colorfulnotion ⚡ Start your data journey👇*

[https://x.com/mewwts/status/1770126851630883162](https://x.com/mewwts/status/1770126851630883162) *So excited to have @Polkadot on Dune*

\_[https://x.com/NilesLawrence/status/1770119471316779389](https://x.com/NilesLawrence/status/1770119471316779389) We're excited to finally announce this partnership and support a brand new ecosystem of builders! @Polkadot @kusamanetwork @AstarNetwork @bifrost @InterlayHQ @centrifuge @hydra\_dx

[https://x.com/WatanabeSota/status/1770098518138691852](https://x.com/WatanabeSota/status/1770098518138691852) oh wow! "Dune alongside AssetHub for Polkadot, Astar, Bifrost, Hydradx, Interlay, and Centrifuge parachains!"

[https://x.com/Polkadot/status/1770106456668242247](https://x.com/Polkadot/status/1770106456668242247) 📊 Dune is bringing the data! @DuneAnalytics has added support for six parachains and both Polkadot & @kusamanetwork Relay Chains via a collab w/ @colorfulnotion . Dune users can query data and unearth previously inaccessible on-chain activity ✔︎

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.

#1642 Polkadot + Kusama Data on Dune+BigQuery (9 months, 7/1/25-3/31/26)

No Active Proposals