Immediate and accurate analysis of financial time series data is crucial to the price discovery mechanism that is at the heart of capital markets.
We’ll show you how insights can be derived from financial time series data, in real-time, using Machine Learning. …
In this article we’ll cover our Ethereum 2.0 ETL tools for exporting Ethereum 2.0 blockchain data, the public Medalla dataset in BigQuery, and a Nansen.ai dashboard we built with some interesting charts and tables.
The article is broken down into three parts:
bigquery-public-data.crypto_ethereum dataset in BigQuery.
This is a tutorial article explaining how to replay time series data from a BigQuery table into a Pub/Sub topic. There are several use cases when you might need it:
blockchain-etldatasets. Find instructions below.
The overall architecture is depicted below:
The following blockchains are covered:
For every law the author provides an example from history, interprets and explains it and gives advice on how to use the law.
With our recent release of Bitcoin-derived blockchain datasets, BigQuery now contains 8 cryptocurrencies in total including Bitcoin, Bitcoin Cash, Zcash, Litecoin, Dogecoin, Dash, Ethereum, and Ethereum Classic. Below is the graph demonstrating daily transaction counts for those blockchains:
Ethereum is clearly leading with almost 600k daily transactions on average in…
The Gini coefficient, also known as the Gini index, is a common econometric tool for measuring inequality of asset distribution.
Here is the query that outputs Gini coefficient for each day given daily non-zero (anonymous) account balances:
1 — 2B formula from this Wikipedia page https://en.wikipedia.org/wiki/Gini_coefficient, …