Month: September 2022

  • Bitcoin Analytics

    Find Duplicate Transactions A single transaction can only belong to a single block. However, in earlier versions of bitcoin (due to a different database),there was a transaction that was added to two blocks. This transaction can be discovered using this query: select * from (select transaction_id, count(transaction_id) as duplicates from `bigquery-public-data.bitcoin_blockchain.transactions` group by transaction_id) where duplicates > 1 Find wallets with over 1,000 btc Find Transactions which transferred over 1000 BTC

  • AutoML versus CloudML versus SparkML (DataProc)

    Overview – Training Sets Training Sets are split into 70% 30%. The first 70% is for training, the second 30% is for tuning the model’s parameters. AutoML Google’s AutoML lets you perform the training with as few as 10-12 items (e.g. Vision AutoML requires a dozen or so images to start training). Google provides the…