SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS daily_users,
COUNT(DISTINCT TX_HASH) AS txns
FROM
BASE.defi.ez_dex_swaps
WHERE
platform = 'baseswap'
AND BLOCK_TIMESTAMP >= '2023-07-27'
AND DATE_TRUNC('day', BLOCK_TIMESTAMP) <= current_date
AND AMOUNT_IN_USD IS NOT NULL
GROUP BY
date
ORDER BY
date DESC;