Exploring the Public Cryptocurrency Datasets Available in BigQuery Reviews

soumodeep s. · Reviewed almost 5 years ago

Rahul K. · Reviewed almost 5 years ago

Aniket D. · Reviewed almost 5 years ago

Rishav R. · Reviewed almost 5 years ago

Joe m. · Reviewed almost 5 years ago

Fahiya N. · Reviewed almost 5 years ago

Rachana S. · Reviewed almost 5 years ago

TEJAS P. · Reviewed almost 5 years ago

SOURABH K. · Reviewed almost 5 years ago

-- SQL source from https://cloud.google.com/blog/product... CREATE OR REPLACE TABLE lab.52 (balance NUMERIC) as WITH double_entry_book AS ( -- debits SELECT array_to_string(inputs.addresses, ",") as address , -inputs.value as value FROM `bigquery-public-data.crypto_bitcoin.inputs` as inputs UNION ALL -- credits SELECT array_to_string(outputs.addresses, ",") as address , outputs.value as value FROM `bigquery-public-data.crypto_bitcoin.outputs` as outputs ) SELECT sum(value) as balance FROM double_entry_book where address = "1XPTgDRhN8RFnzniWCddobD9iKZatrvH4"

Pratik J. · Reviewed almost 5 years ago

ADITHYA P. · Reviewed almost 5 years ago

Kshitij R. · Reviewed almost 5 years ago

Harsh V. · Reviewed almost 5 years ago

Aldi S. · Reviewed almost 5 years ago

Jatin M. · Reviewed almost 5 years ago

Yokesh K. · Reviewed almost 5 years ago

Trevor U. · Reviewed almost 5 years ago

TUSHAR W. · Reviewed almost 5 years ago

Pranab D. · Reviewed almost 5 years ago

Rashi A. · Reviewed almost 5 years ago

Madhav M. · Reviewed almost 5 years ago

Sai Durga Greeshmanth K. · Reviewed almost 5 years ago

Ishan S. · Reviewed almost 5 years ago

Parth L. · Reviewed almost 5 years ago

Irfan B. · Reviewed almost 5 years ago