SELECT

value AS temp_value

FROM (

SELECT

livequery.live.udf_api(

'https://raw.githubusercontent.com/mehdimarjan/Opensea/refs/heads/main/positions.json'

) AS response

),

LATERAL FLATTEN(input => response:data)

),

positions AS(

value:user_address::string AS user,

value:id::string AS position_id,

value:wallet_position_asset::string AS position_asset,

value:wallet_position_amount::string AS position_amount,

value:chain_position::string AS chain_position,

'Position' AS label

positions_api, LATERAL FLATTEN(input => temp_value)

),

portfolios AS (

SELECT

user_address,

key::string AS chain_name,

value::string AS amount,

'Portfolio' AS label

FROM (

SELECT

value:user_address::STRING AS user_address,

value:chain_distribution AS chain_distribution,

FROM (

SELECT