metadata: {"signature": "0xc211c0edc5f9c52dbecbc22131ad0edac16dfe50625333ea576cac9ee53e033d036b850955a5f614d10a466c3646aa1e3bc995f1d95ef7b783f38f206c473ffb1b", "application": {"round": "0x8de918f0163b2021839a8d84954dd7e8e151326d", "answers": [{"type": "email", "hidden": true, "question": "Email Address", "questionId": 0, "encryptedAnswer": {"ciphertext": "PRm7OIJa5xO4vsZAAjxz6LdmWCg0/7DIWk46MQPV+GvLV1Pqtwi7urjM0uyMzTDI", "encryptedSymmetricKey": "70aaeb3a27b64f5c9b457a64906a5313e56fb03ff4ae0828c8f6ebb24c147c45a80ac872d624e77a9b860b2ba8d2bd199b1f50495a507ae155f3c7469cdc4e6038953f3067137e026dfb1b8e232f9508147a1a89740d81a5b4c62f5034a42faff680dc34ec2c719d8a4070f24f6d611b1754c4e6d05a546d66ed8edc09bea1f6000000000000002020e4c990917dcd27e14ffe1cd89cf47cb3c7beb84a4fbd1cabd99c17e9df906baf966d681712e63c6323c47382791db9"}}, {"type": "link", "answer": "https://github.com/Open-Spellbook/open-spellbook-bq", "hidden": false, "question": "Project GitHub Repo (Not team page)", "questionId": 1}, {"type": "short-answer", "hidden": true, "question": "Telegram Handle", "questionId": 2, "encryptedAnswer": {"ciphertext": "riQYshepzLPPpDwroBOK2mWkP1b1sqVEsc6Bsg3UjnU=", "encryptedSymmetricKey": "10f14f2e272e61d16a87bd3a1f2fa36001739c61b5e501698d294764329cef03f2cc79d3999434ee8a291ce6d76dc709e91c327307b137cc692e7715b9d0e2f73a18aad1e5b4d1cf5355311b19f1dbfe6bd1fbc29b26ddbe8b82e9b3e9cfc79852049ee46893e76367773a7a756ed98c6a7fd6f5652b38b953cace3340c90686000000000000002032ca2ae6449698e7e8ced865f49c413f8fa0282b91c5a73766802ff8d98d0dd2efcb0664ed615715903bd5592c5ca3a5"}}, {"type": "link", "answer": "https://discord.gg/kEpaefzj", "hidden": false, "question": "Link to your Public Group Chat (Discord or Telegram)", "questionId": 3}, {"type": "number", "answer": "0", "hidden": false, "question": "Total prior funding for the project in USD", "questionId": 4}, {"type": "paragraph", "answer": "No funding received at this point", "hidden": false, "question": "Please expand on how much funding you\u2019ve received from each funding source and when (VC, grants, token sales, etc)", "questionId": 5}, {"type": "number", "answer": "3", "hidden": false, "question": "Total team size", "questionId": 6}, {"type": "number", "answer": "5", "hidden": false, "question": "How old (in Months) is the project?", "questionId": 7}, {"type": "address", "hidden": true, "question": "If you participated in past grant rounds using a different project payout wallet address, please share it here:", "questionId": 8}, {"type": "paragraph", "hidden": false, "question": "Profiles or socials of other main team members publicly associated with the project: ", "questionId": 9}, {"type": "multiple-choice", "answer": "Yes", "hidden": true, "question": "Have you read and confirmed your grant abides by the Program General Eligibility Policy? https://gitcoin.notion.site/GG18-Eligibility-cb4a5754c56043d4b3ed34eddbac261c?pvs=4", "questionId": 10}, {"type": "paragraph", "answer": "It is an open-source public good for the data creators who are building data abstractions. We want to continue the original vision of Spellbook.", "hidden": false, "question": "Please explain how your project meets the round-specific eligibility criteria", "questionId": 11}, {"type": "paragraph", "hidden": false, "question": "If you've participated in past grant rounds, please share any new updates or milestones from the prior months", "questionId": 12}, {"type": "paragraph", "answer": "Our primary KPI to measure impact will be GitHub commits into the open-source repos in the Open Spellbook Org. Second, we plan to implement the GitCoin stack to fund efforts that align with the goal for open-source data & data transforms.", "hidden": false, "question": "How do you measure the impact of your project? Please provide examples and/or standard metrics. This might be used in future impact reports", "questionId": 13}, {"type": "paragraph", "hidden": false, "question": "Anything else you'd like to share about your project, previous work, or other project affiliations? Anything you'd like to add that may help in determining project eligibility?", "questionId": 14}, {"type": "multiple-choice", "answer": "Yes", "hidden": true, "question": "Would you like to opt-in to future messages from Gitcoin for updates, information, and/or interviews?", "questionId": 15}, {"type": "multiple-choice", "answer": "Yes", "hidden": true, "question": "Would you like to opt-in to us sharing your information with select third-parties for investment opportunities?", "questionId": 16}, {"type": "multiple-choice", "answer": "North America", "hidden": false, "question": "Location/Region where the project is based", "questionId": 17}], "project": {"id": "10:0x8e1bD5Da87C14dd8e08F7ecc2aBf9D1d558ea174:828", "title": "Open Spellbook", "metaPtr": {"pointer": "bafkreiee5fxsngqice6wkyamt5kwortg74m5a4bu6v5nv7kexcwohsp4ji", "protocol": "1"}, "website": "https://www.openspellbook.xyz/", "createdAt": 1691765867234, "userGithub": "Outsider-analytics", "credentials": {"github": {"type": ["VerifiableCredential"], "proof": {"jws": "eyJhbGciOiJFZERTQSIsImNyaXQiOlsiYjY0Il0sImI2NCI6ZmFsc2V9..IesEb_ExrFa48wOl0fvIPJisgpFnUAMALsEZ0HU7wTXZHUFBoo3_dPizFOLkp_f1N98gNYOF-lGj8uPPKHgfDA", "type": "Ed25519Signature2018", "created": "2023-08-11T15:04:14.282Z", "proofPurpose": "assertionMethod", "verificationMethod": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC#z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC"}, "issuer": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC", "@context": ["https://www.w3.org/2018/credentials/v1"], "issuanceDate": "2023-08-11T15:04:14.282Z", "expirationDate": "2023-11-09T15:04:14.282Z", "credentialSubject": {"id": "did:pkh:eip155:1:0xA8cadC2268B01395f8573682fb9DD00Bd582E8A0", "hash": "v0.0.0:iygtrBosEO7Uwv3QFzqA/FHIrFR8UuyLqp8dfkNuzio=", "@context": [{"hash": "https://schema.org/Text", "provider": "https://schema.org/Text"}], "provider": "ClearTextGithubOrg#Open-Spellbook#22626267"}}, "twitter": {"type": ["VerifiableCredential"], "proof": {"jws": "eyJhbGciOiJFZERTQSIsImNyaXQiOlsiYjY0Il0sImI2NCI6ZmFsc2V9..DJZcS1-w82oKt9IxuyvjUAF_2qeGpPWk__Up6ySqkjzr7fMhsUpikd-bHbM2P_vgyaqO-bln3aCdK3X2DHbgDw", "type": "Ed25519Signature2018", "created": "2023-08-11T14:57:00.096Z", "proofPurpose": "assertionMethod", "verificationMethod": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC#z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC"}, "issuer": "did:key:z6MkghvGHLobLEdj1bgRLhS4LPGJAvbMA1tn2zcRyqmYU5LC", "@context": ["https://www.w3.org/2018/credentials/v1"], "issuanceDate": "2023-08-11T14:57:00.096Z", "expirationDate": "2023-11-09T14:57:00.096Z", "credentialSubject": {"id": "did:pkh:eip155:1:0xA8cadC2268B01395f8573682fb9DD00Bd582E8A0", "hash": "v0.0.0:9CS1au61llFvB+yGJuiB6uHJiDZD0/jSKMfoVN9nlsw=", "@context": [{"hash": "https://schema.org/Text", "provider": "https://schema.org/Text"}], "provider": "ClearTextTwitter#Open_Spellbook"}}}, "description": "# Returning the Spellbook to Open Source MIT \n\n## Intro:\n\nFor years the collective wisdom of hundreds of data wizards has combined to create the \"Spellbook\", an open-source and MIT Licensed DBT project fostered by Dune Analytics. The Spellbook is an abstraction layer allowing raw blockchain data to reveal its valuable insights. Dune abandoned the open-source heritage of this resource in June with two decisions. \n1. They moved from SPARKQL to a closed-source SQL engine called DUNESQL, preventing the Spellbook models from being run on available software  \n2. They put a license on the resource which limits the use of the Spellbook. \n\nOur project is set up to return the Spellbook to open source by forking the last MIT-licensed version, providing retroactive funding to all those who contributed, and raising an initial pool of capital to fund future contributions to updating the OS Spellbook. \n\n## Objectives:\n\n1. Return the Spellbook to where it belongs: Open Source\n2. Provide retroactive funding for those who built the Spellbook\n3. Create a pool of capital to continue funding wizards who maintain Spellbook\n\n\n## Budget:\n\nThe proposed budget for Open Source Spellbook is as follows:\n\n### Retroactive Funding:\n* If <20k is received: 100% of the Grant\n    * We will assume we don't have the interest or capital to fund a DAO moving forward due to the lack of contributions.\n* If >20k is received: 50% of the Grant\n    * We will assume we have sufficient community interest and capital to create a DAO that will continue to fund the initiative.\n    * We will make further efforts to fund future contributions to the OS Spellbook \n* Contributors will have a 1-month window of time to prove their contributions\n* Contributors have two options for rewards.\n    1. Claim rewards\n    2. Forfit claim effectively donating to future efforts.\n* The working theory is to distribute rewards based on GitHub commits, but we will engage the wizard community to ensure the fairest distribution practically possible.\n\n### Future Contributions (only if >20k is raised):\n\n* Only applies if over 20k is raised.\n* 50% of Grant funds into a Multi-Sig Safe.\n* Current working theory is future rewards will be based on quadratic voting using the Gitcoin Grant Stack with support from the team. \n\n\n## Impact:\n\n1. Establishment of an enriched and widely-adopted open-source Spell Book repository. \n2. Increased efficiency in Blockchain data processing and analysis within the Web3 community.\n3. Strengthened collaborative ties among developers, data scientists, and Blockchain projects.\n4. Standardization of data transform techniques in Web3.\n\n## Conclusion:\n\nThe Web3 ecosystem is built around open-source projects getting access to public goods funding. Returning the Spellbook to open source with the assistance of GitCoin funding is a prime example of that ethos in action. Work that has been freely contributed for years is being captured by a single company that has moved fully to licensed and closed-source software. Help create a vibrant and open data ecosystem within Web3 by contributing to this round, or updating a truly OS spellbook not tied to a company.", "lastUpdated": 0, "projectGithub": "Open-Spellbook", "projectTwitter": "Open_Spellbook"}, "recipient": "0x5554b9D4C60696001ECa427EEECdF9a9B1E010eB"}}