Query editor
WITH date_series AS (SELECT DATE_TRUNC('month', date) AS monthFROM (SELECT DISTINCT DATE(evt_block_time) AS dateFROM woofi_staking_v2_arbitrum.WooStakingManager_evt_StakeWooOnStakingManagerWHERE DATE(evt_block_time) >= DATE '2023-05-01')GROUP BY DATE_TRUNC('month', date)ORDER BY month),unnested_rewards AS (SELECTDATE_TRUNC('month', DATE(evt_block_time)) AS month,reward AS wooAmountFROM woofi_staking_v2_arbitrum.WooStakingManager_evt_CompoundAllForUsersOnStakingManagerCROSS JOIN UNNEST(wooRewards) AS t(reward)UNION ALLSELECTDATE_TRUNC('month', DATE(evt_block_time)) AS month,wooAmountFROM woofi_staking_v2_arbitrum.WooStakingManager_evt_CompoundRewardsOnStakingManager),monthly_totals AS (SELECTmonth,SUM(wooAmount) / 1e18 AS woo_buybackFROM unnested_rewardsWHERE month >= DATE '2023-05-01'GROUP BY month),additional_buybacks AS (SELECTDATE_TRUNC('month', DATE(block_time)) AS month,SUM(amount) AS amountFROM tokens.transfersWHERE blockchain = 'ethereum'AND block_time > DATE '2025-11-01'AND to = 0x388ac469F50E3DFD006120a046d91590B6d34dD0AND symbol = 'WOO'GROUP BY DATE_TRUNC('month', DATE(block_time)))SELECTds.month,COALESCE(mt.woo_buyback, 0) AS monthly_woo_buyback,COALESCE(ab.amount, 0) AS additional_woo_buyback,SUM(COALESCE(mt.woo_buyback, 0)) OVER (ORDER BY ds.month ASC) AS cumulative_woo_buybackFROM date_series dsLEFT JOIN monthly_totals mt ON ds.month = mt.monthLEFT JOIN additional_buybacks ab ON ds.month = ab.monthORDER BY ds.month