Query editor
WITH new_tokens_solana as (SELECTtx_id,block_time,tx_signerFROM tokens_solana.transfersWHERE outer_executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'GROUP BY 1,2,3ORDER BY block_time DESC),active as (SELECTDATE(block_time) as date_time,COUNT(DISTINCT(tx_signer)) as total_addressesFROM new_tokens_solanaGROUP BY 1),new_users as (SELECTdate_time,COUNT(DISTINCT(tx_signer)) as new_addresses,SUM(COUNT(DISTINCT(tx_signer))) OVER (ORDER BY date_time) as cumulative_addressesFROM (SELECTtx_signer,MIN(DATE(block_time)) as date_timeFROM new_tokens_solanaGROUP BY 1)GROUP BY 1ORDER BY 1 DESC)SELECTa.date_time,a.total_addresses,n.new_addresses,n.cumulative_addressesFROM active aLEFT JOIN new_users n ON a.date_time = n.date_timeWHERE a.date_time >= DATE('2024-03-01')and a.date_time != DATE(now())ORDER BY a.date_time DESC