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 AS contract

, swapper

, amount_in_usd AS amount

FROM aptos.defi.ez_dex_swaps

UNION ALL

SELECT

block_timestamp

, symbol_out AS symbol

, token_out AS contract

, swapper

, amount_out_usd AS amount

FROM aptos.defi.ez_dex_swaps)

WHERE block_timestamp >= Current_date - INTERVAL '7 Days'

AND symbol != 'APT'

AND symbol != 'USDC'

AND symbol != 'USDT'

AND symbol != 'amAPT'

AND symbol != 'aBTC'

AND symbol != 'stAPT'

AND symbol != 'DAI'

AND symbol != 'MOD'

AND symbol != 'aBTC'

AND symbol != 'WETH'

AND symbol != 'sthAPT'

AND symbol != 'tAPT'

AND symbol != 'WBTC'