with cte as (

select

pool_address as LP_ADD,

replace(split(pool_name,'-')[0],'\u0000') as LP_TYPE, --FIX BLANKS

replace(split(pool_name,'-')[1],'\u0000') as LP_NAME,

TOKEN_ADDRESS_IN,

AMOUNT_IN,

replace(symbol_in,'\u0000') as TOKEN_SYMBOL_IN,

TOKEN_ADDRESS_OUT,

AMOUNT_OUT,

replace(symbol_OUT,'\u0000') AS TOKEN_SYMBOL_OUT,

lP_FEE_TOKEN_ADDRESS,

LP_FEE,

replace(lp_fee_symbol,'\u0000') as TOKEN_SYMBOL_FEE,

tx_hash,

block_timestamp,

_LOG_ID,

origin_from_address

from optimism.velodrome.ez_swaps

where block_timestamp >= current_date()-2 -- SELECT X DAY

),

cte2 as (

select

LP_ADD,

LP_NAME,

TOKEN_SYMBOL_IN,

SUM(AMOUNT_IN) as total_in,

TOKEN_SYMBOL_OUT,

TOKEN_ADDRESS_IN,

sum (AMOUNT_OUT) as total_out,

total_out/total_in IN_1TOKEN_TO_OUT

from cte

group by 1,2,3,5,6),

CTE3 as (SELECT