-- forked from 005 - expirate date [ part 2 ] @ https://flipsidecrypto.xyz/edit/queries/f595a1a1-959d-4647-962f-233c77f1fd35

-- forked from 005 - expirate date [ part 1 ] @ https://flipsidecrypto.xyz/edit/queries/68709381-2722-46aa-b0bd-1289af253dac

-- forked from 004 - type of registered domain @ https://flipsidecrypto.xyz/edit/queries/c2759af8-bbd0-4729-bcbd-ce12661defc0

-- forked from 003 - top level domains @ https://flipsidecrypto.xyz/edit/queries/048acf42-3218-47ca-b236-411198cd3cd8

-- forked from 002 - tokens @ https://flipsidecrypto.xyz/edit/queries/79dd5725-79ab-4813-8a2b-1e7ea34e295c

-- forked from 001 - ALLdomains @ https://flipsidecrypto.xyz/edit/queries/d50c8b3d-33b3-47ca-9806-e5958eac429b

final AS

SELECT

a.value:"BT"::timestamp AS dt

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

, a.value:"US"::text AS sg

, a.value:"TK"::text AS tk

, a.value:"NM"::text AS nm

, a.value:"DM"::text AS dm

, a.value:"CH"::number AS ch

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

FROM

(

--- base 1

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/222502d4-4183-4b9e-845b-7ffba5f83ffd/data/latest' ):"data" AS data

UNION

--- base 2

SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/2934b49b-7e7a-4b2a-be0b-781e4e7accce/data/latest' ):"data" AS data

UNION

--- base 3