select

value:POOL_ADDRESS as pool_address

, value:TOKEN_X as token_x

, value:TOKEN_Y as token_y

, value:TOKEN_X_VAULT as token_x_vault

, value:TOKEN_Y_VAULT as token_y_vault

, value:POOL_FEE as pool_fee

, value:POOL_ as pool_name

from (

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/95e42954-feb9-4397-ae66-836064628759/data/latest') as response

) , lateral flatten (input => response:data)

, pool_token_vaults as (

select

token_x_vault as token_address

from pool_data

union all

select

token_y_vault as token_address

from pool_data

, base_swaps_v2 as (

select