Open in app

Sign In

Write

Sign In

Evgeny Medvedev
Evgeny Medvedev

971 Followers

Home

About

Published in Google Cloud - Community

·Apr 15, 2021

Real-time Crypto Price Anomaly Detection with Deep Learning and Band Protocol

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. …

Cryptocurrency

6 min read

Real-time Crypto Price Anomaly Detection with Deep Learning and Band Protocol
Real-time Crypto Price Anomaly Detection with Deep Learning and Band Protocol
Cryptocurrency

6 min read


Published in Nansen.ai

·Oct 16, 2020

Ethereum 2.0 ETL and Medalla Data in Google BigQuery

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: A quickstart guide for Ethereum 2.0 ETL. The…

Ethereum

2 min read

Ethereum

2 min read


Published in The Startup

·Feb 8, 2020

How to package a JavaScript library for use in BigQuery

In this article you’ll learn how to package a JavaScript library for use in a BigQuery UDF. We’ll consider a particular example — ethers.js —a complete Ethereum library and wallet implementation in JavaScript. It will allow us to decode raw transactions and logs data in the bigquery-public-data.crypto_ethereum dataset in BigQuery. …

Bigquery

3 min read

How to package a JavaScript library for use in BigQuery
How to package a JavaScript library for use in BigQuery
Bigquery

3 min read


Published in Google Cloud - Community

·Jan 20, 2020

How to replay time series data from Google BigQuery to Pub/Sub

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: Backtesting. Demos / Visualizations. Integration testing. The go-to GCP service for moving data between different services is Dataflow. While there…

Google Cloud Platform

3 min read

Google Cloud Platform

3 min read


Published in Coinmonks

·Oct 9, 2019

Query ENS and 0x contract events with SQL in Google BigQuery

You can now easily query parsed ENS, 0x and many more (see below) smart contract events in Google BigQuery: 0x tables, ENS tables. Those tables are near real-time. You can easily add events for any Ethereum contract you are interested in to public blockchain-etl datasets. Find instructions below. Accessing Datasets in BigQuery After you…

Bigquery

2 min read

Query ENS and 0x events with SQL in Google BigQuery
Query ENS and 0x events with SQL in Google BigQuery
Bigquery

2 min read


Published in Google Cloud - Community

·Oct 7, 2019

Live Ethereum and Bitcoin Data in Google BigQuery and Pub/Sub

The crypto_ethereum and crypto_bitcoin datasets in BigQuery are now updated using the streaming technology. You can also subscribe to public Pub/Sub topics that feed those tables. The overall architecture is depicted below: The following blockchains are covered: Ethereum Bitcoin ZCash Litecoin Doge Dash We added delays for each blockchain that…

Google Cloud Platform

3 min read

Live Ethereum and Bitcoin Data in Google BigQuery and Pub/Sub
Live Ethereum and Bitcoin Data in Google BigQuery and Pub/Sub
Google Cloud Platform

3 min read


Mar 17, 2019

The Laws of Human Nature Summary

The Laws of Human Nature by Robert Greene For every law the author provides an example from history, interprets and explains it and gives advice on how to use the law. Pros: very interesting historical examples. Cons: the author didn’t provide any scientific evidence for the laws in the book…

Books

9 min read

Books

9 min read


Feb 5, 2019

Comparing Transaction Throughputs for 8 blockchains in Google BigQuery with Google Data Studio

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…

Blockchain

2 min read

Comparing Transaction Throughputs for 8 blockchains in Google BigQuery with Google Data Studio
Comparing Transaction Throughputs for 8 blockchains in Google BigQuery with Google Data Studio
Blockchain

2 min read


Published in Google Cloud - Community

·Jan 14, 2019

Building Token Recommender in Google Cloud Platform

In this article I will guide you through the process of creating an ERC20 token recommendation system built with TensorFlow, Cloud Machine Learning Engine, Cloud Endpoints, and App Engine. The solution is based on the tutorial article by Google. …

Machine Learning

8 min read

Building Token Recommender in Google Cloud Platform
Building Token Recommender in Google Cloud Platform
Machine Learning

8 min read


Published in Google Cloud - Community

·Jan 10, 2019

Calculating Gini Coefficient in BigQuery with SQL

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: It uses 1 — 2B formula from this Wikipedia page https://en.wikipedia.org/wiki/Gini_coefficient, …

A Genre A Week

1 min read

Calculating Gini Coefficient in BigQuery
Calculating Gini Coefficient in BigQuery
A Genre A Week

1 min read

Evgeny Medvedev

Evgeny Medvedev

971 Followers

Creator of https://github.com/blockchain-etl, Co-founder of https://d5.ai and https://nansen.ai, Google Cloud GDE, AWS Certified Solutions Architect

Following
  • Felipe Hoffa

    Felipe Hoffa

  • Lak Lakshmanan

    Lak Lakshmanan

  • Beebie - Pussaaon J.

    Beebie - Pussaaon J.

  • Rif Kiamil

    Rif Kiamil

  • Vitalik Buterin

    Vitalik Buterin

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech