MoeMost Common Transactions
Updated 2022-06-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with wlt as (SELECT
distinct ORIGIN_FROM_ADDRESS
FROM
ethereum.core.fact_event_logs
WHERE
ORIGIN_TO_ADDRESS in ('0x881d40237659c251811cec9c364ef91dc08d300c')
AND
EVENT_NAME ilike 'Swap')
select
label_type as tx_type,
count (tx_hash) as number_of_txs
from ethereum.core.fact_event_logs s
join ethereum.core.dim_labels lb on s.ORIGIN_TO_ADDRESS = lb.address
where
ORIGIN_FROM_ADDRESS in (select * from wlt)
group by 1 order by 2 desc limit 5
Run a query to Download Data