Yousefi_1994Staking by Metamask users
Updated 2022-06-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with metamask_user as (
select
distinct origin_from_address as user_address
from ethereum.core.ez_dex_swaps
where origin_to_address= '0x881d40237659c251811cec9c364ef91dc08d300c'
and origin_function_signature = '0x5f575529'
group by user_address
)
select
count(distinct origin_from_address) as number_of_user
from ethereum.core.fact_event_logs
where origin_from_address in (select user_address from metamask_user)
and event_name = 'Transfer'
and event_inputs:from::string = '0x0000000000000000000000000000000000000000'
and contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
Run a query to Download Data