(SELECT *

FROM ethereum.core.dim_labels

WHERE label = 'uniswap')

SELECT user_address as whales,

symbol as token,

MAX(current_bal) as Shiba_Inu_Balance,

MAX(usd_value_now) as USD_Value

FROM ethereum.core.ez_current_balances

WHERE contract_address IN (

LOWER('0x6982508145454ce325ddbe47a25d4ec3d2311933')) --Pepe

AND last_activity_block_timestamp >= current_date - 1

AND user_address IN (SELECT address FROM Uni_Add)

AND symbol IS NOT NULL

GROUP BY 1,2

ORDER BY 3 DESC

LIMIT 20