danhanUntitled Query
Updated 2022-08-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with truefreezeusers as (
select distinct ORIGIN_FROM_ADDRESS
from ethereum.core.fact_event_logs
where CONTRACT_ADDRESS in('0x573c0609a8cac30b7a8a65e3652f0511caeffd30', --users who intract with frETH contract
'0xa45645ebb075a96d1c89511e28d3e9b94f3b7905') --users who staked their FRZ
)
select ORIGIN_FROM_ADDRESS,
count(distinct TX_HASH )
from ethereum.core.ez_dex_swaps
where ORIGIN_FROM_ADDRESS in (select ORIGIN_FROM_ADDRESS from truefreezeusers )
group by 1
order by 2 desc
limit 20
Run a query to Download Data