symbol AS "Token"

, contract

, SUM(amount) AS vol

, '💲'||TO_CHAR(vol, '999,999,999,999,999.99') AS "Volume"

FROM (SELECT

block_timestamp

, symbol_in AS symbol

, token_in_contract AS contract

, trader

, amount_in_usd AS amount

FROM near.defi.ez_dex_swaps

UNION ALL

SELECT

block_timestamp

, symbol_out AS symbol

, token_out_contract AS contract

, trader

, amount_out_usd AS amount

FROM near.defi.ez_dex_swaps)

WHERE block_timestamp >= Current_date - INTERVAL '7 Days'

AND symbol != 'wNEAR'

AND symbol != 'USDC'

AND symbol != 'USDt'

AND symbol != 'USDT.e'

AND symbol != 'STNEAR'

AND symbol != 'USDC.e'

AND symbol != 'DAI'

AND symbol != 'WBTC'

GROUP BY 1, 2

HAVING SUM(amount) IS NOT NULL

ORDER BY 3 DESC

LIMIT 20