BigQuery区块链数据集是否缺少数据? [英] BigQuery Blockchain Dataset is Missing Data?

问题描述

我正在尝试对最富有的比特币钱包进行一些分析，发现BigQuery数据集缺少大量数据.

I'm trying to do some analysis on the richest Bitcoin wallets, and discovered that the BigQuery dataset is missing a ton of data.

例如，看看当前排名第一的富裕帐户.

For example, take a look at the #1 richest account currently.

钱包地址为:"3D2oetdNuZUqQHPJmcMDDHYoqkyNVsFk9r"

The wallet address is: "3D2oetdNuZUqQHPJmcMDDHYoqkyNVsFk9r"

如果我在 blockexplorer 或任何在线区块链数据源中查找此钱包，就会看到该钱包已收到329万个，发送了316万个，净余额为138,660 BTC.

If I look this wallet up in blockexplorer, or any online blockchain data source, I see that the wallet has received ~3.29 million and sent ~3.16 million for a net balance of 138,660 BTC.

但是当我看到任何交易时， inputpubkeybase58 =='3D2oetdNuZUqQHPJmcMDDHYoqkyNVsFk9r'，我得到的结果为零.

Yet when I look any transcations where inputpubkeybase58 == '3D2oetdNuZUqQHPJmcMDDHYoqkyNVsFk9r', I get zero results back.

这是我作为测试写的查询.

Here is the query I wrote as a test.

SELECT i.input_pubkey_base58
from `bigquery-public-data.bitcoin_blockchain.transactions`
  JOIN UNNEST(inputs) as i
where i.input_pubkey_base58 = '3D2oetdNuZUqQHPJmcMDDHYoqkyNVsFk9r'
LIMIT 100

为什么在上面的查询中没有引用发送的316万个BTC?

Why are none of the 3.16 million BTC sent being referenced in the above query?

如果我在说或做一些愚蠢的事情，请纠正我.谢谢！

Please correct me if I'm saying or doing something stupid. Thanks!

我可以找到 o.output_pubkey_base58 =='3D2oetdNuZUqQHPJmcMDDHYoqkyNVsFk9r'没问题的交易.但是我并没有在寻找收到的BTC的总数，而是在寻找根据上述查询从钱包发送BTC的交易.

I can find the transactions where o.output_pubkey_base58 == '3D2oetdNuZUqQHPJmcMDDHYoqkyNVsFk9r' no problem. But I am not looking for the total BTC received, I am looking for the transactions where BTC was sent from the wallet, as per the above query.

更新:要进一步了解这一差异，请 I试图检查从上述blockchain.com地址发送BTC的交易..在BigQuery中找不到从钱包发送BTC的最近交易.例如，我找不到2018年10月22日将2,000个BTC的价格发送到1Kr6aQ1P6NQ1Q6QNQ1Q6QN

Update: To shed more light on this discrepancy, I tried to examine transactions where BTC was sent from the aforementioned address on blockchain.com. Most of the recent transactions where BTC was sent from the wallet could not be found in BigQuery. For example, I couldn't find an Oct. 22, 2018 transaction where 2,000 BTC was sent to 1Kr6QSydW9bFQG1mXiPNNu6WpJGmUa9i1g.

SELECT o.output_pubkey_base58, i.input_pubkey_base58, o.output_satoshis
FROM `bigquery-public-data.bitcoin_blockchain.transactions`
   JOIN UNNEST(inputs) as i
   JOIN UNNEST(outputs) as o
WHERE 
transaction_id ='6d0da34d69693ae81169a0cc3cd65847929939617d3a8cf41ef3d02971857a3e'

我能够找到一些2017年的较早交易，例如

I was able to find some of the older transactions dated in 2017 like

SELECT o.output_pubkey_base58, i.input_pubkey_base58, o.output_satoshis
FROM `bigquery-public-data.bitcoin_blockchain.transactions`
   JOIN UNNEST(inputs) as i
   JOIN UNNEST(outputs) as o
WHERE 
transaction_id ='29dd29b8d1647c766f3fad233fe7a0c026fbb9f42544d96c917f6b028667907a'

但是结果显示i.input_pubkey_base58为空

But the results show null for i.input_pubkey_base58

推荐答案

尝试以下

SELECT COUNT(1)
FROM `bigquery-public-data.bitcoin_blockchain.transactions`,
UNNEST(outputs) AS o
WHERE o.output_pubkey_base58 = '3D2oetdNuZUqQHPJmcMDDHYoqkyNVsFk9r'  

这将为您提供5417笔交易

this will give you 5417 transactions

这篇关于BigQuery区块链数据集是否缺少数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！