DeFi_reindsNumber of Metamask users who staked
Updated 2022-06-25
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with mm_users as (select distinct origin_from_address from ethereum.core.fact_event_logs
where contract_address = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')), -- Metamask swap
stake_users as (select
eth_from_address
from ethereum.core.ez_eth_transfers
where eth_to_address in ('0xae7ab96520de3a18e5e111b5eaab095312d7fe84', '0xae78736cd615f374d3085123a210448e74fc6393') -- Lido and Rocketpool
and eth_from_address in (select origin_from_address from mm_users))
select count(distinct eth_from_address) as number_of_users_staked from stake_users
Run a query to Download Data