Skip to main content
This model captures all token transfers in Kadena, including token metadata and USD values when available.
This query shows token transfer activity for a specific account over the last 7 days, combining both incoming and outgoing transfers:
with transfer_activity as (
  select chain, transaction_request_key, from_account as address, token_address, amount, block_creation_time
  from kadena.assets.transfers
  where block_creation_time >= current_date - 7
    and from_account = 'k:account-address-here'
  
  union all
  
  select chain, transasto_account as address, token_address, -1*amount as amount, block_creation_time
  from kadena.assets.transfers
  where block_creation_time >= current_date - 7
    and to_account = 'k:account-address-here'
) 

select *
from transfer_activity
order by block_creation_time desc
This query shows the top 10 transfers by USD value over the last 7 days:
select *
from kadena.assets.transfers
where block_creation_time >= current_date - 7
order by usd_amount desc nulls last
limit 10

​
Table Description

Unique Key: unique_id
Column NameDescription
chainThe kadena chain name
chain_idThe unique identifier for the kadena chain
from_accountThe sender account of the transfer
to_accountThe recipient account of the transfer
token_addressThe contract address of the fungible token
token_nameThe name of the token
token_symbolThe symbol of the token
raw_amount_strThe raw token amount as a string
raw_amountThe raw token amount before decimal normalization
amount_strThe normalized token amount as a string
amountThe normalized token amount of the transfer
usd_amountThe USD value of the transfer
usd_exchange_rateThe exchange rate used to calculate the USD value
statusThe status of the transaction
transaction_request_keyUnique identifier for the transaction request
transaction_indexThe index of the transaction within the block
event_indexThe index of the event within the transaction
block_creation_timeTimestamp of the block creation
block_heightThe height of the block containing this transfer
block_hashThe hash of the block containing this transfer
unique_idA unique identifier for the transfer
_created_atThe timestamp when the record was created
_updated_atThe timestamp when the record was last updated
_changed_since_full_refreshIndicates if the record has changed since full refresh
⌘I