metamask_users as (

select

distinct from_address as user

from ethereum.core.fact_transactions

where to_address = '0x881d40237659c251811cec9c364ef91dc08d300c'

),

meta_txs as (

select

block_timestamp,

tx_hash,

to_address,

from_address

from ethereum.core.fact_transactions

where from_address in (

select user from metamask_users

)

select

-- to_address as contract,

case to_address

when '0x7a250d5630b4cf539739df2c5dacb4c659f2488d' then 'uniswap v2'

when '0x7be8076f4ea4a4ad08075c2508e481d6c946d12b' then 'opensea'

when '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'usdt'

when '0x881d40237659c251811cec9c364ef91dc08d300c' then 'metamask'

when '0x7f268357a8c2552623316e2562d90e642bb538e5' then 'opensea'

when '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'weth'

when '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'usdc'

when '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45' then 'uniswap v3'

when '0xe592427a0aece92de3edee1f18e0157c05861564' then 'uniswap v3'

when '0xfbddadd80fe7bda00b901fbaf73803f2238ae655' then 'strongblock'

when '0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f' then 'uniswap v2'

when '0x283af0b28c62c092c9727f1ee09c02ca627eb7f5' then 'ens'

when '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0' then 'matic'

when '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39' then 'hex'