Articles
Collections
Write Article
Create Collection
Import from medium
Loading...
Sign in
POSTED 17 Feb 2019 05:29

Ethereum smart contract data with token/usd prices

ethdenver-2019-submission
shapeshift
OWNER
h
hagaetc

Project Name

Dune Coincapper

Project Tagline/Description (140 Characters Max. Will be used on table card for judging)

Real-time decoded Ethereum data you can query with SQL and join with token prices powered by CoinCap to get USD volumes for dApp activity.

Team Members. First and Last Names

Mats Julian Olsen, Fredrik Haga

Status.im ID for Each Team Member (we will use this to contact you and your team)

@eeee [Fortunate Sociable Grunion] (Fredrik’s phone is too old for Status’ app to work)

Detailed Project Description (no more than 3-4 sentences)

A hosted Postgres database with real-time Ethereum data that you can query with SQL. Smart contract data is decoded with ABI’s so the table columns are named after the parameters in the Solidity code. What we have added for the hackathon is price data from the CoinCap API - meaning that you can easily get USD value of tokens flowing through dApps. Login to https://metabase.duneanalytics.com/collection/43 with email ethdenver@dune.demo and password Tk?ttN8CmSwAu5 and look at a few queries.

USD value of loan repayments on Dharma for different tokens

Describe your tech stack (e.g., protocols, languages, API’s, etc.)

We store data in postgres, and let you query it using metabase. Fetching data from CoinCap’s API is done using golang.

Track for which you’re submitting (Open or Impact)

Open

All Bounties Completed/Incorporated

Shapeshift bounty 1: CoinCap API

A link to all your source code on a public repo (i.e. Github)

https://github.com/duneanalytics/dune-coincapper

Outline
  • Project Name

  • Project Tagline/Description (140 Characters Max. Will be used on table card for judging)

  • Team Members. First and Last Names

  • Status.im ID for Each Team Member (we will use this to contact you and your team)

  • Detailed Project Description (no more than 3-4 sentences)

  • Describe your tech stack (e.g., protocols, languages, API’s, etc.)

  • Track for which you’re submitting (Open or Impact)

  • All Bounties Completed/Incorporated

  • A link to all your source code on a public repo (i.e. Github)