Query editor
SELECT date, sum(users) OVER (ORDER BY date ASC ROWS BETWEEN unbounded preceding AND CURRENT ROW) AS usersFROM(SELECT date, count(USER) AS usersFROM(SELECT min(date) AS date,account AS USERFROM(SELECT date_trunc('day', min(evt_block_time)) AS date,"to" AS accountfrom erc721."ERC721_evt_Transfer"GROUP BY 2UNION SELECT date_trunc('day', min(evt_block_time)) AS date,"from" AS accountfrom erc721."ERC721_evt_Transfer"GROUP BY 2UNIONSELECT date_trunc('day', min(evt_block_time)) AS date,"to" AS accountfrom erc1155."ERC1155_evt_TransferSingle"GROUP BY 2UNION SELECT date_trunc('day', min(evt_block_time)) AS date,"from" AS accountfrom erc1155."ERC1155_evt_TransferSingle"GROUP BY 2UNIONSELECT date_trunc('day', min(evt_block_time)) AS date,"to" AS accountfrom erc1155."ERC1155_evt_TransferBatch"GROUP BY 2UNION SELECT date_trunc('day', min(evt_block_time)) AS date,"from" AS accountfrom erc1155."ERC1155_evt_TransferBatch"GROUP BY 2) AS aGROUP BY 2) AS bGROUP BY 1ORDER BY 1) AS c