menu
arrow_back

Visualize the 10,000 Bitcoin Pizza Transaction Using BigQuery and AI Notebooks

Visualize the 10,000 Bitcoin Pizza Transaction Using BigQuery and AI Notebooks

1時間 5クレジット

GSP604

Google Cloud Self-Paced Labs

Introduction

This lab digs into the fates of the bitcoin transactions tied to the infamous 10,000 bitcoin pizza purchase.

This code is based on code originally written by Allen Day and modified by Sohien Dane and Meg Risdal from these Kaggle kernels (parts 1, 2, 3). You use it to visualize a directed graph representing Bitcoin transactions that follow the first known exchange of Bitcoin for goods on May 17, 2010 made by Laszlo Hanyecz.

In this lab, you use an AI Platform Notebook instance to:

  1. Retrieve as many transactions as possible from BigQuery within 2 degrees of separation from the pizza exchange.

  2. Post-process the transactions to remove excess transactions from step 1 because the query was overly-greedy to ensure the number of table scans equals the degrees of separation.

  3. Visualize the directed graph.

Join Qwiklabs to read the rest of this lab...and more!

  • Get temporary access to the Google Cloud Console.
  • Over 200 labs from beginner to advanced levels.
  • Bite-sized so you can learn at your own pace.
Join to Start This Lab