Bitcoin Forum
July 07, 2024, 11:54:20 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: latest UTXO databases received  (Read 169 times)
accountnujen (OP)
Newbie
*
Offline Offline

Activity: 3
Merit: 0


View Profile
November 04, 2022, 02:39:03 AM
 #1

There are many repositories that allow you to turn blockchain into UTXO. But I can't find where I could download ready-made UTXOs. I only find instructions on how to get such a database myself. Bitcoin Core predicted that it would take 55 hours to download the database, which is certainly a lot, so I'd like to ask if you know any repositories where they put the latest UTXO databases received?
Little Mouse
Legendary
*
Offline Offline

Activity: 2100
Merit: 2040


Marketing Campaign Manager |Telegram ID- @LT_Mouse


View Profile WWW
November 04, 2022, 03:32:56 AM
Last edit: November 05, 2022, 04:14:19 AM by Little Mouse
 #2

Did you mean the transaction history? If so, I have never seen such a copy anywhere which can be used for faster sync. You have to download by yourself, have to wait that 55 hours. It took me more times when I synced my Bitcoin Core.

Edit-
My bad, I got you wrong.

██████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
██████████████████████
.SHUFFLE.COM..███████████████████████
███████████████████████
███████████████████████
███████████████████████
███████████████████████
█████████████████████
████████████████████
██████████████████████
████████████████████
██████████████████████
███████████████████████
███████████████████████
███████████████████████
███████████████████████
███████████████████████
███████████████████████
██████████████████████
██████████████████████
██████████████████████
███████████████████████
███████████████████████
███████████████████████
███████████████████████
███████████████████████
███████████████████████
███████████████████████
.
...Next Generation Crypto Casino...
pooya87
Legendary
*
Offline Offline

Activity: 3500
Merit: 10703



View Profile
November 04, 2022, 03:56:04 AM
 #3

Bitcoin Core predicted that it would take 55 hours to download the database,
A full node like bitcoin core does not receive UTXO database, it receives the blockchain from the first block and it verifies each and every one of them to build the UTXO database itself. This is why it takes longer than a simple download of a file.
This is how Bitcoin is designed, it is trustless meaning you have to verify everything yourself instead of trusting a third party.

The blockchain size is always increasing but UTXO database size (chainstate) fluctuates. It can go up and down but generally it goes up. You can see the size chart here: https://statoshi.info/d/000000009/unspent-transaction-output-set?orgId=1&refresh=10m&from=now-1y&to=now

.
.BLACKJACK ♠ FUN.
█████████
██████████████
████████████
█████████████████
████████████████▄▄
░█████████████▀░▀▀
██████████████████
░██████████████
████████████████
░██████████████
████████████
███████████████░██
██████████
CRYPTO CASINO &
SPORTS BETTING
▄▄███████▄▄
▄███████████████▄
███████████████████
█████████████████████
███████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
███████████████████████
█████████████████████
███████████████████
▀███████████████▀
█████████
.
PawGo
Legendary
*
Offline Offline

Activity: 952
Merit: 1369


View Profile
November 04, 2022, 11:41:24 AM
 #4

Maybe look there: http://blockdata.loyce.club/ (more details: https://bitcointalk.org/index.php?topic=5307550.0)

Depending on the connection speed (and your computer, especially if you have SSD or slow HDD) it may take less than 55h, I think 24h is realistic scenario.
BitMaxz
Legendary
*
Offline Offline

Activity: 3304
Merit: 3046


BTC price road to $80k


View Profile WWW
November 04, 2022, 05:26:18 PM
 #5

UTXO means unspent transaction output blockchair.com should have this data if you want to download them you can check this link below.


- https://gz.blockchair.com/bitcoin/outputs/

This is monthly seperated compared to loycev download links but you can use download manager like IDM to grab them all and download then extract them using winrar on the same folder.

█▀▀▀











█▄▄▄
▀▀▀▀▀▀▀▀▀▀▀
e
▄▄▄▄▄▄▄▄▄▄▄
█████████████
████████████▄███
██▐███████▄█████▀
█████████▄████▀
███▐████▄███▀
████▐██████▀
█████▀█████
███████████▄
████████████▄
██▄█████▀█████▄
▄█████████▀█████▀
███████████▀██▀
████▀█████████
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
c.h.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
▀▀▀█











▄▄▄█
▄██████▄▄▄
█████████████▄▄
███████████████
███████████████
███████████████
███████████████
███░░█████████
███▌▐█████████
█████████████
███████████▀
██████████▀
████████▀
▀██▀▀
n0nce
Hero Member
*****
Offline Offline

Activity: 882
Merit: 5830


not your keys, not your coins!


View Profile WWW
November 04, 2022, 07:11:06 PM
 #6

There are many repositories that allow you to turn blockchain into UTXO.
For example? I'm trying to understand your question. You cannot turn the blockchain into a UTXO; and you also can't 'turn it into' the UTXO set either. The UTXO set (chainstate database) is built by syncing the blockchain through Bitcoin core and updating the UTXO set block by block.

