terencelzwcurly-maroon
Updated 2024-12-12
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with latest_balance_ts as (
select
mint, max(block_timestamp) max_ts
from solana.core.fact_token_balances
where owner = 'EqizHbyapy53Zz6sbr6wk8beza84xPGAMp3uAmWwiUwG'
group by 1)
select
b.*
from latest_balance_ts a
left join solana.core.fact_token_balances b on a.mint = b.mint and a.max_ts = b.block_timestamp