erc20.token_balances is more than 2x incorrect (Dune v1 incorrect, Dune v2 query is accurate)

Looking at a particular wallet as an example, erc20.token_balances is quite different from the actual value and the v2 equivalent (balances_ethereum.erc20_latest) https://etherscan.io/tokenholdings?a=0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 -> Says amount = 212601793.521433 SELECT * FROM erc20.token_balances_latest WHERE wallet_address = '\xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7' AND token_address = '\xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -> Says amount_raw = 119193682814138 SELECT * FROM balances_ethereum.erc20_latest WHERE wallet_address = '0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7' AND token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -> Says amount_raw = 212620873558753

Please authenticate to join the conversation.

Upvoters
Status

Open

Board

Bugs

Tags

Spellbook

Date

Almost 4 years ago

Author

Kunal Modi

Subscribe to post

Get notified by email when there are changes.