OurNetworkOurNetwork Learn: Web3's Learn-to-Earn Data Cohort Program
Applications are now closed, please follow along in the public materials link (coming out November 1st, 2021). OurNetwork contributors and the Dune team are partnering up to bring to fruition Web3's first learn-to-earn data program. We'll spend 30 days teaching a cohort of 30 students how to analyze data in Web3 and communicate their work publicly. The program uses an application system, so there's no buying your way into this cohort. Even if you don't make it into the coh...
OurNetworkDisclosures
OurNetwork Disclosures The views expressed in the 0xOUR LLC d/b/a OurNetwork newsletter (“OurNetwork” or the “Newsletter”) are those of Spencer Noon or such other person to whom they are attributed therein and are not the views or opinions of Unofficial Management, Inc. d/b/a Variant (“Variant”) or its respective affiliates. Views and opinions expressed in the Newsletter or linked to therein that are attributed to third parties are not endorsed by OurNetwork, Spencer Noon or Variant, and may ...
OurNetworkCRYPTO WINTER
CRYPTO WINTER is the first NFT drop from Genesis, a new NFT collection from OurNetwork that commemorates the major milestones in crypto. Mint the Genesis NFT for free for a limited time and also subscribe to OurNetwork by clicking Subscribe to Mint NFT below:
Building crypto communities with data.
OurNetworkOurNetwork Learn: Web3's Learn-to-Earn Data Cohort Program
Applications are now closed, please follow along in the public materials link (coming out November 1st, 2021). OurNetwork contributors and the Dune team are partnering up to bring to fruition Web3's first learn-to-earn data program. We'll spend 30 days teaching a cohort of 30 students how to analyze data in Web3 and communicate their work publicly. The program uses an application system, so there's no buying your way into this cohort. Even if you don't make it into the coh...
OurNetworkDisclosures
OurNetwork Disclosures The views expressed in the 0xOUR LLC d/b/a OurNetwork newsletter (“OurNetwork” or the “Newsletter”) are those of Spencer Noon or such other person to whom they are attributed therein and are not the views or opinions of Unofficial Management, Inc. d/b/a Variant (“Variant”) or its respective affiliates. Views and opinions expressed in the Newsletter or linked to therein that are attributed to third parties are not endorsed by OurNetwork, Spencer Noon or Variant, and may ...
OurNetworkCRYPTO WINTER
CRYPTO WINTER is the first NFT drop from Genesis, a new NFT collection from OurNetwork that commemorates the major milestones in crypto. Mint the Genesis NFT for free for a limited time and also subscribe to OurNetwork by clicking Subscribe to Mint NFT below:
Building crypto communities with data.
Subscribe to OurNetwork
Subscribe to OurNetwork
Share Dialog
Share Dialog
>1.9K subscribers
>1.9K subscribers
For anyone looking for an overview of the program more generally, check the original announcement post here. The students accepted and application methodology can be found here.
We’ll be posting all course material with a one-week delay on this entry post. For anyone who is trying to completely replicate the course format and tools, here’s the syllabus/methodologies we use that contains almost all the resources we’ve provided to students.
All lectures, focus group recordings (practice problems), and protocol sponsor presentations will be accessible free in this youtube playlist, and are further described in detail with slides below.
To support this course and future versions of it, please collect one of the entry editions of this post. We’ll definitely remember it if you do! 😊 All ETH raised from entry editions will be sent directly to this split across teachers (feel free to send any donations directly to the split as well), we appreciate any and all support from students and protocols! ❤️
split://0xB62F3533316183d827a6331472E52f1C517B8059
Students will be tackling bounties each week as well, focused on the protocol sponsors and their data questions. Their payouts are shown below, using the reward structure described in the syllabus:
split://0x4242423b2E6e6A5262399E7C7b66A76596f23A63?network=mainnet
Intro/Syllabus overview:
Lecture 1: Looking at basic call and event data on Ethereum. Here we covered navigation on Dune, and how to do basic SELECT and WHERE queries on token transfer data tables. (Andrew)
Focus Group 1, we created a query following the Web3 quick query resource
Genie-Swap presentation: Recording by Scott
Lecture 2: Understanding ERC20 and ERC721 standards, decoding contracts on Dune/what ABIs are, and how to use aggregate functions, GROUP BY, and CTE queries/subqueries. (Kofi)
Focus Group 2, we went over DPI holder query from protocol questions
Rabbithole presentation: Recording by Trevor
Focus Group 3: Answering students’ questions from the first week, and talking through examples of a contract pattern from a factory (with and without proxies, and why one would choose a certain pattern).
Lecture 3: Learning about the different kinds of JOINs, and how they are different from UNIONs. We used prices.usd and DPI/ETH pools to study this. (JD)
Focus Group 4: Continuing our dive into DPI/ETH liquidity pool data on Uniswap V2 and V3, and creating multiple token price feeds while selecting just the most recent price.
Lecture 4: How dex.trades is constructed, and how to query across DEX exchanges and aggregators for two tokens. (Danning)
Focus Group 5: We study how some DEX volume metrics can be constructed, as well as Compound Governance + Solidity Visual Debugger tooling for visualizing contract flows.
Guide to table mappings on Dune, as a supplement to the query quick starter guide from week 1
IndexCoop Presentation: Recording by JD
Focus Group 6: We review everything about table mappings in Ethereum, and walk through some examples of contract sleuthing to find the contracts, events, and functions.
Lecture 5: How nft.trades is constructed, and how to query across NFT marketplaces and create user-generated views. (Rantum)
Focus Group 7: Working through complex data visualizations with Impossible Finance staking data (the first 55 minutes are most useful).
Lecture 6: Boxer takes us through all the need-to-know tips for doing data visualization on Dune. (Boxer)
Focus Group 8: Boxer walks everyone through his journey in web3 and also some high-quality dashboards on Dune.
Focus Group 9: Covering time-series queries on balances and mints of NFTs/ERC20 tokens, and reviewing the muted section from last week
Reading resources shown in the video
Dune utility queries shown in the video
Lecture 7: Boxer takes us through more dashboards and creates one from scratch (Boxer)
Lecture 8: Michael takes us through everything you need to know about creating and using parameters flexibly in a dashboard and across many queries. (Michael)
And that’s all the material! Best of luck going through it, and feel free to ask questions in the #ournetwork discord channel embedded in the glass.xyz hosted site.
For anyone looking for an overview of the program more generally, check the original announcement post here. The students accepted and application methodology can be found here.
We’ll be posting all course material with a one-week delay on this entry post. For anyone who is trying to completely replicate the course format and tools, here’s the syllabus/methodologies we use that contains almost all the resources we’ve provided to students.
All lectures, focus group recordings (practice problems), and protocol sponsor presentations will be accessible free in this youtube playlist, and are further described in detail with slides below.
To support this course and future versions of it, please collect one of the entry editions of this post. We’ll definitely remember it if you do! 😊 All ETH raised from entry editions will be sent directly to this split across teachers (feel free to send any donations directly to the split as well), we appreciate any and all support from students and protocols! ❤️
split://0xB62F3533316183d827a6331472E52f1C517B8059
Students will be tackling bounties each week as well, focused on the protocol sponsors and their data questions. Their payouts are shown below, using the reward structure described in the syllabus:
split://0x4242423b2E6e6A5262399E7C7b66A76596f23A63?network=mainnet
Intro/Syllabus overview:
Lecture 1: Looking at basic call and event data on Ethereum. Here we covered navigation on Dune, and how to do basic SELECT and WHERE queries on token transfer data tables. (Andrew)
Focus Group 1, we created a query following the Web3 quick query resource
Genie-Swap presentation: Recording by Scott
Lecture 2: Understanding ERC20 and ERC721 standards, decoding contracts on Dune/what ABIs are, and how to use aggregate functions, GROUP BY, and CTE queries/subqueries. (Kofi)
Focus Group 2, we went over DPI holder query from protocol questions
Rabbithole presentation: Recording by Trevor
Focus Group 3: Answering students’ questions from the first week, and talking through examples of a contract pattern from a factory (with and without proxies, and why one would choose a certain pattern).
Lecture 3: Learning about the different kinds of JOINs, and how they are different from UNIONs. We used prices.usd and DPI/ETH pools to study this. (JD)
Focus Group 4: Continuing our dive into DPI/ETH liquidity pool data on Uniswap V2 and V3, and creating multiple token price feeds while selecting just the most recent price.
Lecture 4: How dex.trades is constructed, and how to query across DEX exchanges and aggregators for two tokens. (Danning)
Focus Group 5: We study how some DEX volume metrics can be constructed, as well as Compound Governance + Solidity Visual Debugger tooling for visualizing contract flows.
Guide to table mappings on Dune, as a supplement to the query quick starter guide from week 1
IndexCoop Presentation: Recording by JD
Focus Group 6: We review everything about table mappings in Ethereum, and walk through some examples of contract sleuthing to find the contracts, events, and functions.
Lecture 5: How nft.trades is constructed, and how to query across NFT marketplaces and create user-generated views. (Rantum)
Focus Group 7: Working through complex data visualizations with Impossible Finance staking data (the first 55 minutes are most useful).
Lecture 6: Boxer takes us through all the need-to-know tips for doing data visualization on Dune. (Boxer)
Focus Group 8: Boxer walks everyone through his journey in web3 and also some high-quality dashboards on Dune.
Focus Group 9: Covering time-series queries on balances and mints of NFTs/ERC20 tokens, and reviewing the muted section from last week
Reading resources shown in the video
Dune utility queries shown in the video
Lecture 7: Boxer takes us through more dashboards and creates one from scratch (Boxer)
Lecture 8: Michael takes us through everything you need to know about creating and using parameters flexibly in a dashboard and across many queries. (Michael)
And that’s all the material! Best of luck going through it, and feel free to ask questions in the #ournetwork discord channel embedded in the glass.xyz hosted site.
No activity yet