token AS

SELECT

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

, avg( a.price ) AS price

, a.symbol AS symbol

, a.decimals AS decimals

, a.token_address AS token_address

FROM

avalanche.price.ez_prices_hourly a

GROUP BY 1 , 3 , 4 , 5

ORDER BY 1 DESC

,

raw AS

SELECT

a.value:"DATE"::date AS date

, a.value:"TRANSACTION"::string AS transactions

, a.value:"BUYER"::string AS buyers

, a.value:"SELLER"::string AS sellers

, a.value:"NFT_PJ"::string AS nft_pj

, a.value:"NFT_ID"::string AS nft_id

, a.value:"TOKEN_ADDRESS"::string AS token_address

, a.value:"TOKEN_AMOUNT"::integer AS token_amount

, a.value:"ACTION_TYPE"::string AS action_type

, a.value:"MARKETPLACE"::string AS marketplace

FROM

(

SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/v1/queries/a7936cbf-d2b9-43a6-82ad-a7b2db2b47f0/data/latest' ):"data" AS data

) live

JOIN

lateral flatten ( input => live.data ) a