SELECT
DATE_TRUNC('week', block_timestamp) AS week_start,
platform,
COUNT(tx_hash) AS total_bridge_events,
SUM(amount_unadj) AS total_amount,
COUNT(DISTINCT sender) AS unique_senders,
COUNT(DISTINCT receiver) AS unique_receivers,
AVG(amount_unadj) AS avg_amount
FROM
aptos.defi.fact_bridge_activity
WHERE
block_timestamp >= '2024-01-01' AND block_timestamp < CURRENT_DATE()
GROUP BY
week_start, platform
ORDER BY
week_start DESC, platform
LIMIT 100;