XRPL Tables Overview

All our tables that contain XRPL-related data have the string ‘xrp’ in their name. To find them yourself, run the following query:

1
SHOW TABLES LIKE '%xrp%'

The result will display the list of tables:

1
┌─name───────────────────┐
2
│ xrp_balances           │
3
│ xrp_balances_shard_v5  │
4
└────────────────────────┘

We can inspect the tables with the commands we learned in Exploration.

Below, we have listed all the XRPL tables with their columns and a brief description of each.

Represents balance changes per address per currency.

• dt (DateTime): The date and time of the balance change
• blockNumber (UInt64): Unique identifier for the block in which the transaction was processed
• balance (Float64): The balance of the asset in the account after the transaction was completed
• oldDt (Nullable(DateTime)): The date and time of the previous balance change
• oldBlockNumber (Nullable(UInt64)): The block number of the previous balance change
• oldBalance (Float64): The previous balance in this currency for this address
• address (String): The owner of the funds
• currency (String): Type of currency used in the transaction
• issuer (Nullable(String)): The issuer of the currency
• issuerCurrency (String): The type of the issued currency
• addressType (String): Enum(NORMAL | SPECIAL) - Indicates if the address is a valid XRPL address or a meta address used for metric purposes
• transactionIndex (UInt64): Position of the transaction that caused the balance change inside the XRPL block
• transactionHash (String): Hash value identifying the transaction that caused the balance change