Skip to main content

​
Tables

​
Router_swap_function

Token swap transactions executed through MetaMask’s swap router contract on Ethereum. All sample transactions show failed swaps (status=false) with missing input parameters, useful for analyzing swap failure patterns and gas consumption.
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.
gasINT64Gas 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 DEX aggregator protocol used to route the swap. Null values in samples suggest this field may not be populated for all swap transactions or failed swaps.
in_tokenFromSTRINGContract address of the source token being swapped in this MetaMask Router transaction. Null in sample data suggests these may be failed transactions or special swap types where the token address was not captured.
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
1898070false1878160x5f5755290x881d40237659c251811cec9c364ef91dc08d300c138244960x7e0be75f645d85b00523670ad89055c16148c0752021-12-17T19:28:16.000Z0x2fbfa707af0593bc0eb039cc496e1f62f72d91274b4a850cb2fea7e1302892a9
1944830false457080x5f5755290x881d40237659c251811cec9c364ef91dc08d300c138232740x73428a20af42853155c11eb7af8f7ba90f30970e2021-12-17T14:57:43.000Z0x70d21d57a983fe52339f6b6d0e6c565848f222357aba9d3f48872596a034201e
2641310false2122610x5f5755290x881d40237659c251811cec9c364ef91dc08d300c138192740xc99547f73b0aa2c69e56849e8986137776d724742021-12-17T00:01:08.000Z0x1bef16509ce3f1d98cc44df1bf9a946ca42a70a06c1bc8ba0026665b3e086d80
Query with partition filter
SELECT *
FROM `tt-contracts.metamask_v1_ethereum.Router_swap_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100