SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/b8593c31-1e3b-4e0d-906c-ccec1b8a2d43/data/latest'):"data" AS data

),

all_data AS (

SELECT

FLATTENED.VALUE:WEEK AS WEEK,

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 }}%';