platform,

block_timestamp::date as dayz,

tx_hash,

origin_from_address,

symbol_in,

amount_in,

amount_in_usd,

symbol_out,

amount_out,

amount_out_usd,

pool_name

from optimism.sushi.ez_swaps

where block_timestamp::date >= CURRENT_DATE - {{period}}

UNION ALL

select

platform,

block_timestamp::date as dayz,

tx_hash,

origin_from_address,

symbol_in,

amount_in,

amount_in_usd,

symbol_out,

amount_out,

amount_out_usd,

pool_name

from optimism.velodrome.ez_swaps

where block_timestamp::date >= CURRENT_DATE - {{period}}

),

uniswap_from as (

SELECT

block_timestamp,