Query editor
WITH aave_token AS (SELECT 0x7Fc66500c84A76Ad7e9c93437bFc5Ac33E2DDaE9 AS addr),buyback_txs AS (SELECTevt_block_time,DATE_TRUNC('minute', evt_block_time) AS block_minute,value / 1e18 AS aave_amount,evt_tx_hashFROM erc20_ethereum.evt_transferWHERE contract_address = (SELECT addr FROM aave_token)AND "to" IN (0x22740deBa78d5a0c24C58C740e3715ec29de1bFa, 0x464c71f6c2f760dda6093dcb91c24c39e5d6e18c)AND evt_block_time >= CAST('2025-04-09' AS TIMESTAMP)),priced_buybacks AS (SELECTb.evt_block_time,b.aave_amount,p.price,(b.aave_amount * p.price) AS usd_value_at_timeFROM buyback_txs bLEFT JOIN prices.usd pON p.minute = b.block_minuteAND p.contract_address = (SELECT addr FROM aave_token)AND p.blockchain = 'ethereum'),monthly_agg AS (SELECTDATE_TRUNC('month', evt_block_time) AS month,SUM(aave_amount) AS monthly_aave_bought,SUM(usd_value_at_time) AS monthly_usd_spentFROM priced_buybacksGROUP BY 1),cumulative AS (SELECTmonth,monthly_aave_bought,monthly_usd_spent,SUM(monthly_aave_bought) OVER (ORDER BY month) AS total_aave_bought,SUM(monthly_usd_spent) OVER (ORDER BY month) AS total_usd_spentFROM monthly_agg)SELECTmonth,ROUND(monthly_aave_bought, 2) AS aave_bought_this_month,ROUND(monthly_usd_spent, 2) AS usd_spent_this_month,ROUND(total_aave_bought, 2) AS total_aave_bought,ROUND(total_usd_spent, 2) AS total_usd_spent,CASEWHEN total_aave_bought > 0THEN ROUND(total_usd_spent / total_aave_bought, 2)ELSE 0END AS avg_buy_price,ROUND((total_aave_bought / 16000000) * 100, 4) AS pct_supply_bought