Ethereum smart contract data with token/usd prices

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 [email protected] 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

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