Ali3NTop 10 Zipswap Swap From Asset (By Number of Swappers)
    Updated 2022-08-01
    select contract_address,
    address_name,
    count (distinct tx_hash) as Swaps_Count,
    count (distinct origin_from_address) as Swappers_Count
    from optimism.core.fact_event_logs full outer join optimism.core.dim_labels on contract_address = address
    where origin_to_address =lower('0xE6Df0BB08e5A97b40B21950a0A51b94c4DbA0Ff6')
    and origin_from_address = event_inputs:from and event_name ='Transfer'
    --and tx_hash = '0x30767ff76bd27d6c64fd1e81b9e34df0ee46634f86ed07aed0ed2540036ccade'
    group by 1,2
    order by 4 DESC
    limit 10
    Run a query to Download Data