Query editor
WITH FirstTransactions AS (SELECTMIN(date_trunc('week', block_time)) as first_date, 'evm' AS chain, CAST(tx_from AS varchar) AS walletFROM dex.tradesGROUP BY 3UNION ALLSELECTMIN(date_trunc('week', block_time)) as first_date, 'solana' AS chain, CAST(trader_id AS VARCHAR) AS walletFROM dex_solana.tradesGROUP BY 3UNION ALLSELECTMIN(date_trunc('week', block_time)) as first_date, 'bitcoin' AS chain, CAST(address AS VARCHAR) AS walletFROM bitcoin.outputsGROUP BY 3UNION ALLSELECTMIN(date_trunc('week', block_time)) as first_date, 'tron' AS chain, CAST("from" AS VARCHAR) AS walletFROM tron.transactionsGROUP BY 3),MonthlyFirsts AS (SELECTfirst_date as date, chain, COUNT(DISTINCT wallet) AS nb_walletsFROM FirstTransactionsWHERE first_date > DATE '2020-1-1' AND first_date < date_trunc('week', CURRENT_DATE)GROUP BY 1,2)SELECTdate, chain, nb_wallets, SUM(nb_wallets) OVER (ORDER BY date) AS cumulative_walletsFROM MonthlyFirstsORDER BY 1