maybeyonasmetamask_interact_contract_daily
    Updated 2022-06-24
    with
    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
    )
    ),
    interactions as (
    select
    date(block_timestamp) as date,
    to_address as contract,
    case contract
    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'
    Run a query to Download Data