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/4b4c9413-23ba-423c-91e9-7e07143f0047/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 as (