SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,
SUM(AMOUNT_UNADJ) AS bridged_volume
FROM
aptos.defi.fact_bridge_activity;
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP())
GROUP BY
transaction_date
ORDER BY
transaction_date;