search

duneanalytics / spellbook

SQL views for Dune
Other
1.18k stars 1.13k forks source link

tokens_optimism.balances does not account for WETH redemption #5897

Open MarcoVugts opened 6 months ago

MarcoVugts commented 6 months ago

tokens_optimism.balances does not seem account for WETH redemption

example 0xc45a287dd70aa272519439b845fb18afcbe3805c latest balance in table = 0.6 actual 0

this event "Withdrawal" might need to be included in the balance calculation https://optimistic.etherscan.io/tx/0x39cd77fcdec1b31ebdd2370b8286f20bb45101427087b917cccf7aeabca538ec

jeff-dude commented 5 months ago

fyi @aalan3 @couralex6