4 min read - Posted 05 Dec 18

DAppBoard BI-Weekly Recap 1

article image

The past 2 weeks were a fresh start for our organization. We have been working hard to set up the foundation of the new upcoming version of DAppBoard . We are currently focusing on building the backbone of it: principally how data are collected, organized and accessed. Our goal, in the next few months, is to get the new version of DAppBoard out. This recap is what we did from 12 to 24 November 2018.

article image

🛠 DAppBoard ETL

In 2 weeks we architectured, developped and released our Ethereum ETL that is written in Javascript. The ETL’s goal (Extract, Load & Transform)and writes to SQL compatible database. The elements that we currently focus on are:

  • Basics of the Ethereum blockchain (blocks, transactions, event logs).

  • Tokens (ERC20/ERC721): we aggregate there transfers but also their metadata like name, symbol, number of decimals.

  • Contracts: the source code and element of their ABIs are stored in an easy to use way. Thanks Etherscan for the openness of their API. We deployed our pipeline and database live for testing and could easily extract more than 60M transactions from 700K blocks, 22K tokens. All the software we run in the background is and will stay open source. As we can’t rely on decentralized technologies to do what we want yet. We open our work so community can thrust us and grow with us.

📊Firsts analysis

We set up the awesome Metabase to access and play with our data . Metabase is an open source piece of software that let anyone build queries and visualize and organize the results. The goal was to see if our data were correct and how easy the way they were stored let us play with it. Our first piece of analysis was about tokens (ERC20/ERC721):

The token space on @ethereum is still really active! Everyday, around 4000 different tokens are used. There is an average number of 350K transfers per days.

 — @dappboardTeam

The number of unique receivers and senders per days is nearly double. A lot of ERC20, ERC721 tokens are still airdropped or minted everyday.

 — @dappboardTeam

And our second piece about mining ⛏:

It's Friday and we compiled some facts about mining on #ethereum ! 42,576 miners mined a total of 230,592 blocks. #blockchain #Mining

 — @dappboardTeam

The distribution of miners is leaded by pools like Ethermine 26%, Sparkpool 21%, f2pool 12% @etherchain_org@sparkpool_eth@f2pool_official

 — @dappboardTeam

The minimum number of transactions included in a block is 0 while the maximum is 388 with an average of 90 transactions per blocks.

 — @dappboardTeam

With an average gas limit of 8,000,000 we can see that most of the blocks are optimized to use as much gas as possible.

 — @dappboardTeam

In one week the total amount of gas used was 1,365,199,944,694 while the total gas limit was 1,860,227,470,940. This means that in the most ideal world: blocks are 73% filled.

 — @dappboardTeam

Those two studies helped us validate our architecture and the correctness of our data set. If you want to be one of the first to see our upcoming tweet storms, do follow DAppBoardTeam on twitter .

article image

Those 2 weeks went so fast and we could achieve a lot. The next steps of our adventure are:

Step back and explain , as the code written for the ETL has been done fast, a lot of things need to be consolidated and also documented so anyone can use it, or we can read it in few months too!

Produce more analysis , we just scratched the surface of what was possible to do with our pipeline. We’ll try to produce DApps specific dashboards. This will also let us improve even more how we structure and test our data set.

Enrich the data , some of the data we store need to be edited manually for more consistency. We need to build an interface for us to easily check and edit some of the data.

Grow the team , we want to grow the team, but for this we need to decide and secure how we’ll get funded for the next months. DAppBoard is focusing on building tools to store, explore and explain data that are generated by the Ethereum makers and users. Follow us or get in touch on Twitter !

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

DAppBoard Team




Related Articles
DAppBoard: The Best Analytics Tool for Decentralized applications and protocols.

One year ago we published, DAppBoard , the first decentralized applications leader board that provided data metrics that used throughout the community today: daily active users, number of transactions and Ether volume. Since our initial launch, several other dapp ranking application have followed our lead and we are happy to have inspired so many developers. We have continuously searched for ways to further contribute to the crypto ecosystem and the community of dapp developers. We also observed

Witnet Monthly Report — March 2018

Development update from the Witnet team Hi there, Witnet community! From now on, every month we will update you on our work towards the milestones set in our project roadmap. Today we want to share what we have been up to over the last month, the challenges we have met and the progress we have done towards our first milestone: the Witnet prototype. Let’s get started!💰 Fundraising We are happy to announce Witnet successfully reached the $1.07M cap on Republic Crypto. The goal was achieved thanks


19 Nov 18