OneDataAnalystMetaMask users
    Updated 2022-06-23
    WITH t1 AS ( -- ALL Wallets interacts with MetaMask Swap feature on Ethereum
    SELECT DISTINCT C1 AS ALL_Interacts
    FROM(
    SELECT DISTINCT ORIGIN_FROM_ADDRESS AS C1
    FROM ethereum.core.fact_event_logs
    WHERE ORIGIN_TO_ADDRESS = LOWER('0x881D40237659C251811CEC9c364ef91dC08D300C')
    OR CONTRACT_ADDRESS = LOWER('0x881D40237659C251811CEC9c364ef91dC08D300C')

    UNION

    SELECT DISTINCT FROM_ADDRESS
    FROM ethereum.core.fact_transactions
    WHERE TO_ADDRESS = LOWER('0x881D40237659C251811CEC9c364ef91dC08D300C') )),


    t2 AS (
    SELECT DISTINCT ALL_Interacts AS Metamask_users
    FROM t1
    LEFT JOIN ethereum.core.dim_labels ON ethereum.core.dim_labels.ADDRESS = t1.ALL_Interacts
    WHERE ethereum.core.dim_labels.ADDRESS IS NULL )



    Run a query to Download Data