Query editor
SELECT date, sum(users) OVER (ORDER BY date ASC ROWS BETWEEN unbounded preceding AND CURRENT ROW) AS total_usersFROM(SELECT date, count(USER) AS usersFROM(SELECT min(date) AS date,account AS USERFROM(SELECT date_trunc('day', min(block_time)) AS date,trader_a AS accountFROM dex.tradesWHERE project = 'Uniswap'GROUP BY 2UNION ALL SELECT date_trunc('day', min(block_time)) AS date,trader_b AS accountFROM dex.tradesWHERE project = 'Uniswap'GROUP BY 2UNION ALL SELECT date_trunc('day', min(evt_block_time)) AS date,provider AS accountFROM uniswap."Exchange_evt_AddLiquidity"GROUP BY 2UNION ALL SELECT date_trunc('day', min(call_block_time)) AS date,"to" AS accountFROM uniswap_v2."Router01_call_addLiquidity"WHERE call_successGROUP BY 2UNION ALL SELECT date_trunc('day', min(call_block_time)) AS date,"to" AS accountFROM uniswap_v2."Router01_call_addLiquidityETH"WHERE call_successGROUP BY 2UNION ALL SELECT date_trunc('day', min(call_block_time)) AS date,"to" AS accountFROM uniswap_v2."Router02_call_addLiquidity"WHERE call_successGROUP BY 2UNION ALL SELECT date_trunc('day', min(call_block_time)) AS date,"to" AS accountFROM uniswap_v2."Router02_call_addLiquidityETH"WHERE call_successGROUP BY 2UNION ALL SELECT date_trunc('day', min(evt_block_time)) AS date,"to" AS accountFROM uniswap_v3."NonfungibleTokenPositionManager_evt_Transfer"WHERE "from" = '\x0000000000000000000000000000000000000000'GROUP BY 2UNION ALL SELECT date_trunc('day', min(block_time)) AS date,trader_a AS accountFROM dex.tradesWHERE project = 'Kyber'GROUP BY 2UNION ALL SELECT date_trunc('day', min(block_time)) AS date,trader_b AS accountFROM dex.tradesWHERE project = 'Kyber'GROUP BY 2UNION ALL SELECT date_trunc('day', min(evt_block_time)) AS date,minter AS accountFROM compound_v2."cErc20_evt_Mint"