danhanUntitled Query
    Updated 2022-08-05
    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