hagaetc
hagaetc

2 min read - Posted 17 Feb 19

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 ethdenver@dune.demo and password Tk?ttN8CmSwAu5 and look at a few queries.

article image

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

Created with Sketch.Content is"CC-BY-SA 4.0" licensed
Article On-chain
Article Author
hagaetc

Fredrik Haga

1

0

0

0 Comments
Related Articles
MarketWatch - Crypto Exchange Monitor

Project Name MarketWatch Project Tagline/Description (140 Characters Max. Will be used on table card for judging) A bot to help you stay in the crypto game with some assistance from ShapeShift and CoinCap. Team Members. First and Last Names Cooper Wiegand Status.im ID for Each Team Member (we will use this to contact you and your team) 0x04db7ff70ea424dc7c9b56ee565ea891e95c54632b03aa7153dd58852b0fba6c15db423af7c732800bc9d9dd794b25d893833c0184a12cbd57f8f0e7989212a4ae Detailed Project Description

CryptoMessenger

Project Name CryptoMessengerProject Tagline/Description (140 Characters Max. Will be used on table card for judging) Talk to a friend or enemy while trading crypto, easy!Team Members. First and Last Names Shirlyn Prabahar, Jason VranekStatus.im ID for Each Team Member (we will use this to contact you and your team) Shirlyn: 0x044306bf117b66ae79ef9f9371b4ae8c37f26d3856ae1c6364102e9c11876583686f3b1754d1eb085ce793fad22fea752ee8c778583ccef51aed68d3be4a8585d5 Jason: 0x048843b13160191ddf951d47810a895e