> ## 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_swaps

> THORChain swap records — comprehensive swap data with fees, slip, and routing.

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_swaps` table records all cross-chain native asset swaps executed on THORChain. This table captures swap transactions that allow users to swap native assets across multiple chains without wrapped or pegged tokens.

## Column Descriptions

| **Column**                               | **Type**       | **Description**                         |
| ---------------------------------------- | -------------- | --------------------------------------- |
| **block\_timestamp**                     | timestamp      | Timestamp of when the block was created |
| **block\_id**                            | bigint         | Identifier                              |
| **tx\_id**                               | bigint         | Transaction ID                          |
| **blockchain**                           | varchar        | Source blockchain identifier            |
| **pool\_name**                           | varchar        | Name of the liquidity pool              |
| **from\_address**                        | varchar        | Source address                          |
| **native\_to\_address**                  | varchar        | Address                                 |
| **to\_pool\_address**                    | varchar        | Address                                 |
| **affiliate\_address**                   | varchar        | Address                                 |
| **affiliate\_fee\_basis\_points**        | int            | Affiliate Fee Basis Points              |
| **affiliate\_addresses\_array**          | array(varchar) | Address                                 |
| **affiliate\_fee\_basis\_points\_array** | int            | Affiliate Fee Basis Points Array        |
| **from\_asset**                          | varchar        | Source asset identifier                 |
| **to\_asset**                            | varchar        | Destination asset identifier            |
| **from\_amount**                         | decimal(38,0)  | Amount of source asset                  |
| **to\_amount**                           | decimal(38,0)  | Amount of destination asset             |
| **min\_to\_amount**                      | decimal(38,0)  | Amount value                            |
| **from\_amount\_usd**                    | decimal(20,6)  | USD value                               |
| **to\_amount\_usd**                      | decimal(20,6)  | USD value                               |
| **rune\_usd**                            | decimal(20,6)  | Rune Usd                                |
| **asset\_usd**                           | decimal(20,6)  | Asset Usd                               |
| **to\_amount\_min\_usd**                 | decimal(20,6)  | USD value                               |
| **swap\_slip\_bp**                       | varchar        | Swap slippage in basis points           |
| **liq\_fee\_rune**                       | varchar        | Liquidity fee in RUNE                   |
| **liq\_fee\_rune\_usd**                  | decimal(20,6)  | USD value of liquidity fee in RUNE      |
| **liq\_fee\_asset**                      | varchar        | Liq Fee Asset                           |
| **liq\_fee\_asset\_usd**                 | decimal(20,6)  | Liq Fee Asset Usd                       |
| **streaming\_count**                     | varchar        | Streaming Count                         |
| **streaming\_quantity**                  | varchar        | Streaming Quantity                      |
| **\_TX\_TYPE**                           | varchar        | Tx Type                                 |
| **\_unique\_key**                        | varchar        | Unique Key                              |
| **\_inserted\_timestamp**                | timestamp      | Timestamp of the record                 |
| **fact\_swaps\_id**                      | bigint         | Surrogate key for the swap 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_swaps" />