tab1 as

SELECT

a.value:"date"::date AS dt

, a.value:"swapper"::float AS sg

FROM

(

-- old user

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/df875c4a-6a7b-445d-bd44-acaeb169f4a5/data/latest' ):"data" AS data

--- here link to my qyery ---> https://flipsidecrypto.xyz/StangFAST/q/MANMNtjPZpiy/base-1

) live

JOIN

lateral flatten ( input => live.data ) a

,

tab2 as

SELECT

a.value:"date"::date AS dt

, a.value:"swapper"::float AS sg

FROM

(

-- new user

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/a1efa5a4-e391-432e-bfe8-501e7240d029/data/latest' ):"data" AS data

--- here link to my qyery ---> https://flipsidecrypto.xyz/StangFAST/q/AyQGYOyYrBci/new---1

) live