Colorful Notion successfully onboarded the Polkadot ecosystem into Dune under OpenGov 366, which has been operational for over one year now, and showcases the majority of the Polkadot ecosystem.  Colorful Notion wishes to renew its efforts to cover 4 additional quarters (Q2 2025 - Q1 2026), to ensure that Polkadot continues to be ingested and maintained on Dune as well as Google Cloud BigQuery (GC Web3) for an additional 4 quarters. 

You can see much of our work in the Highlighted Tweets below, as well as in on the Polkadot wiki.  

We have drafted a proposal here covering 2 out of the 4 quarters so that Polkadot stakeholders (parachains) may provide valuable feedback on how to modulate our plans in the next year.   

Whereas the previous year focussed on the heavy workload of onboarding the relay chain, system chains, parachains, the next 6-12 months will be more maintainance focussed on the key migration of both the Kusama and Polkadoy relay chains into Kusama Hub and Polkadot Hub thereafter.

Our primary question for stakeholders is:

What would you like to see happen in Dune + Google BigQuery from us?

Please share your thoughts here!

Highlighted Tweets
https://x.com/Polkadot/status/1864626032218620265 TVL on Polkadot DEX @hydration_net reaches ATH ✅_

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 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 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 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 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 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 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 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/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 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 The DEX @hydration_net is approaching 1B in cumulative volume since Feb 2024 👀 source @Dune_

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 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 @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://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 No fluff, just data. Check the Polkadot 2024 Dashboard on @Dune for the answer. https://dune.com/substrate/2024 / by @colorfulnotion

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

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 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 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 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 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 The first charts we've built about a @polkadot parachain that makes us smile about GROWTH. 😀😍🥰

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

_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 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 . @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://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 Move your ETH assets to Polkadot here: https://app.snowbridge.network and join the WETH top holders on Polkadot Asset Hub: https://assethub-polkadot.subscan.io/foreign_assets/f1846f14a52715c2a09df52ef8f077c52977dcfd and beyond =)

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 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 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 "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://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 Special thanks to @Funkmeister380 @colorfulnotion 🔥

 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 Thanks to @colorfulnotion for the @DuneAnalytics dashboard

https://x.com/giottodf/status/1771761334809428146 You can follow the distribution of DED on Dune 🙂 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 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 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 $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 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 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 So excited to have @Polkadot on Dune

_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 oh wow! "Dune alongside AssetHub for Polkadot, Astar, Bifrost, Hydradx, Interlay, and Centrifuge parachains!"

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 ✔︎