WITH dex_swap AS (

SELECT

Date_trunc('week',block_timestamp) AS date,

COUNT(DISTINCT tx_hash) AS trans_count,

COUNT(DISTINCT sender) AS users,

SUM(amount_in_usd) AS volume

FROM

blast.defi.ez_dex_swaps

WHERE

(

token_in = '0x4300000000000000000000000000000000000003'

OR token_out = '0x4300000000000000000000000000000000000003'

)

-- AND amount_in_usd != 0

GROUP BY date

SELECT *

FROM

dex_swap

ORDER BY

date DESC;