On May 12th, a massive mint of 1,000 Wrapped Bitcoin (WBTC) started doing the rounds on Crypto Twitter:

In effect, this mint nearly doubled the supply of Wrapped Bitcoin — a poetic contrast to the famous Bitcoin halving event on the day before.

Let’s do a quick on-chain review of what exactly happened, using Nansen.

Where exactly was the WBTC minted?

Image for post
Image for post

The WBTC was minted in one single 999.6 WBTC transaction. The merchant used to perform the mint was CoinList, as you can see in the chart above.

Before this mint, CoinList was the #2 biggest WBTC merchant in terms of mints. …


This is a quick follow-up to How to get any Ethereum smart contract into BigQuery (in 8 mins) based on a reader’s question: how do we add proxy addresses?

It’s actually very easy to do this!

You follow the same instructions as in the post above, except you have to run the contract parser on the implementation contract. Then you replace references to the contract address in the SQL or table definition files with the proxy address. It might take you 5 extra minutes, but that’s it!

Here’s how you do it, step-by-step, using PAX as an example:

  1. Go to…


Ethereum is great for data enthusiasts. As a blockchain, it provides us with lots of well-structured data, making virtually everything that happens on it available to analysis.

Blockchain ETL has for a long time been the leading open-source project for parsing Ethereum data (600+ stars on Github).

My fellow D5 DAO member Evgeny Medvedev also worked with Google in 2018 to make Ethereum datasets available via BigQuery.

In this post, I’ll show you how you can easily contribute smart-contract parsers to Blockchain ETL in 3 simple steps. You don’t even need to write any code!

At the end of this…


In my post on why I made the switch from Evernote to Notion, I briefly mentioned how I use Notion to keep a “learning journal”. After writing the post, a few people reached out to ask me more about this. So, I decided to write up this quick post on how you can learn more (and remember more of what you learn!) by creating a learning journal.

Background: Objectives and Key Results

I’m a power user of objectives and key results (OKRs). In brief and broad terms, OKRs are a simple methodology to help you reach your goals. It was originally developed for companies, but…


A few months back I decided to make a serious attempt at switching from Evernote to Notion.

Since tweeting about it created some engagement, I thought I should follow up with a longer post on my experience with Notion vs Evernote. So here we are!

This is by no means an extensive review of Notion — it’s simply a summary of some of the things I like about it, plus some of the issues I experienced coming from Evernote.

Why switch from Evernote to Notion?

I’ve been a long-term die-hard fan of Evernote since I signed up 10 years ago. It pretty much revolutionized the…


Cloud Data Fusion is essentially a graphical, no-code tool to build data pipelines. It looks something like this:

Image for post
Image for post

In this post, I’ll share my first impression of the product. This is in no way meant to be a complete review — I am barely scratching the surface. Hopefully you’ll get an idea of what Cloud Data Fusion is, and whether a closer look is worth your time.

Before diving into the details, let’s consider the historical context of Cloud Data Fusion.

A brief history of ETL / data integration / data pipelines

If you worked in the data / analytics space before data scientist became the sexiest job of the 21st century, you might know that graphical ETL (extract-transform-load) tools have been widely used in corporate data warehousing environments…


by Evgeny Medvedev and Alex Svanevik at D5

One remarkable aspect of Ethereum is that everyone has access to all of the data being generated from blockchain interactions.

This is not just true for Ethereum, but with all public blockchains. It’s a profound difference from the old world of siloed and permissioned data. As a data scientist you’ve traditionally had access to datasets that are either private (you work at a company that owns the datasets) or made open after-the-fact (e.g. MovieLens).

In the world of Ethereum, data is open by design.

In this post, we will demonstrate that you…


Recently, when looking at usage metrics for the Ethereum blockchain, I came across something surprising. An increase in empty blocks:

Image for post
Image for post

That is, blocks that don’t contain any transactions.

My first reaction was: this is not a good sign for the adoption of Ethereum. Are there really gaps of ~15 seconds where no-one in the whole world uses the Ethereum blockchain?!

I think it’s fair to say that Ethereum’s usage metrics generally do not match the interest from developers and investors (yet?), so this explanation didn’t seem all that unlikely.

At the same time, maybe there was something else going on.


Previously, we’ve analyzed crypto exchange tokens using the TVEV ratio — token value / exchange volume . The TVEV ratio compares the price of an exchange token to the traded volume on the underlying exchange. Conceptually, it’s not too far away from the P/E ratio which is often used when valuing equities.

After our last post, many of you reached out and asked us to analyze a wider array of exchange tokens, beyond just Binance Coin, Huobi Token, and KuCoin Shares. So, in this post we’ll have a broader look at centralized exchange tokens.

If you’re waiting for our analysis…


We’ll soon be launching the CoinFi News feature, where you can be the first to know the news that moves the crypto market. While we’re still busy putting everything in place for the launch, we thought we’d give you some insights from the data that underlies our News feed.

In this post, we’ll look at:

  1. Which coins are mentioned the most in the CoinFi News feed?
  2. What are some coins that have been experiencing an increase in mentions lately?
  3. How does number of news mentions correlate with trading metrics, in particular transaction volume?

For this analysis, we’ll look at data from April 30th, 2018 to June 3rd, 2018 (5 weeks). As mentioned above, this is an early look at the data, so we should mention as a disclaimer that there might be minor quirks in the data. …

Alex Svanevik

I like data. Big or small. Crypto, machine learning, languages. https://nansen.ai

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store