> ## 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" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.