Query editor
WITH all_traders AS (select block_time,token_bought_symbol,token_bought_amount,token_bought_mint_address,amount_usdfrom dex_solana.tradeswheretoken_bought_symbol not in ('SOL', 'USDC', '') andtx_id in (select tx_id from tokens_solana.transfers where to_owner = '5wkyL2FLEcyUUgc3UeGntHTAfWfzDrVuxMnaMm7792Gk' and block_time >= NOW() - INTERVAL '1' day)),sum_tokens as (select get_href(get_chain_explorer('solana') || '/account/' || token_bought_mint_address, upper(substring(COALESCE(token_bought_symbol, token_bought_mint_address),1,10))) as token,sum(token_bought_amount) as token_amount,sum(amount_usd) as token_amount_usdfrom all_tradersgroup by 1)select * from sum_tokens order by 3 desc