SELECT

block_timestamp,

date_trunc('HOUR', block_timestamp) as swap_hour,

origin_from_address as swapper,

event_inputs:amountIn as from_amount,

event_inputs:amountOut as to_amount,

event_inputs:poolId as pool_id,

event_inputs:tokenIn as from_token,

event_inputs:tokenOut as to_token

FROM optimism.core.fact_event_logs

WHERE contract_address = '0xba12222222228d8ba445958a75a0704d566bf2c8'

AND event_name = 'Swap'

), swaps2 AS (

SELECT

a.*,

b.decimals as from_decimals,

b.symbol as from_symbol,

c.decimals as to_decimals,

c.symbol as to_symbol,

a.from_amount/pow(10,from_decimals) as from_amount_adjusted,

a.to_amount/pow(10,to_decimals) as to_amount_adjusted

FROM swaps as a JOIN optimism.core.dim_contracts as b

ON a.from_token = b.address

JOIN optimism.core.dim_contracts as c

ON a.to_token = c.address

), swaps_usd as (

SELECT a.*,

a.from_amount_adjusted * b.price as from_amount_usd,

a.to_amount_adjusted*c.price as to_amount_usd

FROM swaps2 as a JOIN optimism.core.fact_hourly_token_prices as b ON a.swap_hour = b.HOUR AND a.from_token = b.token_address

JOIN optimism.core.fact_hourly_token_prices as c ON a.swap_hour = c.hour AND a.to_token = c.token_address

SELECT block_timestamp::date as date,

count(*) as "Number of Swaps",