<p>Google Cloud provides a dataset for most public blockchains, including bitcoin. You can directly query the dataset via their BigQuery Tool - you can use standard SQL</p>
<p>Bitcoin Dataset on GCP:</p>
<p><a href="https://console.cloud.google.com/marketplace/product/bitcoin/crypto-bitcoin?filter=solution-type:dataset&amp;id=7fd60425-cb95-4a58-b59f-ab3789642844" rel="nofollow noreferrer">https://console.cloud.google.com/marketplace/product/bitcoin/crypto-bitcoin?filter=solution-type:dataset&amp;id=7fd60425-cb95-4a58-b59f-ab3789642844</a></p>

CC BY-SA 4.0
2021-01-07T09:15:15.363Z
2021-01-07T09:15:15.363Z
Tim Menapace
<p>My goal is to get all addresses with a balance of more than 0.01 BTC. In order to get this data, I have to sync the full bitcoin node but I want to avoid it. Maybe there is any open SQL or MongoDB database somewhere. The speed is important.</p>
<p>Thanks in advance</p>

CC BY-SA 4.0
2021-01-06T10:20:44.653Z
https://blockchair.com/bitcoin/addresses?q=balance(1000000..)&s=balance(asc)# ?
MCCCS
<bitcoin-core><transactions><wallet>
Is there an open database to query bitcoin transactions
pr0logas
# Is there an open database to query bitcoin transactions

(Asked by: username_0 on 2021-01-06)

My goal is to get all addresses with a balance of more than 0.01 BTC. In order to get this data, I have to sync the full bitcoin node but I want to avoid it. Maybe there is any open SQL or MongoDB database somewhere. The speed is important.

Thanks in advance

**Tags:** bitcoin-core, transactions, wallet

> **Comments:**
> **username_1**: https://blockchair.com/bitcoin/addresses?q=balance(1000000..)&s=balance(asc)# ?  

---

## 1 answers

### Answer by username_2 on 2021-01-07. Score: 3 | Accepted answer

Google Cloud provides a dataset for most public blockchains, including bitcoin. You can directly query the dataset via their BigQuery Tool - you can use standard SQL

Bitcoin Dataset on GCP:

<https://console.cloud.google.com/marketplace/product/bitcoin/crypto-bitcoin?filter=solution-type:dataset&id=7fd60425-cb95-4a58-b59f-ab3789642844>


---

