eferMetamask super-users
    Updated 2022-06-25
    WITH metamask_ethereum_users AS (
    SELECT
    FROM_ADDRESS AS user
    FROM ethereum.core.fact_transactions
    WHERE TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c'
    ), users AS (
    SELECT DISTINCT user FROM metamask_ethereum_users
    ), Lido_depositors AS(
    SELECT
    FROM_ADDRESS
    FROM ethereum.core.fact_traces
    WHERE TO_ADDRESS='0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    AND INPUT LIKE '0xa1903eab%'
    ), superusers AS (
    SELECT COUNT(users.user) AS superusers
    FROM users, Lido_depositors
    WHERE users.user=Lido_depositors.FROM_ADDRESS
    ), total_users AS (
    SELECT COUNT(user) AS users FROM users
    )

    SELECT superusers.superusers, superusers.superusers/total_users.users * 100
    FROM total_users, superusers
    Run a query to Download Data