from optimism.core.fact_event_logs

where origin_to_address in ('0xe592427a0aece92de3edee1f18e0157c05861564',

'0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45')

and event_name = 'Swap'

and tx_status = 'SUCCESS'

, prices as (

select

HOUR::date as days,

symbol,TOKEN_ADDRESS,

avg(price) as price

from optimism.core.fact_hourly_token_prices

group by 1,2,3

) ,

fin as (select

b.SYMBOL,decimals,EVENT_INPUTS:value as raw_amount,price,(price*raw_amount)/pow(10,decimals) as amount_usd,l.*

from

optimism.core.fact_event_logs l,optimism.core.dim_contracts b, prices p

where

tx_hash in (select tx_hash from base) and EVENT_INDEX=2

and CONTRACT_ADDRESS = b.address and BLOCK_TIMESTAMP::date = days and CONTRACT_ADDRESS = p.TOKEN_ADDRESS

select

date_trunc(week,BLOCK_TIMESTAMP)::date as date,

count (distinct tx_hash) as num_swaps,

count (distinct origin_from_address) as num_swappers,

sum(num_swaps)over(order by date ) as cum_num_swaps,

sum(num_swappers)over(order by date ) as cum_num_swappers,

'Uniswap on Op' as dex

from --optimism.core.fact_event_logs t1 join optimism.core.fact_transactions t2 on t1.tx_hash = t2.tx_hash