Skip to main content

​
Tables

​
Router_swap_function

Swap transaction attempts through MetaMask’s router contract on BNB Smart Chain (BSC), capturing failed swaps with function signature 0x5f575529. Useful for analyzing swap failure patterns and gas consumption across different aggregators.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasNUMERICGas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_aggregatorIdSTRINGIdentifier of the decentralized exchange (DEX) aggregator used to route the swap transaction. Null when swap fails or aggregator information is unavailable.
in_tokenFromSTRINGSource token contract address being swapped from in this MetaMask router transaction. Null values indicate failed transactions where the swap parameters were not properly decoded.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_dataSTRINGEncoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
gasvaluestatusin_datagas_usedin_amountsignatureto_addressblock_numberfrom_addressin_tokenFromtrace_addressblock_timestampin_aggregatorIdtransaction_hash
3909500false2726360x5f5755290x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31196770190xc455ff56c288f6dd85ecca5a5cddb1f3458433762022-07-19T03:59:56.000Z0x33599017af881afa7b15a9895c8a3ff2637982f919a078c3954b866cbad52bce
2673221260000000000000000false1782490x5f5755290x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31196947200x61bc76e383339aa4298a082790be45a91d46c59d2022-07-19T18:46:59.000Z0x0b62f0fbb11720549a229be3b4faf25bda1dc5a32a8ff81bf01c36737f876acc
3102160false1033380x5f5755290x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31196825580x22f863c24e9e5b8c391edca6c7f6b7e867b722a92022-07-19T08:38:22.000Z0x0081c5dfd1566ea64e45959b4b67d491978d525c6d681c6efdfee3b06ad20e84
Query with partition filter
SELECT *
FROM `tt-contracts.metamask_v1_bsc.Router_swap_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100