SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/5030855b-86cd-4f61-89cc-984240953ae3/data/latest'):"data" AS data

), all_data as (

SELECT

FLATTENED.VALUE:WEEK AS WEEK,

FLATTENED.VALUE:CREATOR AS CREATOR,

FLATTENED.VALUE:FLOW AS FLOW,

FLATTENED.VALUE:VOLUME AS VOLUME,

FLATTENED.VALUE:USERS AS USERS

FROM

live_data,

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

SELECT

week,

sum(CASE when flow LIKE 'out' then volume * -1 else volume end) as net_deposits,

sum(net_deposits) over (ORDER by week) as total_deposits

FROM all_data

WHERE CREATOR LIKE '%{{ creator_pool }}%'

GROUP BY 1

ORDER by week DESC