Account Balance History

A history of a user’s account balances for their linked Plaid accounts.

Storage

Table: prod-txn-transactions

Location: us-east-2

Keys

  • PK - BALANCE#<user_id>

  • SK - ACCOUNT#<acct_id>#<date>

Attributes

  • user_id - Floatme user_id

  • account_id - Plaid account id

  • available

  • current

  • limit

  • iso_cc - currency code

  • updated_date - date the balance was received from Plaid and stored

  • ttl - Time to live, defaults to 32 days currently

Query Patterns

Query Index Conditions

Get account balance history by user and account ID

Primary

PK = BALANCE#user_id, SK = ACCOUNT#acct_id#