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

# Stablecoin Transfers (Tron)

> Stablecoin transfer events on Tron

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>
  </>;

export const PrepackagedEnrichedCtaCard = ({href, title = "Upgrade to the enriched dataset"}) => <Card title={title} icon="info" href={href}>
    Skip manual reconstruction. The enriched version packages attribution and methodology so you can move from raw data to insights faster.
  </Card>;

The `stablecoins_tron.transfers` table contains curated stablecoin transfer records on Tron.

One row represents one TRC20 transfer event at event-log granularity.

<PrepackagedEnrichedCtaCard href="/data-catalog/curated/stablecoins/activity-enriched/stablecoins-tron-activity-enriched" />

It includes both `VARBINARY` (0x) and `VARCHAR` (base58) address/hash representations.

## Table schema

| Column                     | Type        | Description                           |
| -------------------------- | ----------- | ------------------------------------- |
| `blockchain`               | `VARCHAR`   | Chain name (`tron`)                   |
| `block_month`              | `DATE`      | First day of month (partition column) |
| `block_date`               | `DATE`      | Transaction date                      |
| `block_time`               | `TIMESTAMP` | Transaction timestamp                 |
| `block_number`             | `BIGINT`    | Block number                          |
| `tx_hash`                  | `VARBINARY` | Transaction hash (0x)                 |
| `evt_index`                | `BIGINT`    | Event index                           |
| `trace_address`            | `VARCHAR`   | Trace address (nullable)              |
| `token_standard`           | `VARCHAR`   | Token standard (`trc20`)              |
| `token_address`            | `VARCHAR`   | Token contract address (base58)       |
| `token_symbol`             | `VARCHAR`   | Token symbol                          |
| `currency`                 | `VARCHAR`   | ISO 4217 currency code                |
| `amount_raw`               | `UINT256`   | Raw transfer amount                   |
| `amount`                   | `DOUBLE`    | Decimals-adjusted amount              |
| `price_usd`                | `DOUBLE`    | USD price used for valuation          |
| `amount_usd`               | `DOUBLE`    | USD amount                            |
| `from`                     | `VARBINARY` | Sender address (0x)                   |
| `to`                       | `VARBINARY` | Recipient address (0x)                |
| `unique_key`               | `VARCHAR`   | Unique transfer identifier            |
| `tx_from`                  | `VARBINARY` | Transaction sender (0x)               |
| `tx_to`                    | `VARBINARY` | Transaction receiver (0x)             |
| `tx_index`                 | `BIGINT`    | Transaction index                     |
| `contract_address`         | `VARBINARY` | Token contract (0x)                   |
| `tx_hash_varchar`          | `VARCHAR`   | Transaction hash (base58)             |
| `contract_address_varchar` | `VARCHAR`   | Token contract (base58)               |
| `from_varchar`             | `VARCHAR`   | Sender address (base58)               |
| `to_varchar`               | `VARCHAR`   | Recipient address (base58)            |
| `tx_from_varchar`          | `VARCHAR`   | Transaction sender (base58)           |
| `tx_to_varchar`            | `VARCHAR`   | Transaction receiver (base58)         |

<TableSample tableSchema="stablecoins_tron" tableName="transfers" />

## Sample Queries

```sql theme={null}
SELECT
    t.block_date
    , SUM(t.amount_usd) AS volume_usd
    , COUNT(*) AS transfers
FROM stablecoins_tron.transfers AS t
WHERE t.token_symbol = 'USDT'
    AND t.block_date >= CURRENT_DATE - INTERVAL '30' DAY
GROUP BY t.block_date
ORDER BY t.block_date DESC
```

## Notes

* For partition pruning, filter by `block_month`.