DAppBoard BI-Weekly Recap 1

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.

πŸ›  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:

πŸ“Š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 .

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 !