price AS

SELECT

date_trunc( 'day' , a.recorded_hour ) AS date

, avg( a.close ) AS price

, a.symbol AS symbol

, a.token_address AS address

FROM

solana.price.ez_token_prices_hourly a

GROUP BY 1 , 3 , 4

ORDER BY 1 DESC

,

min AS

SELECT

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

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

FROM

(

-- --- part 1

-- SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/b12b61aa-d5c1-42f9-afdd-a8beb370f16f/data/latest' ):"data" AS data

-- UNION

-- --- part 2

-- SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/f783f94e-449a-42bb-b131-522ffb33399d/data/latest' ):"data" AS data

-- UNION

-- --- part 3

-- SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/e2d43cea-132a-4a4e-96e2-1b804acec38c/data/latest' ):"data" AS data

-- UNION

-- --- part 4

-- SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/2a4cb61e-5e71-43b6-bed1-f75d2600848d/data/latest' ):"data" AS data