select

Block_timestamp as "Date",

'Buy' as "Buy/Sell",

TX_HASH as "Transaction hash",

trader as "Trader address",

PLATFORM as "Platform",

AMOUNT_Out_USD as "Trade volume (USD)"

from

crosschain.defi.ez_dex_swaps

where

token_in = lower('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')

and blockchain = 'base'

UNION ALL

select

Block_timestamp as "Date",

'Sell' as "Buy/Sell",

TX_HASH as "Transaction hash",

trader as "Trader address",

PLATFORM as "Platform",

AMOUNT_In_USD as "Trade volume (USD)"

from

crosschain.defi.ez_dex_swaps

where

token_out = lower('0x4ed4E862860beD51a9570b96d89aF5E1B0Efefed')

and blockchain = 'base')

select

"Platform",

sum ("Trade volume (USD)") as "Total trading volume (USD)",

count (DISTINCT "Trader address") as "Total unique traders",

count (DISTINCT "Transaction hash") as "Total trades"

from tbl

where "Date" > current_date - 30

GROUP by 1

order by 2 desc