> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# thorchain.defi_pool_balance_change_events

> THORChain pool balance change events — triggered by swaps, adds, and withdrawals.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table Description

The `thorchain.defi_pool_balance_change_events` table event data for pool balance change on THORChain. This table is partitioned by day.

## Column Descriptions

| **Column**                                  | **Type**      | **Description**                         |
| ------------------------------------------- | ------------- | --------------------------------------- |
| **asset**                                   | varchar       | Asset identifier                        |
| **rune\_amt**                               | varchar       | Rune Amt                                |
| **rune\_add**                               | varchar       | Rune Add                                |
| **asset\_amt**                              | varchar       | Asset Amt                               |
| **asset\_add**                              | varchar       | Asset Add                               |
| **reason**                                  | varchar       | Reason                                  |
| **event\_id**                               | bigint        | Event identifier                        |
| **block\_timestamp**                        | timestamp     | Timestamp of when the block was created |
| **rune\_amount**                            | decimal(38,0) | Amount in RUNE                          |
| **asset\_amount**                           | decimal(38,0) | Amount of asset                         |
| **block\_time**                             | timestamp     | Timestamp of when the block was created |
| **block\_month**                            | timestamp     | Block Month                             |
| **\_inserted\_timestamp**                   | timestamp     | Timestamp of the record                 |
| **fact\_pool\_balance\_change\_events\_id** | bigint        | Surrogate key for the fact record       |
| **dim\_block\_id**                          | bigint        | Reference to the block dimension table  |
| **inserted\_timestamp**                     | timestamp     | Time when the record was inserted       |
| **modified\_timestamp**                     | timestamp     | Time when the record was last modified  |

## Table Sample

<TableSample tableSchema="thorchain" tableName="defi_pool_balance_change_events" />
