CONCAT(symbol_out, '-', symbol_in) as pool_name,

MIN(block_timestamp) as first_swap,

DATEDIFF(day, MIN(block_timestamp), CURRENT_DATE()) as age_in_days

FROM crosschain.defi.ez_dex_swaps

WHERE blockchain IN ('arbitrum', 'base', 'optimism')

AND pool_name IS NOT NULL

GROUP BY pool_name

),

swaps AS (

WITH swap_raw AS (

SELECT

block_timestamp,

blockchain as chain,

tx_hash,

CONCAT(symbol_out, '-', symbol_in) as pool_name,

contract_address as pool_contract_address,

trader,

token_in,

symbol_in,

amount_in_raw,

amount_in,

amount_in_usd,

token_out,

symbol_out,

amount_out_raw,

amount_out,

amount_out_usd,

'WETH' AS price_table_symbol

FROM crosschain.defi.ez_dex_swaps

WHERE block_timestamp::date >= '2023-01-01'

AND blockchain IN ('arbitrum', 'base', 'optimism')

)

SELECT