SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/23299802-9eb9-41cf-8051-f6ff0c514faf/data/latest'):"data" AS data

),

all_data AS (

SELECT

FLATTENED.VALUE:TX_TO AS TX_TO,

FLATTENED.VALUE:DEPOSIT_EVENTS AS DEPOSIT_EVENTS,

FLATTENED.VALUE:DEPOSIT_FEE_VOLUME AS DEPOSIT_FEE_VOLUME,

FLATTENED.VALUE:DEPOSITORS AS DEPOSITORS,

FLATTENED.VALUE:DEPOSIT_VOLUME AS DEPOSIT_VOLUME

FROM

live_data,

LATERAL FLATTEN(INPUT => live_data.data) AS FLATTENED

SELECT *

FROM all_data

WHERE TX_TO LIKE '%{{ creator_pool }}%';