Query editor
WITH trades_with_price AS (SELECTclearing."evt_block_time" as time,clearing."evt_tx_hash" as tx_hash,new_auction."_auctioningToken" as auctioning_token,new_auction."_biddingToken" as bidding_token,clearing."soldAuctioningTokens" as tokens_sold,clearing."soldBiddingTokens" as tokens_bought,p1.price as sell_price,p1.decimals as sell_decimals,clearing."soldAuctioningTokens" * p1.price / pow(10, p1.decimals) as auction_raiseFROM gnosis_auction."EasyAuction_evt_AuctionCleared" clearingINNER JOIN gnosis_auction."EasyAuction_evt_NewAuction" new_auctionON clearing."auctionId" = new_auction."auctionId"LEFT OUTER JOIN prices.usd as p1ON new_auction."_auctioningToken" = p1.contract_addressAND date_trunc('minute', p1.minute) = date_trunc('minute', clearing.evt_block_time)AND p1.minute > TO_DATE('2021/03/01', 'YYYY/MM/DD'))SELECTtime,tx_hash,auctioning_token,bidding_token,tokens_sold,tokens_bought,sell_price,sell_decimals,SUM(auction_raise) OVER (ORDER BY time) as cumulative_auction_raiseFROM trades_with_price;