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

> THORChain staking events (legacy) — bond operations.

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_stake_events` table event data for stake on THORChain. This table is partitioned by day.

## Column Descriptions

| **Column**                  | **Type**  | **Description**                           |
| --------------------------- | --------- | ----------------------------------------- |
| **pool\_name**              | varchar   | Name of the liquidity pool                |
| **asset\_tx\_id**           | bigint    | Identifier                                |
| **asset\_blockchain**       | varchar   | Asset Blockchain                          |
| **asset\_address**          | varchar   | Address                                   |
| **asset\_e8**               | bigint    | Asset amount in e8 units                  |
| **stake\_units**            | varchar   | Pool units (LP tokens) received or burned |
| **rune\_tx\_id**            | bigint    | Identifier                                |
| **rune\_address**           | varchar   | Address                                   |
| **rune\_e8**                | bigint    | RUNE amount in e8 units                   |
| **\_ASSET\_IN\_RUNE\_E8**   | bigint    | Asset In Rune E8                          |
| **event\_id**               | bigint    | Event identifier                          |
| **block\_timestamp**        | timestamp | Timestamp of when the block was created   |
| **\_INSERTED\_TIMESTAMP**   | timestamp | Timestamp of the record                   |
| **fact\_stake\_events\_id** | bigint    | Surrogate key for the fact record         |
| **day**                     | timestamp | Date of the 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_stake_events" />