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

# Transfers

> Every stablecoin transfer.

Stablecoin transfers are the rows of [`facts.token_transfers`](/docs/catalog/tokens/transfers) whose token is a stablecoin deployment. Join [`dimensions.asset_tokens`](/docs/catalog/assets/registry) on `token_id` to keep those rows and name the stablecoin.

Every column is documented at [Tokens ▸ Transfers](/docs/catalog/tokens/transfers).

## Sample queries

<Warning>
  The transfer table is partitioned on `block_timestamp` and holds billions of rows. Bound that column in every query; without a bound the query reads the whole table.
</Warning>

<Tabs>
  <Tab title="One stablecoin, one day">
    **Read one stablecoin's transfers on a single day.** Cast `value_raw` to `BIGNUMERIC` and divide by `10^decimals` from `dimensions.tokens` to get the token amount.

    ```sql theme={null}
    select
        transfers.block_timestamp,
        transfers.transaction_hash,
        transfers.from_address,
        transfers.to_address,
        cast(transfers.value_raw as bignumeric) / pow(10, tokens.decimals) as amount
    from `facts.token_transfers` as transfers
    join `dimensions.asset_tokens` as deployments
        using (token_id)
    join `dimensions.tokens` as tokens
        on tokens.token_id = transfers.token_id
    where deployments.asset_id = 'usdc'
      and transfers.block_timestamp >= timestamp('2026-08-01')
      and transfers.block_timestamp < timestamp('2026-08-02')
    limit 100
    ```
  </Tab>

  <Tab title="Largest native transfers">
    **Rank the largest native stablecoin transfers in a window.** `bridged_status` keeps natively issued deployments and drops bridged copies.

    ```sql theme={null}
    select
        assets.symbol,
        transfers.block_timestamp,
        transfers.transaction_hash,
        cast(transfers.value_raw as bignumeric) / pow(10, tokens.decimals) as amount
    from `facts.token_transfers` as transfers
    join `dimensions.asset_tokens` as deployments
        using (token_id)
    join `dimensions.assets` as assets
        on assets.asset_id = deployments.asset_id
    join `dimensions.tokens` as tokens
        on tokens.token_id = transfers.token_id
    where assets.asset_type = 'stablecoin'
      and deployments.bridged_status = 'native'
      and transfers.block_timestamp >= timestamp('2026-08-01')
      and transfers.block_timestamp < timestamp('2026-08-08')
    order by amount desc
    limit 20
    ```
  </Tab>
</Tabs>