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

SMS-blockchain-protocol

Project Name SMS-blockchain-protocol Project Tagline/Description (140 Characters Max. Will be used on table card for judging) MS-blockchain-protocol allows users to interact with Ethereum smart contracts using SMS. With this technology, you can access the Ethereum blockchain without wifi or a 3G/LTE data plan connection, as long as you have basic cell phone service. Team Members. First and Last Names Aaron Anderson David Bruno Sam Steele Daniel Novikov Status.im ID for Each Team Member (we will