The ERC20 (BEP-20) tokens transfers table contains the details of all transfer events of ERC20 tokens on the BSC network.

It includes information such as the sender and receiver addresses, the amount of tokens transferred, the transaction hash, and the block timestamp.

Query

Stablecoin transfers on BSC.

select

    date_trunc('month', block_timestamp) as date,

    token_symbol,

    sum(amount) as volume

from

    bsc.assets.erc20_token_transfers

where

    1 = 1

    and block_timestamp >= '2022-01-01'

    and token_address IN (

        '0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d', --  USDC

        '0x55d398326f99059ff775485246999027b3197955' --  BSC USD

    )

    group by 1,2

Table Columns

Column NameDescriptionExample
from_addressAddress where the token is being transferred from.0x107bbf40dce15b5f98f408c91f7158d36b764721
to_addressAddress where the token is being transferred to.0x804678fa97d91b974ec2af3c843270886528a9e6
token_addressToken address of the asset transferred.0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82
token_nameName of the asset transferred.PancakeSwap Token
token_symbolSymbol of the asset transferred.Cake
raw_amountAmount of tokens moved (unnormalized).8.565324338609242e+17
raw_amount_strAmount of tokens moved (unnormalized) in string.856532433860924195
amountAmount of token moved, normalized.0.8565324338609241
amount_strAmount of token moved, normalized in string.0.8565324339
usd_amountUSD value of the amount of tokens transferred.16.950776866107688
usd_exchange_rateUSD value of the token at the time of transfer.19.79
transaction_from_addressThe address of the sending party of this transaction.0x7db9de58c7e0842aee80aba76098e9102b4850a7
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address).0x107bbf40dce15b5f98f408c91f7158d36b764721
transaction_hashTransaction hash that this transfer belongs to.0x767bb5057651e4a20e1c22b7e505bd6c258a56e270d7fb5201854a3303830d2f
log_indexThe log index that corresponds to this transfer.514
block_timestampThe time when the block that contains this transaction was included on the blockchain.2021-10-22 20:00:51+00:00
block_numberThe block number that the corresponding transaction of this transfer belongs to.12001742
block_hashThe block hash that the corresponding transaction of this transfer belongs to.0x52614b5079262ea8b2133a58c2d9dcb2cefba7f6cd8ebb4959c6ff380d8dd89d
unique_idUnique id generated to each transfer.txn-0x767bb5057651e4a20e1c22b7e505bd6c258a56e270d7fb5201854a3303830d2f_log_index-514