You could do that from a downloaded snapshot of the blockchain by scanning it, but in combination with the download time for that snapshot, it won't be much faster than a regular full blockchain sync.

I'm not completely sure what Loyce's archives at http://blockdata.loyce.club/outputs/ contain; the chainstate DB is roughly 5GB in size at the moment and those are <100MB each.

█▀▀▀











█▄▄▄
▀▀▀▀▀▀▀▀▀▀▀
e
▄▄▄▄▄▄▄▄▄▄▄
█████████████
████████████▄███
██▐███████▄█████▀
█████████▄████▀
███▐████▄███▀
████▐██████▀
█████▀█████
███████████▄
████████████▄
██▄█████▀█████▄
▄█████████▀█████▀
███████████▀██▀
████▀█████████
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
c.h.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
▀▀▀█











▄▄▄█
▄██████▄▄▄
█████████████▄▄
███████████████
███████████████
███████████████
███████████████
███░░█████████
███▌▐█████████
█████████████
███████████▀
██████████▀
████████▀
▀██▀▀
accountnujen (OP)
Newbie
*
Offline Offline

Activity: 3
Merit: 0


View Profile
November 05, 2022, 02:19:11 AM
 #7

Thank you so much to everyone who responded. I really appreciate your attention.

Did you mean the transaction history? If so, I have never seen such a copy anywhere which can be used for faster sync. You have to download by yourself, have to wait that 55 hours. It took me more times when I synced my Bitcoin Core.
No, I don't need transaction history. I only need the wallets and their contents.

A full node like bitcoin core does not receive UTXO database, it receives the blockchain from the first block and it verifies each and every one of them to build the UTXO database itself. This is why it takes longer than a simple download of a file.
This is how Bitcoin is designed, it is trustless meaning you have to verify everything yourself instead of trusting a third party.
The blockchain size is always increasing but UTXO database size (chainstate) fluctuates. It can go up and down but generally it goes up. You can see the size chart here: https://statoshi.info/d/000000009/unspent-transaction-output-set?orgId=1&refresh=10m&from=now-1y&to=now
Yes, I know that. I'm not interested in the whole database. I'm interested in a database that has up-to-date information. I'm not chasing constant updates. If it has information from a week ago, that's fine with me.

Based on your description, do you actually mean synced Bitcoin Core directory? If so, someone upload pruned version of Bitcoin Core directory at https://prunednode.today/.
I thought that's what I needed. I don't know much about Bitcoin, but if I understood correctly, there are no old wallets in this file. Long story short, I could not find this wallet 1ANUrCXvHsPUbdcSdYgkyCG9bgEQfbqYRG . It now has 0.0045 BTC. Judging by the description, it is a trimmed DB. It doesn't work for me. I need wallets for all time.

Maybe look there: http://blockdata.loyce.club/ (more details: https://bitcointalk.org/index.php?topic=5307550.0)

Depending on the connection speed (and your computer, especially if you have SSD or slow HDD) it may take less than 55h, I think 24h is realistic scenario.
Not exactly. There is a database with transactions. I don't need transactions. Everything else is bigger. I need addresses and the number of coins on them. If it is possible, only addresses that have some number of coins.

UTXO means unspent transaction output blockchair.com should have this data if you want to download them you can check this link below.


- https://gz.blockchair.com/bitcoin/outputs/

This is monthly seperated compared to loycev download links but you can use download manager like IDM to grab them all and download then extract them using winrar on the same folder.
I have counted and there are over 164GB. I don't think that's what I need.
Code:
let summ = 0;
let arr = document.querySelector("pre").childNodes;

document.querySelectorAll("a").forEach((e) => { e.parentNode.removeChild(e)});
for (const e of arr) {
lastword = e.nodeValue.toString().split(" ").pop().replace(/\s+/g, '');
if(lastword.slice(-1) === "M") {
let vaul = Number(lastword.slice(0, -1));
summ += vaul;
}

}
console.log(summ); // 164247
For example? I'm trying to understand your question. You cannot turn the blockchain into a UTXO; and you also can't 'turn it into' the UTXO set either. The UTXO set (chainstate database) is built by syncing the blockchain through Bitcoin core and updating the UTXO set block by block.

You could do that from a downloaded snapshot of the blockchain by scanning it, but in combination with the download time for that snapshot, it won't be much faster than a regular full blockchain sync.

I'm not completely sure what Loyce's archives at http://blockdata.loyce.club/outputs/ contain; the chainstate DB is roughly 5GB in size at the moment and those are <100MB each.

It seems to me to be the same as the previous one. That's 164GB. How you get 5GB is unclear to me... Maybe I'm wrong.


Let's do it again. I need a database with all the addresses and coins in them.
For example:
14WQD11n8uMefspciqvpTfUv8fzQZnM46E,0.01840969
167ZWTT8n6s4ya8cGjqNNQjDwDGY31vmHg,8999.00610137
...
and so on
pooya87
Legendary
*
Offline Offline

Activity: 3500
Merit: 10703



View Profile
November 05, 2022, 03:50:25 AM
 #8

