with raw_data AS (

SELECT helius_das.get_assets_by_owner( 'mainnet', -- the network, 'mainnet' or 'devnet'

{ 'ownerAddress': 'AVzP2GeRmqGphJsMxWoqjpUifPpCret7LqWhD8NWQK49',

'page': 1, -- Starts at 1

'limit': 1000 ,

'displayOptions': {

'showFungible': true --//return both fungible and non-fungible tokens

}

} ) as response

, cte AS (

SELECT

value:id AS token

, value:token_info:symbol AS symbol

, value:token_info:balance AS token_balance

, round(value:token_info:price_info:total_price,2) AS token_usd_value

, round(ratio_to_report(token_usd_value) OVER (), 3) AS token_perc

, CASE

WHEN symbol = 'SOL' then 0.47

WHEN symbol = 'ETH' then 0.1

WHEN symbol = 'WBTC' then 0.11

WHEN symbol = 'USDC' then 0.28

WHEN symbol = 'USDT' then 0.04

END AS target_perc

FROM raw_data

, lateral flatten (input => response:data:result:items)

WHERE value:interface = 'FungibleToken'

AND symbol is NOT NULL

AND symbol IN ('SOL', 'USDC', 'USDT', 'ETH', 'WBTC')

cte.symbol