with pools as (

select pool_name, pool_address, token0, token1

from ETHEREUM_CORE.DIM_DEX_LIQUIDITY_POOLS

where pool_address = LOWER('0x397FF1542f962076d0BFE58eA045FfA2d347ACa0')

),

decimals as (

select address, symbol, decimals

from ethereum.core.dim_contracts

where address = (select lower(token0) from pools) OR address = (select lower(token1) from pools)

),

pool_token_details as (

select

pool_name,

pool_address,

token0,

token1,

token0.symbol as token0symbol,

token1.symbol as token1symbol,

token0.decimals as token0decimals,

token1.decimals as token1decimals

from pools

left join decimals as token0 on token0.address = token0

left join decimals as token1 on token1.address = token1

),

swaps as (

SELECT

block_number,