eferMetamask super-users
Updated 2022-06-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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