with raw as (

SELECT livequery.live.udf_api(

'GET',

'https://api.flipsidecrypto.com/api/v2/queries/af805945-bf42-4c2a-8877-e6d3f4a84767/data/latest',

{'accept': 'application/json'},

{}

) as response

,b as

( SELECT

VALUE:project as "Project" ,

VALUE:area as "Area" ,

VALUE:active_days as "Active days" ,

VALUE:contract_calls as "Contract Calls" ,

VALUE:transaction as "Transaction" ,

VALUE:users as "Users" ,

VALUE:volume as "Volume" ,

VALUE:avg_tx as "Avg Tnxs"

FROM

raw,

LATERAL FLATTEN (

input => response:data

)

select

"Project" ,