Skip to main content

​
Tables

​
Router_swap_function

Failed swap attempts through MetaMask’s swap router contract on Polygon. Contains transaction-level data for unsuccessful swap operations, useful for analyzing swap failure patterns and gas consumption in failed MetaMask transactions.
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 for the decentralized exchange (DEX) aggregator executing the swap route. Null values in samples suggest this field may not be populated for all swap transactions or aggregator types.
in_tokenFromSTRINGContract address of the source token being swapped in the MetaMask Router transaction. Hex-encoded, 0x-prefixed 40-character string for EVM tokens; null when transaction failed or parameters unavailable.
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
16023000false308950x5f5755290x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31661660590x608db44fa0a698af6ca4447111fd4534ed7187632025-01-01T04:27:53.000Z0x3105fb52fb49e401bb826c2480fc51c9c784407aa9b2e9a513f60dd92f4f9b04
16044280false151480x5f5755290x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31661840480x88630c35578dc8f986b7c3c2b9d6ead8ff0c925b2025-01-01T15:25:22.000Z0x7dc472f943325c62aa91b85637572464b521bd4c87275c766aea694dcefa62b9
16208720false151480x5f5755290x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31661833920x5dbbf886b858e77d43b5f380057f35bb4fc580ad2025-01-01T15:01:36.000Z0xa22d86cbdff4f2ed8fcf1ab0f8c820d14bb49d254751f03029efe963dcc95c63
Query with partition filter
SELECT *
FROM `tt-contracts.metamask_v1_polygon.Router_swap_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100