SELECT
DATE_TRUNC('day', block_timestamp) AS day,
SUM(amount) AS total_amount_bridged,
SUM(amount_usd) AS total_amount_usd
FROM
polygon.defi.ez_bridge_activity
WHERE
block_timestamp >= '2024-08-01' AND block_timestamp < '2024-09-01'
GROUP BY
day
ORDER BY
day;