Query editor
WITHexcluded_addr AS (SELECT CAST('S7vYFFWH6BjJyEsdrPQpqpYTqLTrPRK6KW3VwsJuRaS' AS VARCHAR) AS addr),exchange_wallets AS (SELECT wallet, exchange FROM (VALUES('FWznbcNXWQuHTawe9RxvQ2LdCENssh12dsznf4RiouN5', 'Kraken'),('9A9dUreQvTNoqNrqQC2DN1onfZWBtCBsTiuA6oGXZwc6', 'Kraken'),('41Mjig92SfveWPKkqis78hF3a75cpe96n1uuVuMAdkJF', 'Kraken'),('6LY1JzAFVZsP2a2xKrtU6znQMQ5h4i7tocWdgrkZzkzF', 'Kraken'),('AC5RDfQFmDS1deWZos921JfqscXdByf8BKHs5ACWjtW2', 'Bybit'),('u6PJ8DtQuPFnfmwHbGFULQ4u4EgjDiyYKjVEsynXq2w', 'Gateio'),('C68a6RCGLiPskbPYtAcsCjhG8tfTWYcoB4JjCrXFdqyo', 'OKX'),('8wM44Ryv9DFCSfkgUnPEPgnsc53arT4cnmXL6LnnC4UW', 'OKX')) AS t(wallet, exchange)),backed_tokens AS (SELECT DISTINCTLOWER(solana_address) AS address,symbolFROM dune.xstocks.result_latest_x_stocks_assets),latest_price AS (SELECTbt.address,bt.symbol,p.priceFROM backed_tokens btLEFT JOIN dune.xstocks.result_latest_x_stocks_prices pON p.symbol = bt.symbol),-- =========================-- X LAYER: okx balances from query_8042834-- =========================xlayer_okx AS (SELECTsymbol,SUM(okx_balance) AS okx_balanceFROM query_8042834GROUP BY symbol),-- =========================-- HOLDINGS: daily_balances MAX(day)-- =========================daily_latest AS (SELECTLOWER(db.token_mint_address) AS address,CAST(db.token_balance_owner AS VARCHAR) AS owner,CAST(db.day AS DATE) AS day,CAST(db.token_balance AS DOUBLE) AS balance,ROW_NUMBER() OVER (PARTITION BY LOWER(db.token_mint_address), CAST(db.token_balance_owner AS VARCHAR)ORDER BY CAST(db.day AS DATE) DESC) AS rnFROM solana_utils.daily_balances dbWHERE db.token_balance <> 0AND LOWER(db.token_mint_address) IN (SELECT address FROM backed_tokens)),all_balances AS (