SELECT

block_timestamp,

event_name, amount_in_usd, sender,

platform

FROM

blast.defi.ez_dex_swaps

WHERE

(

token_in = '0x4300000000000000000000000000000000000003'

OR token_out = '0x4300000000000000000000000000000000000003'

)

AND amount_in_usd != 0

SELECT platform,

SUM(amount_in_usd) AS Amount_usd

FROM

dex_swap

GROUP BY

ORDER BY

Amount_usd DESC;