Query editor
With cumuvaults AS (SELECTblock_time,contract_address,data,bytearray_substring("data",24, 9) AS minted_amt, tx_hashFROM ethereum.logsWHERE topic0 = 0x2e8ac5177a616f2aec08c3048f5021e4e9743ece034e8d83ba5caf76688bb475AND block_time >= DATE '2021-01-01'AND contract_address IN (0xa5b3bb6e1f206624b3b8ce0c6a0f7614fd35fa03,0x443366a7a5821619d8d57405511e4fadd9964771,0xa8cca36a624215a39d5af6854ac24868559424d3,0xada39d170551daf42822e1d3da64efebbd14d1d3,0xbeb44febc550f69ff17f8aa8eec070b95ef369ba,0x56549e2fe1d9f0a9556f92494d04f263a5011a00,0x717170b66654292dfbd89c39f5ae6753d2ac1381,0x2364536f4891ed560a6728f4b36871de8176ee5c,0xc2ba6b8e0ee3cf48b045d966f1dcda767df74833)),final AS (SELECTDATE_TRUNC('day', block_time) AS day,SUM(bytearray_to_decimal(minted_amt) / 10e17) AS minted_tcapFROM cumuvaultsGROUP BY 1)SELECT *,SUM(minted_tcap) OVER (ORDER BY day) as cumu_minted_tcapFROM final