bachimetamask wallets staking
    Updated 2022-06-25
    with metamask_users as (
    SELECT
    distinct from_address as wallet
    FROM ethereum.core.fact_transactions
    WHERE to_address = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
    ),
    lido_staking as (
    SELECT
    count(distinct from_address) as wallets, 'Lido staked wallets' as wallet_type
    FROM ethereum.udm_events
    WHERE origin_address = from_address
    AND to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
    AND event_type = 'native_eth' and from_address in (
    select wallet from metamask_users
    )
    GROUP by 2
    ORDER by 2
    ),
    metamask_wallets as (
    SELECT
    count(distinct from_address) as wallets, 'Total Metamask wallets' as wallet_type
    FROM ethereum.core.fact_transactions
    WHERE to_address = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
    group by 2
    )

    select * from metamask_wallets union
    select * from lido_staking
    Run a query to Download Data