ethb3rlin / sponsor-bounties

Get additional rewards for your contributions from our sponsors
The Unlicense
5 stars 4 forks source link

[BOUNTY] Dune - the API is here #6

Open davidkell opened 1 year ago

davidkell commented 1 year ago

The next-generation of crypto analytics apps

Dune is the leading community-powered crypto analytics platform.

Our API is the #1 requested feature and you'll be the first to get your hands on it. Just by writing SQL, you can query data from the ethereum blockchain and L2 networks, decoded contracts, and abstractions for popular use cases like NFTs and DeFi.

We're kickstarting a revolution in transparent crypto analytics. What will you build?

How to qualify ☑️

Projects must successfully integrate the Dune API to qualify. Projects are free to use other tools and can also qualify for other award submissions.

To hand in your submission: post the link to your devfolio submission as a comment to this issue before the hackathon deadline (Sun, Sep 19, 11AM Berlin time).

Additional resources 🌐

Start here.

For API keys, email api@dune.com or come find the Dune team IRL at our ETHBerlin booth.

To learn how to use our API, with quickstarts and language specific examples, see our API documentation.

We'll have a dedicated support channel on our community Discord at #dune-api.

Judging criteria ⚖️

Prize 🏆

5x bounties of €1,000 Limited edition Dune swag

daniilpastukhov commented 1 year ago

https://devfolio.co/projects/capacity-99f1

iampuma commented 1 year ago

Hope you like it https://devfolio.co/projects/dunesheets-8ab4

hildobby commented 1 year ago

https://devfolio.co/projects/tornadoxxed-495e 🫡

patricktu2 commented 1 year ago

🌕 https://devfolio.co/projects/moonblock-brand-radar-9feb

ainhoa-a commented 1 year ago

https://devfolio.co/projects/xposimo-3427 New generation of Dune Analytics based app.

SantiagoDePolonia commented 1 year ago

The project is called: CoinBoard DevFolio link: https://devfolio.co/projects/coinboard-9234 GitHub: https://github.com/santiagoDePolonia/coinboard Youtube presentation: https://youtu.be/Kkv_wDI5Wnk

davidkell commented 1 year ago

The project is called: CoinBoard I'm not sure what is the devfolio link. GitHub: https://github.com/santiagoDePolonia/coinboard Youtube presentation: https://youtu.be/Kkv_wDI5Wnk

See this link https://ethberlin.devfolio.co/

you need to setup an account here and post your submission

see previous comments for examples

ValiHar commented 1 year ago

Thanks for letting us test the API :) Devfolio: https://devfolio.co/projects/private-poap-7418 Github: https://github.com/TUM-Blockchain-Club/private_poap

gabrielfior commented 1 year ago

Github repo -> https://github.com/gabrielfior/dune-ml Dashboard -> https://dune-lens-ml.herokuapp.com/ Submssion -> https://devfolio.co/projects/dune-and-lens-dashboard-d418

wottpal commented 1 year ago

https://devfolio.co/projects/libertapp-937b 🔥

Libertapp – 06

iainnash commented 1 year ago

scatter.tools: private NFT collecting

NFT querying powered by dune dynamic queries

https://devfolio.co/projects/scatter-privately-collect-nfts-2bff

https://github.com/iainnash/scatter.tools/blob/main/scatter-web/pages/api/query.ts

cameel commented 1 year ago

yul-lsp: a language server for Yul, the low-level language used as the intermediate representation by the Solidity compiler. LSP is a protocol meant to be a generic way to expose language-support functionality to code editors (go-to-definition, code completion, hints on hover, etc.). There are already several language servers for Solidity but none for Yul.

Our plan, in addition to providing a solid language server, was to make it capable of fetching extra information from external sources, especially Dune API. Information than could not be obtained by local parsing and analysis of a single contract. For example hovering over a 4-byte function selector (e.g. 0x70a08231) would show any matching function signatures returned by the API (in this case balanceOf(address) would be a match). Or when hovering over an address you would see if the address belongs to a contract and the name of the contract. This is especially useful in a low level language where there are few abstraction and programmers often deal with raw addresses and selectors.

Repository: https://github.com/cameel/yul-lsp Devfolio: https://devfolio.co/projects/langauge-server-protocol-lsp-for-yul-language-3377 Queries used by the tool: https://dune.com/penguinlinux

anastasiarods commented 1 year ago

https://devfolio.co/projects/privacy-oriented-offchain-and-onchain-analytics-2ddd

SantiagoDePolonia commented 1 year ago

The project is called: CoinBoard I'm not sure what is the devfolio link. GitHub: https://github.com/santiagoDePolonia/coinboard Youtube presentation: https://youtu.be/Kkv_wDI5Wnk

See this link https://ethberlin.devfolio.co/

you need to setup an account here and post your submission

see previous comments for examples

Thanks! I edited my comment.

lorenz234 commented 1 year ago

https://devfolio.co/projects/dune-discord-bot-2f43

derzeitgeist99 commented 1 year ago

https://devfolio.co/projects/toucanfrens-b4c9

Throvn commented 1 year ago

https://devfolio.co/projects/dopalytics-dune-nocode-solution-260d

germanier commented 1 year ago

https://devfolio.co/projects/perdedune-e9f7

davidkell commented 1 year ago

Results

Thank you to all of you for sharing your submission.

We were really impressed by your market insights, hacking skills and videography.

Without further ado, our five bounty winners (in no particular order) are:

Please come visit us in our booth (dining room, level 0) so we can get your details for the prizes. Keep an eye out on Twitter and our blog. Congratulations!

Selection process

For full transparency, here was the process we used to choose our 5 bounty winners from 16 submissions in total.

Qualification

In order to qualify, a submission had to successfully integrate our official Dune API.

There were some pretty cool projects built on Dune’s internal APIs or web app, but these were not considered.

Using this criteria, we filtered down to 12 projects.

Judging

Our three judging criteria were:

How useful is your application

Here we were looking for submissions that solved a genuine user/business need, rather than just a tech demo.

Extra points for a compelling pitch/video to explain the use case.

The ideal project would form the basis of a successful business if developed further.

How integral is the Dune API

Here we wanted to see a project where the Dune API was an essential component of the project, and was the right technical choice.

For example, Dune’s API is better suited to historical analysis, rather than real-time data fetching.

General epic-ness

If we needed a tie breaker, we were looking for that “special something”.

In practice, the previous two criteria were enough for us to choose our five winners.