OneDataAnalystMetamask Users - Most used NFT platforms
    Updated 2022-06-25
    WITH t0 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') )),


    t00 AS ( -- Excluding Adresses that have labels in label table
    SELECT DISTINCT ALL_Interacts AS Metamask_users
    FROM t0
    LEFT JOIN ethereum.core.dim_labels ON ethereum.core.dim_labels.ADDRESS = t0.ALL_Interacts
    WHERE ethereum.core.dim_labels.ADDRESS IS NULL ),

    t1 AS(
    SELECT ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, EVENT_NAME
    FROM ethereum.core.fact_event_logs
    JOIN t00 ON t00.Metamask_users = ethereum.core.fact_event_logs.ORIGIN_FROM_ADDRESS
    WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 180
    ),

    t01 AS(
    SELECT FROM_ADDRESS AS ORIGIN_FROM_ADDRESS, TO_ADDRESS AS ORIGIN_TO_ADDRESS
    FROM ethereum.core.fact_transactions
    JOIN t00 ON t00.Metamask_users = ethereum.core.fact_transactions.FROM_ADDRESS
    WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 180
    ),
    Run a query to Download Data