fidamsilly-salmon
    Updated 2024-10-20
    With Synthetix as (
    Select Block_timestamp, Tx_hash,
    Origin_From_Address, Amount_In_USD,symbol_In,Symbol_Out,POOL_NAME,
    From optimism.defi.ez_dex_swaps
    Where platform ='synthetix'
    )
    Select Origin_From_Address as Swappers,
    Count(DISTINCT Tx_Hash) as Swap_Count
    From Synthetix
    Group by Origin_From_Address
    Order By Swap_Count DESC
    LIMIT 20;
    QueryRunArchived: QueryRun has been archived