DATE_TRUNC( DAY, BLOCK_TIMESTAMP) AS "TRANSFER DATE",

COUNT(*) AS "NUMBER OF TRANSACTIONS",

SUM(AMOUNT_USD) AS "Volume of Transactions (USD)"

FROM ethereum.defi.ez_bridge_activity

WHERE bridge_address = '0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5'

GROUP BY 1

ORDER BY 1;