search

scaffold-eth / buidlguidl-v3

https://app.buidlguidl.com/
MIT License
14 stars 18 forks source link

Cohorts total streamed calculation #103

Closed Pabl0cks closed 3 weeks ago

Pabl0cks commented 1 month ago

Comparing total withdrawn data from buidlguidl website with streamogator I found some Cohorts with different data.

Here are the details of the difference:

Cohort Bg hackers BG streamed streamo hackers streamo streamed ETH difference Builders difference
Main Hacker House 14 60.82 15 38.44 22.38 1
Play Full 13 13.58 13 8.21 5.37 0
Infrastructure 4 7.74 4 5.74 2 0
BG Outreach 3 14 3 10.63 3.37 0
Not Just Notfellows 7 6.98 7 5.95 1.03 0
Security & Optimizooors 2 2.5 2 1.5 1 0
Autonomous Worlds 7 9.49 7 5.99 3.5 0
ZK & Cryptography 15 23.65 14 18.75 4.9 1

Digging a bit into the withdrawal data, found the correct value was streamogator's.

I think the reason of the difference is there are duplicated builders (builders added a couple of times onchain) in these cohorts, and we are counting the withdrawn ETH twice for those builders.

Example:

There is a couple of Cohorts with 1 builder difference, but haven't figured out yet the reason, but in that case the correct data is in BG website.

carletex commented 3 weeks ago

Just ran a script to remove the duplicates from the BG indexer. It's looking good now!

Could you take a look? Let's see if this doesn't happen again with new withdraws... if not, something might be wrong with the indexer script.

Pabl0cks commented 3 weeks ago

Just ran a script to remove the duplicates from the BG indexer. It's looking good now!

Could you take a look? Let's see if this doesn't happen again with new withdraws... if not, something might be wrong with the indexer script.

It's looking great! TYSM!!

Closing 👌