ClickHouse / ClickHouse/CryptoHouse
pre/post _token_balances check failed
- Dominant language
- TypeScript
- Stars
- 68
- Forks
- 9
- PR merge metrics
- No merged PRs in 30d
Description
**SELECT * FROM solana.transactions WHERE (block_timestamp = '2024-11-29 18:34:10' AND signature = '4xcGyoGUFB9qkJP1Hnnaey1512nPZYUAqY8k7CHfw1gRt1FnptoELEVGDd63WqatYFeBUK8rq6kQmdf2b4KFzByZ')**
>[{"account_index":"0","mint":"So11111111111111111111111111111111111111112","owner":"5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1","amount":0,"decimals":"0"},{"account_index":"0","mint":"AK9yVoXKK1Cjww7HDyjYNyW5FujD3FJ2xbjMUStspump","owner":"5Q544fKrFoe6tsEbD7S8EmxGTJYAKtTVhAW5Q5pge4j1","amount":0,"decimals":"0"},{"account_index":"0","mint":"So11111111111111111111111111111111111111112","owner":"5Zdi8RJXyMGZJ6BfqmuM7PnzDLA8ie32f2kQPgwVJV9h","amount":0,"decimals":"0"},{"account_index":"0","mint":"AK9yVoXKK1Cjww7HDyjYNyW5FujD3FJ2xbjMUStspump","owner":"5Zdi8RJXyMGZJ6BfqmuM7PnzDLA8ie32f2kQPgwVJV9h","amount":0,"decimals":"0"}]
If you cross check with [solscan.io](https://solscan.io/tx/4xcGyoGUFB9qkJP1Hnnaey1512nPZYUAqY8k7CHfw1gRt1FnptoELEVGDd63WqatYFeBUK8rq6kQmdf2b4KFzByZ#tokenBalanceChange), token balances seem off.
**Does the view need a materialized view?**
No
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.