select

pair as pool_name,

pool_contract as pool_address,

symbol0 as symbol0,

symbol1 as symbol1,

token_contract0 as token0_address,

token_contract1 as token1_address,

decimal0 as decimal0,

decimal1 as decimal1

from $query('6b11ca05-f0b9-4c2f-8534-0205284bc906')

),

dim_pool_label as (

select distinct token0_address as token_address, symbol0 as symbol, decimal0 as decimal from uniswap_pools_tab

union all

select distinct token1_address as token_address, symbol1 as symbol, decimal1 as decimal from uniswap_pools_tab

),

swap_events as (

select

block_number,

origin_function_signature,

origin_from_address as user_address,

block_timestamp,

tx_hash,

contract_address,

'Swap' as event_name

from monad.testnet.fact_event_logs

where topics [0] = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'

and tx_succeeded = true

and contract_address in (select distinct pool_address from uniswap_pools_tab)

),

uniswap_swap_tab as (

select