DATE_TRUNC('week', block_timestamp) AS "Week",

SUM(amount_usd) AS "Weekly Bridged Volume",

COUNT(DISTINCT tx_hash) AS "Weekly Total Bridges",

COUNT(DISTINCT source_address) AS "Weekly Active Users",

SUM(SUM(amount_usd)) OVER (ORDER BY DATE_TRUNC('week', block_timestamp)) AS "Cumulative Bridged Volume",

SUM(COUNT(DISTINCT tx_hash)) OVER (ORDER BY DATE_TRUNC('week', block_timestamp)) AS "Cumulative Total Bridges",

SUM(COUNT(DISTINCT source_address)) OVER (ORDER BY DATE_TRUNC('week', block_timestamp)) AS "Cumulative Active Users"

near.defi.ez_bridge_activity

block_timestamp BETWEEN '2024-01-31' AND '2024-12-31'

GROUP BY

DATE_TRUNC('week', block_timestamp)

ORDER BY

"Week";