Wormhole

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 Name	Type	Description
BRIDGE	string	name of bridge (wormhole)
APPLICATION_PROTOCOL_IDS	list[string]	applications used in bridge transfer i.e. "MAYAN", "PORTAL_TOKEN_BRIDGE", etc.
BLOCK_TIMESTAMP	string	timestamp VAA was emitted
TRANSACTION_HASH	string	hash of source or destination transaction
TOKEN_AMOUNT	string	amount of token transferred
TOKEN_DECIMALS	int	decmials of token
TOKEN_ADDRESS	string	address of token transferred
TOKEN_CHAIN_NAME	string	chain of token transferred
TOKEN_TRANSFER_FROM_ADDRESS	string	token transfer from address
TOKEN_TRANSFER_TO_ADDRESS	string	token transfer to address
UNIQUE_ID	string	unique id (chain id + transaction hash)
TOKEN_SYMBOL	string	symbol of token transferred
TOKEN_USD_AMOUNT	string	usd amount of token transferred
STATUS	string	status of token transfer (e.g. completed, refunded, cancelled, etc.)
TOKEN_TRANSFER_FEE	string	bridge fee of token transfer
TOKEN_TRANSFER_GAS_TOKEN_NOTIONAL	string	fee gas notional
TOKEN_TRANSFER_FEE_USD	string	fee usd amount
TOKEN_TRANSFER_FEE_ADDRESS	string	fee address recipient
TOKEN_TRANSFER_FEE_CHAIN	int	fee process chain
SOURCE_CHAIN_NUMBER	int	source transaction chain number
SOURCE_CHAIN	string	source transaction chain
SOURCE_TOKEN_ADDRESS	string	source token address
SOURCE_TOKEN_AMOUNT	string	source token amount
SOURCE_FEE	string	fee of source transaction
SOURCE_GAS_TOKEN_NOTIONAL	string	fee gas usd price
SOURCE_TRANSACTION_HASH	string	source transaction hash
SOURCE_TRANSACTION_FROM	string	source transaction from address
SOURCE_TRANSACTION_TO	string	source transaction to address
DESTINATION_CHAIN_NUMBER	int	destination transaction chain number
DESTINATION_CHAIN	string	destination chain name
DESTINATION_TOKEN_ADDRESS	string	destination transaction token address
DESTINATION_TOKEN_AMOUNT	string	destination transaction token amount
DESTINATION_FEE	string	destination fee
DESTINATION_GAS_TOKEN_NOTIONAL	string	destination gas token usd price
DESTINATION_TRANSACTION_HASH	string	destination transaction hash
DESTINATION_TRANSACTION_FROM	string	destination transaction from address
DESTINATION_TRANSACTION_TO	string	destination transaction to address
EMITTER_ADDRESS	string	wormhole emitter address
EMITTER_CHAIN	string	wormhole emitter chain
SEQUENCE	string	wormhole sequence id
NUMBER_OF_RETRIES	int	refetches for incomplete statueses
_LAST_FETCHED_AT	timestamp	last fetched at for incomplete statuses
_CREATED_AT	timestamp	created at timestamp
_UPDATED_AT	timestamp	updated at timestamp