At the end of chapter 7, I said sweep the small discrepancies under the rug 😅, well it as because of this...
I am using Dune V2(beta) (it still has some issues but it will be the go to engine very soon, so its best to learn with the new tools), and this time there was some rounding off error somewhere in the erc20_ethereum.evt_Transfer
I finally understood why it won't add up to zero - the transactions from the creator's wallet address are also recorded. Although, I have panic attacks on just accepting that we have negative balances. 😂 If it's practically impossible to have negative balances then there's something we're not surfacing maybe
Really great and detailed explanation, thank you!
You are absolutely right.
At the end of chapter 7, I said sweep the small discrepancies under the rug 😅, well it as because of this...
I am using Dune V2(beta) (it still has some issues but it will be the go to engine very soon, so its best to learn with the new tools), and this time there was some rounding off error somewhere in the erc20_ethereum.evt_Transfer
See the query with V1 https://dune.com/queries/972378
And same query with V2 https://dune.com/queries/972432?d=1
The discrepancy is basically 0.000000017683185664 $WRAB
I finally understood why it won't add up to zero - the transactions from the creator's wallet address are also recorded. Although, I have panic attacks on just accepting that we have negative balances. 😂 If it's practically impossible to have negative balances then there's something we're not surfacing maybe
I reported it, vote it up.
https://feedback.dune.xyz/bugs/p/data-discrepancy-between-v1-and-v2
Alright 🎯. Can I chat you up on Twitter?