fidamMost Swapped To Token by Volume
    Updated 2024-10-21
    With Settle 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 ='velodrome'
    )
    Select Symbol_out as Swapped_To_Token,
    Count(DISTINCT tx_hash) as swap_count,
    Sum(Amount_IN_USD) as Total_Swapped_Amount
    From Settle
    Where Amount_IN_USD is not null
    Group by Swapped_To_Token
    ORDER By Total_Swapped_Amount DESC
    LIMIT 10;

    QueryRunArchived: QueryRun has been archived