alirsOPB-OPT06-Day
    Updated 2022-10-14
    select
    block_timestamp::date as date,
    count(DISTINCT tx_hash) as swap_Count,
    count(distinct origin_from_address) as Swapper_count
    from optimism.core.fact_event_logs
    where origin_to_address = lower('0xE6Df0BB08e5A97b40B21950a0A51b94c4DbA0Ff6') --ZipSwap
    and event_name = 'Swap'
    and tx_status = 'SUCCESS'
    group by 1
    order by 2 DESC
    limit 10

    Run a query to Download Data