WITH

INS AS (

select

a.EVENT_INPUTS:value/pow(10,DECIMALS) as "volume IN" ,

SYMBOL ,

(a.EVENT_INPUTS:value/pow(10,DECIMALS)) * PRICE as "IN USD" ,

TX_HASH ,

EVENT_INPUTS:to AS POOL ,

HOUR::DATE AS DATE

from optimism.core.fact_event_logs a

join optimism.core.fact_hourly_token_prices c on c.token_address = a.contract_address and date_trunc('hour', a.block_timestamp) = c.hour

where a.origin_to_address in ('0xba12222222228d8ba445958a75a0704d566bf2c8')

and a.tx_status ='SUCCESS' and a.block_timestamp >= '2022-01-01'

-- and TX_HASH='0x04cb8f7cbb683d7f49cd8325bb48dc821cedda1de6fd966e5df8d57ebaa923c4'

and a.event_inputs:to = a.origin_from_address

and event_name ='Transfer' )

,--------------------------------------------------------------------------------------------------------------------------------------------------------------------

OUTS AS (

select

a.EVENT_INPUTS:value/pow(10,DECIMALS) as "volume OUT" ,

SYMBOL ,

(a.EVENT_INPUTS:value/pow(10,DECIMALS)) * PRICE as "OUT USD" ,

TX_HASH ,

HOUR::DATE AS DATE

from optimism.core.fact_event_logs a

join optimism.core.fact_hourly_token_prices c on c.token_address = a.contract_address and date_trunc('hour', a.block_timestamp) = c.hour

where a.origin_TO_address in ('0xba12222222228d8ba445958a75a0704d566bf2c8')

and a.tx_status ='SUCCESS' and a.block_timestamp >= '2022-01-01'

-- and TX_HASH='0x04cb8f7cbb683d7f49cd8325bb48dc821cedda1de6fd966e5df8d57ebaa923c4'

and a.event_inputs:from = a.origin_FROM_address

and event_name ='Transfer' )

,X AS (