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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
trace_address | STRING | Hierarchical 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. |
status | BOOL | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
from_address | STRING | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
to_address | STRING | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
value | FLOAT64 | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
gas_used | INT64 | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
gas | NUMERIC | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
signature | STRING | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
in_aggregatorId | STRING | Identifier of the decentralized exchange (DEX) aggregator used to route the swap transaction. Null when swap fails or aggregator information is unavailable. |
in_tokenFrom | STRING | Source 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_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
in_data | STRING | Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data. |
Sample Data
Sample Data
| gas | value | status | in_data | gas_used | in_amount | signature | to_address | block_number | from_address | in_tokenFrom | trace_address | block_timestamp | in_aggregatorId | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 390950 | 0 | false | 272636 | 0x5f575529 | 0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31 | 19677019 | 0xc455ff56c288f6dd85ecca5a5cddb1f345843376 | 2022-07-19T03:59:56.000Z | 0x33599017af881afa7b15a9895c8a3ff2637982f919a078c3954b866cbad52bce | |||||
| 267322 | 1260000000000000000 | false | 178249 | 0x5f575529 | 0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31 | 19694720 | 0x61bc76e383339aa4298a082790be45a91d46c59d | 2022-07-19T18:46:59.000Z | 0x0b62f0fbb11720549a229be3b4faf25bda1dc5a32a8ff81bf01c36737f876acc | |||||
| 310216 | 0 | false | 103338 | 0x5f575529 | 0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31 | 19682558 | 0x22f863c24e9e5b8c391edca6c7f6b7e867b722a9 | 2022-07-19T08:38:22.000Z | 0x0081c5dfd1566ea64e45959b4b67d491978d525c6d681c6efdfee3b06ad20e84 |
Example Query
Example Query
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