select

'Optimism' as "BlockChain",

'Uniswap' as "Platform",

count (distinct tx_hash) as "Number of Swaps",

count (distinct Origin_from_address) as "Number of Swappers",

"Number of Swaps" / count(distinct(block_timestamp::date)) as "Average Daily/Number of Swaps",

"Number of Swappers" / count(distinct(block_timestamp::date)) as "Average Daily/Number of Swappers"

from optimism.core.fact_event_logs

where origin_to_address in ('0xe592427a0aece92de3edee1f18e0157c05861564','0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45')

and event_name = 'Swap'

and tx_status = 'SUCCESS'

),

optimism_sushiswap as (

select

'Optimism' as "BlockChain",

'Sushiswap' as "Platform",

count (distinct tx_hash) as "Number of Swaps",

count (distinct Origin_from_address) as "Number of Swappers",

"Number of Swaps" / count(distinct(block_timestamp::date)) as "Average Daily/Number of Swaps",

"Number of Swappers" / count(distinct(block_timestamp::date)) as "Average Daily/Number of Swappers"

from optimism.sushi.ez_swaps

where platform = 'sushiswap'

select * from optimism_uniswap

union all

select * from optimism_sushiswap