Query editor
WITH wallet_balances AS (SELECTb.address,b.token_symbol,MAX(b.balance) AS latest_balanceFROM stablecoins_solana.balances AS bWHERE b.balance > 0AND b.day >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY b.address, b.token_symbol),sol_balances AS (SELECTaddress,MAX(sol_balance) AS sol_balanceFROM solana_utils.latest_balancesWHERE sol_balance > 0GROUP BY address),qualified_wallets AS (SELECT DISTINCTwb_usdt.addressFROM wallet_balances wb_usdtINNER JOIN wallet_balances wb_usdcON wb_usdt.address = wb_usdc.addressINNER JOIN sol_balances sbON wb_usdt.address = sb.addressWHERE wb_usdt.token_symbol = 'USDT'AND wb_usdt.latest_balance >= 500000AND wb_usdc.token_symbol = 'USDC'AND wb_usdc.latest_balance >= 500000AND sb.sol_balance >= 1000)SELECTqw.addressFROM qualified_wallets qwORDER BY qw.address