SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/100ebabb-37ab-4c41-b5b6-7dcb192e54e7/data/latest'):"data" AS data

),

all_data AS (

SELECT

FLATTENED.VALUE:WEEK AS WEEK,

FLATTENED.VALUE:TX_TO AS TX_TO,

FLATTENED.VALUE:NEW AS NEW,

FLATTENED.VALUE:TOTAL AS TOTAL

FROM

live_data,

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

SELECT *

FROM all_data

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

ORDER by week DESC