SELECT date_trunc('day', BLOCK_TIMESTAMP) as date,
count(DISTINCT tx_hash) as trxs,
count(DISTINCT SENDER) as swappers,
sum(AMOUNT_out_USD) as usd_amount_out
FROM ethereum.core.ez_dex_swaps
WHERE SYMBOL_out = 'WETH'
AND BLOCK_TIMESTAMP::date >= CURRENT_DATE - 25
group by 1
order by 1 desc