The layerzero.transfers table contains all cross-chain transfers executed through the LayerZero protocol. Each transfer represents a value transfer event between source and destination chains.

​
Table Schema

Column NameData TypeDescription
timestampUpdatedtimestampTimestamp of the last update
primary_keystringUnique identifier for the transfer
messages_foreign_keystringForeign key reference to the associated message
addr_tostringRecipient address
type_transferstringType of transfer
symbolstringToken symbol
tokenstringToken address
usd_valuedoubleUSD value of the transfer
_updated_attimestampLast update timestamp
_ingested_attimestampIngestion timestamp

​
Sample Query

-- Get the top tokens by volume transferred in the last 24 hours
SELECT 
    symbol,
    COUNT(*) as transfer_count,
    SUM(usd_value) as total_volume_usd
FROM layerzero.transfers
WHERE timestampUpdated >= NOW() - INTERVAL '24' HOUR
GROUP BY symbol
ORDER BY total_volume_usd DESC
LIMIT 10;