eslamis-darkatactivity anali 14
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with metamask as (
select distinct origin_from_address as unique_address
from ethereum.core.fact_event_logs
where lower(contract_address) = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')
)
,
swap as (select count(origin_from_address) as number
from ethereum.core.fact_event_logs
join metamask on origin_from_address = unique_address
join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature
WHERE lower(text_signature) like ('%swap%')
)
,
deposit as(select count(origin_from_address) as number
from ethereum.core.fact_event_logs
join metamask on origin_from_address = unique_address
join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature
WHERE lower(text_signature) like ('%deposit%')
)
,
transfer as (
select count(origin_from_address) as number
from ethereum.core.fact_event_logs
join metamask on origin_from_address = unique_address
join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature
WHERE lower(text_signature) like ('%transfer%')
)
,
staking as (
select count(origin_from_address) as number
from ethereum.core.fact_event_logs
join metamask on origin_from_address = unique_address
join ethereum.core.dim_function_signatures on origin_function_signature = bytes_signature
WHERE lower(text_signature) like ('%stake%')
)
,
Run a query to Download Data