with btc_supply as (

select

value:BTC_SUPPLY::numeric as supply,

from (

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/ad27499e-5e8d-4c63-a8b7-8990a262c3a5/data/latest') as response

), lateral FLATTEN (input => response:data)

order by 1 desc

)

, etf_addresses as (

select

value:ISSUER::string as issuer,

value:ADDRESS::string as address,

value:TRACK_INFLOW::boolean as track_inflow,

value:TRACK_OUTFLOW::boolean as track_outflow,

value:INVERSE_VALUES::boolean as inverse_values

from (

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/f3dc1a33-fcde-454f-89bc-681b9f21633c/data/latest') as response

), lateral FLATTEN (input => response:data)

order by 1 desc

)

, etf_meta as (

select

value:ISSUER::text as issuer,

value:TICKER::text as ticker,

value:FEE::text as fee,

value:CUSTODIAN::text as custodian,

value:WEBSITE::text as website

from (

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/7514b671-b3d0-4c19-aca3-020c8458419f/data/latest') as response