duneanalytics / duneanalytics/spellbook
[BUG] records with empty token_mint_address in solana_utils.daily_balances
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 1.5k
- Forks
- 1.4k
- Avg merge
- 3d 16h
- Merged PRs (30d)
- 22
Description
Description
solana_utils.daily_balances table contains records with empty token_mint_address. Moreover it can contain multiple records for the same day and token_address with different data.
select * from solana_utils.daily_balances where address = '5JP5zgYCb9W37QQLgAHRHuinFLrKt87akDY1CgZoTPzr' and day between timestamp '2026-02-21' and timestamp '2026-02-22' -- and token_mint_address = 'So11111111111111111111111111111111111111112' order by day desc
Current behavior
Expected behavior
Only 1 record per day / address
Impacted model(s)
Possible solution
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Locate the SQL definition or upstream model for solana_utils.daily_balances and reproduce the supplied query for the affected address and date range. Trace how duplicate rows and empty token_mint_address values are produced; done means the table contains only one record per day and address, with the reported issue resolved.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100