SELECT

block_timestamp,

fee::FLOAT / 1e6 AS volume -- Assuming fee is in micro-AXL

FROM

axelar.core.fact_transactions WHERE

tx_succeeded = TRUE

),

weekly_volume AS (

SELECT

TRUNC(block_timestamp, 'WEEK') AS week_start,

SUM(volume) AS weekly_volume

FROM

transaction_volume

GROUP BY

TRUNC(block_timestamp, 'WEEK')

SELECT

week_start AS weekly,

weekly_volume,

SUM(weekly_volume) OVER (ORDER BY week_start) AS cumulative_volume

FROM

weekly_volume

WHERE

week_start >= DATEADD(MONTH, -2, CURRENT_DATE)

ORDER BY

week_start ASC;