with raw as (SELECT block_timestamp as t, pool_name , (AFFILIATE_FEE_BASIS_POINTS/100000)*to_amount_min_usd as fee_rate from flipside_prod_db.thorchain.swaps
where AFFILIATE_FEE_BASIS_POINTS is not null and AFFILIATE_ADDRESS='thor160yye65pf9rzwrgqmtgav69n6zlsyfpgm9a7xk')
Select date_trunc('month', t) as month, sum(fee_rate) as tot_fee_usd,
sum(tot_fee_usd) OVER(ORDER BY month asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_tot_fee_usd
from raw group by 1 order by 2 desc