ACCOUNT_ADDRESS | MINT | LATEST_BALANCE | LAST_UPDATED | |
|---|---|---|---|---|
1 | 8M97jkdr4rJtPnQ4yQ9stD6qVwaUvjrBdDPDbHJnPJLf | he1iusmfkpAdwvxLNGV8Y1iSbj4rUy6yMhEA3fotn9A | 10841.434003985 | 2025-04-10 07:30:34.000 |
2 | 77t6Fi9qj4s4z22K1toufHtstM8rEy7Y3ytxik7mcsTy | Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB | 10577194.888748 | 2025-04-10 06:41:20.000 |
osk546008 Account Balances V3 - Optimization to be mentioned in Article
Updated 2025-04-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
t.ACCOUNT_ADDRESS,
t.MINT,
t.BALANCE AS latest_balance,
t.BLOCK_TIMESTAMP AS last_updated
FROM
solana.core.fact_token_balances t
INNER JOIN (
SELECT
ACCOUNT_ADDRESS,
MAX(BLOCK_TIMESTAMP) AS max_timestamp
FROM
solana.core.fact_token_balances
WHERE
ACCOUNT_ADDRESS IN ('8M97jkdr4rJtPnQ4yQ9stD6qVwaUvjrBdDPDbHJnPJLf', '77t6Fi9qj4s4z22K1toufHtstM8rEy7Y3ytxik7mcsTy')
GROUP BY
ACCOUNT_ADDRESS
) m
ON t.ACCOUNT_ADDRESS = m.ACCOUNT_ADDRESS
AND t.BLOCK_TIMESTAMP = m.max_timestamp
WHERE
t.ACCOUNT_ADDRESS IN ('8M97jkdr4rJtPnQ4yQ9stD6qVwaUvjrBdDPDbHJnPJLf', '77t6Fi9qj4s4z22K1toufHtstM8rEy7Y3ytxik7mcsTy')
Last run: 18 days ago
2
276B
111s