final AS

SELECT

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

, a.value:"TX"::string AS tx

, a.value:"SG"::string AS sg

, a.value:"AC"::string AS ac

, a.value:"AM"::string AS am

, a.value:"US"::string AS us

, a.value:"SB"::string AS sb

, a.value:"SC"::string AS sc

FROM

(

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/a53ef0ff-7d03-44fc-aa58-6e38a001d831/data/latest' ):"data" AS data

UNION

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/74eaefdf-dcd5-4640-8d57-3957c10e7fca/data/latest' ):"data" AS data

UNION

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/266acbe5-8425-41c1-ad18-471f669fdaec/data/latest' ):"data" AS data

UNION

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/6542c5c5-5038-4687-8684-0b39fc5d3cda/data/latest' ):"data" AS data

UNION

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/24fa43e8-ed1a-45cc-8567-171c26e3c055/data/latest' ):"data" AS data

) live

JOIN

lateral flatten ( input => live.data ) a

,

min AS

SELECT

min( a.dt ) AS mn_dt

, a.sg AS nw_sg