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.
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:
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).
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!
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.
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.
I’ve been a long-term die-hard fan of Evernote since I signed up 10 years ago. It pretty much revolutionized the…
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.
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…
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.
Recently, when looking at usage metrics for the Ethereum blockchain, I came across something surprising. An increase in empty blocks:
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…
In this post, we’ll look at:
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. …