Skip to main content
The sql_table_<chain>_get_balances_at_timestamp function calculates precise token balances for any list of addresses at a specific point in time. It combines the daily balance snapshot with intraday transaction changes using a Base + Delta approach: Final Balance = EOD Snapshot + Sum(Credits - Debits since snapshot) This is useful when daily snapshots are not granular enough and you need balances at a specific hour or minute.

Function Details

Chain Coverage

Usage

For EVM chains, input addresses are automatically lowercased. For non-EVM chains (SUI, Aptos), addresses are used as-is.

Example: Portfolio balance at a specific time

Return Columns