Skip to main content

​
Token Transfers

crosschain.bridges.wormhole_transfers provides bridge transfer activity from Wormhole protocol. The underlying data indexed from Wormhole VAAs and Mayan-emitted messages.
Backfills and verification are still ongoing for the wormhole bridge transfers schema

​
Sample Query

Bridges transfer on Wormhole in the last 72 hours 
select 
    date_trunc('hour', block_timestamp) as date,
    destination_chain,
    sum(usd_amount) as usd,
    count(1) as c
from crosschain.bridges.wormhole_transfers
where block_timestamp >= current_timestamp - interval '3 days' 
and status in ('completed', 'confirmed')
group by all 
order by 1 desc;

​
Table Columns

Unique key: block\_timestamp, unique\_id, transaction\_hash
Column NameTypeDescription
bridgeVARCHARname of bridge (wormhole)
application_protocol_idslist[VARCHAR]applications used in bridge transfer i.e. “MAYAN”, “PORTAL_TOKEN_BRIDGE”, etc.
block_timestampVARCHARtimestamp VAA was emitted
transaction_hashVARCHARhash of source or destination transaction
token_amountVARCHARamount of token transferred
token_decimalsBIGINTdecimals of token
token_addressVARCHARaddress of token transferred
token_chain_nameVARCHARchain of token transferred
token_transfer_from_addressVARCHARtoken transfer from address
token_transfer_to_addressVARCHARtoken transfer to address
unique_idVARCHARunique id (chain id + transaction hash)
token_symbolVARCHARsymbol of token transferred
token_usd_amountVARCHARusd amount of token transferred
statusVARCHARstatus of token transfer (e.g. completed, refunded, cancelled, etc.)
token_transfer_feeVARCHARbridge fee of token transfer
token_transfer_gas_token_notionalVARCHARfee gas notional
token_transfer_fee_usdVARCHARfee usd amount
token_transfer_fee_addressVARCHARfee address recipient
token_transfer_fee_chainBIGINTfee process chain
source_chain_numberBIGINTsource transaction chain number
source_chainVARCHARsource transaction chain
source_token_addressVARCHARsource token address
source_token_amountVARCHARsource token amount
source_feeVARCHARfee of source transaction
source_gas_token_notionalVARCHARfee gas usd price
source_transaction_hashVARCHARsource transaction hash
source_transaction_fromVARCHARsource transaction from address
source_transaction_toVARCHARsource transaction to address
destination_chain_numberBIGINTdestination transaction chain number
destination_chainVARCHARdestination chain name
destination_token_addressVARCHARdestination transaction token address
destination_token_amountVARCHARdestination transaction token amount
destination_feeVARCHARdestination fee
destination_gas_token_notionalVARCHARdestination gas token usd price
destination_transaction_hashVARCHARdestination transaction hash
destination_transaction_fromVARCHARdestination transaction from address
destination_transaction_toVARCHARdestination transaction to address
emitter_addressVARCHARwormhole emitter address
emitter_chainVARCHARwormhole emitter chain
sequenceVARCHARwormhole sequence id
number_of_retriesBIGINTrefetches for incomplete statuses
last_fetched_atTIMESTAMP_NTZ(9)last fetched at for incomplete statuses
created_atTIMESTAMP_NTZ(9)created at timestamp
updated_atTIMESTAMP_NTZ(9)updated at timestamp