Not exactly. There is a database with transactions. I don't need transactions. Everything else is bigger. I need addresses and the number of coins on them. If it is possible, only addresses that have some number of coins.
https://bitcointalk.org/index.php?topic=5254914.0
I wonder why though!

.
.BLACKJACK ♠ FUN.
█████████
██████████████
████████████
█████████████████
████████████████▄▄
░█████████████▀░▀▀
██████████████████
░██████████████
████████████████
░██████████████
████████████
███████████████░██
██████████
CRYPTO CASINO &
SPORTS BETTING
▄▄███████▄▄
▄███████████████▄
███████████████████
█████████████████████
███████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
███████████████████████
█████████████████████
███████████████████
▀███████████████▀
█████████
.
accountnujen (OP)
Newbie
*
Offline Offline

Activity: 3
Merit: 0


View Profile
November 05, 2022, 05:36:54 AM
 #9

Not exactly. There is a database with transactions. I don't need transactions. Everything else is bigger. I need addresses and the number of coins on them. If it is possible, only addresses that have some number of coins.
https://bitcointalk.org/index.php?topic=5254914.0
I wonder why though!
I've been looking for this for three days. I read a shitload of questions on bitcoin.stackexchange.com, where they only advised me to build UXTO myself, and then to get this table from there. I understood that there must be this table somewhere, but all the ways led me to the fact that I need to get UXTO. I ended up asking the question here, with the goal of finding a ready-made UXTO, and it turned out that the DB I needed was already there. THANK YOU!
LoyceV
Legendary
*
Offline Offline

Activity: 3360
Merit: 16989


Thick-Skinned Gang Leader and Golden Feather 2021


View Profile WWW
November 05, 2022, 07:29:47 AM
 #10

I'm not completely sure what Loyce's archives at http://blockdata.loyce.club/outputs/ contain
Those are daily additions of new transactions, see these samples.

I've been looking for this for three days. I read a shitload of questions on bitcoin.stackexchange.com, where they only advised me to build UXTO myself, and then to get this table from there. I understood that there must be this table somewhere, but all the ways led me to the fact that I need to get UXTO. I ended up asking the question here, with the goal of finding a ready-made UXTO, and it turned out that the DB I needed was already there. THANK YOU!
There's a difference though: the List of all Bitcoin addresses with a balance shows the total balance of each address. If you would parse all UTXOs, you'd get each individual input on each address (many addresses received multiple transactions). If all you need is the balance, the above link is enough.
If there's a demand for daily (or even more frequent) UTXOs lists, I could setup a script to parse them myself from Bitcoin Core. I think the output will be around 4 GB.

n0nce
Hero Member
*****
Offline Offline

Activity: 882
Merit: 5830


not your keys, not your coins!


View Profile WWW
November 05, 2022, 03:42:44 PM
 #11

For example? I'm trying to understand your question. You cannot turn the blockchain into a UTXO; and you also can't 'turn it into' the UTXO set either. The UTXO set (chainstate database) is built by syncing the blockchain through Bitcoin core and updating the UTXO set block by block.

You could do that from a downloaded snapshot of the blockchain by scanning it, but in combination with the download time for that snapshot, it won't be much faster than a regular full blockchain sync.

I'm not completely sure what Loyce's archives at http://blockdata.loyce.club/outputs/ contain; the chainstate DB is roughly 5GB in size at the moment and those are <100MB each.
It seems to me to be the same as the previous one. That's 164GB. How you get 5GB is unclear to me... Maybe I'm wrong.
You can see that via bitcoin-cli gettxoutsetinfo.
Code:
{                                 (json object)
  "height" : n,                   (numeric) The current block height (index)
  "bestblock" : "hex",            (string) The hash of the block at the tip of the chain
  "transactions" : n,             (numeric) The number of transactions with unspent outputs
  "txouts" : n,                   (numeric) The number of unspent transaction outputs
  "bogosize" : n,                 (numeric) A meaningless metric for UTXO set size
  "hash_serialized_2" : "hex",    (string) The serialized hash (only present if 'hash_serialized_2' hash_type is chosen)
  "disk_size" : n,                (numeric) The estimated size of the chainstate on disk
  "total_amount" : n              (numeric) The total amount
}

There are some web dashboards that graph it over time, such as: https://statoshi.info/d/000000009/unspent-transaction-output-set?orgId=1&refresh=10m


List of addresses with balance would be smaller since an address can map to multiple UTXOs.

█▀▀▀











█▄▄▄
▀▀▀▀▀▀▀▀▀▀▀
e
▄▄▄▄▄▄▄▄▄▄▄
█████████████
████████████▄███
██▐███████▄█████▀
█████████▄████▀
███▐████▄███▀
████▐██████▀
█████▀█████
███████████▄
████████████▄
██▄█████▀█████▄
▄█████████▀█████▀
███████████▀██▀
████▀█████████
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
c.h.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
▀▀▀█











▄▄▄█
▄██████▄▄▄
█████████████▄▄
███████████████
███████████████
███████████████
███████████████
███░░█████████
███▌▐█████████
█████████████
███████████▀
██████████▀
████████▀
▀██▀▀
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!