Avatar
Alex Bit
9db334a465cc3f6107ed847eec0bc6c835e76ba50625f4c1900cbcb9df808d91
Building https://bitcoinisdata.com Twitter: @alex_bit_ Substack: bitcoinisdata.substack.com

Conhecem algum site ou ferramenta para fazer pesquisas dos textos do OP_RETURN?

Estou cogitando construir um site para isso, caso ainda não exista.

No subtle hints from nostr:npub15dqlghlewk84wz3pkqqvzl2w2w36f97g89ljds8x6c094nlu02vqjllm5m about MSTR purchases this Sunday morning?

It’s the first time in 10 weeks.

Sem indiretas do @saylor sobre compras da MSTR nesta manhã de domingo?

É a primeira vez em 10 semanas.

Mais de duzentos campos de dados e métricas relacionados ao bitcoin estão disponíveis para download na API do nostr:nprofile1qyt8wumn8ghj7etyv4hzumn0wd68ytnvv9hxgtcppemhxue69uhkummn9ekx7mp0qyw8wumn8ghj7mn0wd68yttsw43zuum9d45hxmmv9ejx2a30qywhwumn8ghj7mn0wd68ytnzd96xxmmfdejhytnnda3kjctv9uq3kamnwvaz7tmwdaehgu3wdaexzmn8v4cxjmrv9ejx2a30qyghwumn8ghj7mn0wd68ytnhd9hx2tcprpmhxue69uhhyetvv9ujucm4wfex2mn59en8j6f0qy2hwumn8ghj7un9d3shjtnyv9kh2uewd9hj7qgewaehxw309aex2mrp0yh8xmn0wf6zuum0vd5kzmp0qqsr7tx4dqexjzuusuw30wgr88y4pnj4ufe08du244mjgcdgpvsch5gch7d9k .

nostr:nevent1qvzqqqqqqypzq0ev645ry6gtnjr369aeqvuuj5xw2h389uah32khwfrp4q9jrz73qyt8wumn8ghj7etyv4hzumn0wd68ytnvv9hxgtcppemhxue69uhkummn9ekx7mp0qywhwumn8ghj7mn0wd68ytnzd96xxmmfdejhytnnda3kjctv9uqzqkxtl852vryn8dt930vsc476nj2ft3wchfewvpu9k722vjt36fx5vk7ur7

Liberei hoje uma série de novos gráficos no nostr:nprofile1qyt8wumn8ghj7etyv4hzumn0wd68ytnvv9hxgtcppemhxue69uhkummn9ekx7mp0qyw8wumn8ghj7mn0wd68yttsw43zuum9d45hxmmv9ejx2a30qywhwumn8ghj7mn0wd68ytnzd96xxmmfdejhytnnda3kjctv9uq3kamnwvaz7tmwdaehgu3wdaexzmn8v4cxjmrv9ejx2a30qyghwumn8ghj7mn0wd68ytnhd9hx2tcprpmhxue69uhhyetvv9ujucm4wfex2mn59en8j6f0qy2hwumn8ghj7un9d3shjtnyv9kh2uewd9hj7qgewaehxw309aex2mrp0yh8xmn0wf6zuum0vd5kzmp0qqsr7tx4dqexjzuusuw30wgr88y4pnj4ufe08du244mjgcdgpvsch5gch7d9k :

Tudo sobre a distribuição da quantidade e do saldo dos UTXOs ao longo do tempo, segmentados por tipo de transação do Bitcoin.

Gráficos interativos aqui:

https://bitcoinisdata.com/utxo/

https://bitcoinisdata.com/utxo_balances/

nostr:nevent1qvzqqqqqqypzq0ev645ry6gtnjr369aeqvuuj5xw2h389uah32khwfrp4q9jrz73qyt8wumn8ghj7etyv4hzumn0wd68ytnvv9hxgtcppemhxue69uhkummn9ekx7mp0qywhwumn8ghj7mn0wd68ytnzd96xxmmfdejhytnnda3kjctv9uqzqa05vun8p2n0jvhzs5ce6tmrl4jye98puunmquaelxdwk3g6pu06xnu4pv

Atualmente existem 185 milhões de UTXOs no total.

Dando um chute calculado de que cada bitcoiner deve controlar no mínimo uns 20 UTXOs, pode-se estimar a quantidade de bitcoiners em no máximo 10 milhões (185e6 / 20).

Essa é uma boa medida de quão estamos cedo na curva de adoção do bitcoin.

O bitcoin ainda é uma criança.

Gráficos interativos aqui: https://bitcoinisdata.com/utxo/

Laser, since you’re already down this rabbit hole, it’s worth checking out Darko Velcek’s work. He publishes weekly on YouTube, BitChute, and Rumble, and he tends to be quite repetitive. If you watch any one of his videos, you’ll more or less get the main idea.

