terencelzwcurly-maroon
    Updated 2024-12-12
    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