metamask_v1_ethereum

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.

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`	`INT64`	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 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_tokenFrom`	`STRING`	Contract 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_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

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
189807	false	187816	0x5f575529	0x881d40237659c251811cec9c364ef91dc08d300c	13824496	0x7e0be75f645d85b00523670ad89055c16148c075	2021-12-17T19:28:16.000Z	0x2fbfa707af0593bc0eb039cc496e1f62f72d91274b4a850cb2fea7e1302892a9
194483	false	45708	0x5f575529	0x881d40237659c251811cec9c364ef91dc08d300c	13823274	0x73428a20af42853155c11eb7af8f7ba90f30970e	2021-12-17T14:57:43.000Z	0x70d21d57a983fe52339f6b6d0e6c565848f222357aba9d3f48872596a034201e
264131	false	212261	0x5f575529	0x881d40237659c251811cec9c364ef91dc08d300c	13819274	0xc99547f73b0aa2c69e56849e8986137776d72474	2021-12-17T00:01:08.000Z	0x1bef16509ce3f1d98cc44df1bf9a946ca42a70a06c1bc8ba0026665b3e086d80

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Router_swap_function

​Tables

​Router_swap_function

Tables

Router_swap_function