Sim, os ETFs bagunçam um pouco a análise. A situação é similar aos endereços de exchanges, que fazem a custódia para milhares de clientes. Não há como saber por quanto tempo eles mantiveram as coins.

No caso do nostr:nprofile1qyt8wumn8ghj7etyv4hzumn0wd68ytnvv9hxgtcppemhxue69uhkummn9ekx7mp0qyw8wumn8ghj7mn0wd68yttsw43zuum9d45hxmmv9ejx2a30qywhwumn8ghj7mn0wd68ytnzd96xxmmfdejhytnnda3kjctv9uq3kamnwvaz7tmwdaehgu3wdaexzmn8v4cxjmrv9ejx2a30qyghwumn8ghj7mn0wd68ytnhd9hx2tcprpmhxue69uhhyetvv9ujucm4wfex2mn59en8j6f0qy2hwumn8ghj7un9d3shjtnyv9kh2uewd9hj7qgewaehxw309aex2mrp0yh8xmn0wf6zuum0vd5kzmp0qqsr7tx4dqexjzuusuw30wgr88y4pnj4ufe08du244mjgcdgpvsch5gch7d9k , para STH<1m é o saldo de BTCs de todos os UTXOs que tem menos de um mês de vida. Se o UTXO foi criado e não movimentado há mais do que um mês, o saldo dele já sai dessa conta e vai para a próxima categoria.

Não existe filtro para excluir ETFs ou exchanges. Até tentei fazer isso criando um banco de dados de endereços "famosos", usando o Rich List do Bitinfocharts, por exemplo, mas desisti. Esse é um jogo de gato e rato que não acaba nunca. Exchange e ETFs estão criando novos endereços e movimentando seus fundos diariamente, é um trabalho de investigação colossal.

O Sani Exp do twitter tenta fazer isso, ele é expert em identificar a titularidade de endereços, e mesmo ele não consegue identificar 100% dos endereços.

It's been a while since I posted an update

So for anyone wondering I'm in the middle of R&D and trying out two major tasks:

- Fjall the key value store instead of Sanakirja

- Extracting and improving the parsing part (think creating a database from the blocks) from the "parser" crate (or folder, in the v0.5 codebase) which would end up being only a "computer" now (and thus a more organized codebase with 4 major parts: iterator, parser, computer and server)

Both have the same goal which is massively improve the self-hosting experience

The latter is going well I think and is looking like a good base for a mempool.space like database/explorer/whatever (which was kind of already needed and there but in the right shape)

The reason for doing is because up to the v0.5 the databases are stateful, by that I mean that when you compute a block you can't go back as the databases have the state at a current height, it's to save disk space since sanakirja is very demanding on this side but had the disadvantage is the need to recompute the databases again each time we need to start from the beginning (because of a new dataset for example) which is a lot (like a LOT) of disk writes (and time !)

So the goal is to have an append only database instead which is pretty much one and done like the chain itself (and no I can't just use the chain, it's too slow)

The former on the other hand, isn't going as well as I hoped, reads and writes are okay, the space needed is absolutely great the database is tiny but the RAM usage is quite high (12-13 GB at block 400 000 which is not great) with fjall. I'll do more research and see what I can do with fjall but also trying out sanakirja with the new code and maybe even manually with mmaps by hand if none of them satisfy the requirements.

Again the reason for this is to limit disk usage as it's currently very very high and this takes priority over anything else

Overall I'm happy with my progress, you can check the current state of the extracted parser (named "bitbase") here: https://github.com/kibo-money/kibo/tree/v0.6-fjall/src/crates/bitbase

Please note that I might change to branch's name so the link might break at some point

nostr:nevent1qvzqqqqqqypzp963hhzdztlkunxxkcd3qtm3u3z77fzmeqct7s90v4n2dgjxzd7xqqsfksjccf5hnxymul6pz03w7pwfah59hwjw55ng2del4h3v7wnw3wq0khfvz

I think kibo is already fantastic in its current state, specially for the self holster. It uses so little resources (RAM) than other benchmarks.

If you can make it even faster/performant, it would be great.

Thanks for your service man.

You graduate only after a FULL bitcoin cycle, surviving the bear market.

See you in 2028.

Accepting bitcoin requires a lot of humility. It requires abandoning all prejudices and learning something entirely new from scratch.

If you managed to do that, congratulations.

Every Bitcoiner has the same story: they could have bought it at a fraction of the current price but were too arrogant and didn’t. That’s why it is said that everyone buys bitcoin at the price they deserve.

Aceitar o bitcoin requer muita humildade. Requer abandonar todos os preconceitos e aprender do zero algo totalmente novo.

Se conseguiu fazer isso, parabéns.

Todo bitcoiner passa pela mesma história: poderia ter comprado a uma fração do preço atual, mas foi arrogante e não o fez. Por isso, diz-se que cada um compra bitcoin ao preço que merece.