Query editor
-- Repeated Cumulative UsersWITH arbitrum_bridge_summary AS (SELECTdistinct date_trunc('DAY', block_time) AS day,if(`to` = '0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f', 'One', 'Nova') AS target_chain_name,count(1) OVER (PARTITION BY `to` ORDER BY date_trunc('DAY', block_time)) AS accumulated_user_countFROMethereum.transactionsWHERE(`to` = '0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f' -- Arbitrum One Official Bridgeor `to` = '0xc4448b71118c9071bcb9734a0eac55d18a153949' -- Arbitrum Nova Official Bridge)AND block_time >= '2021-05-29' -- frst dayAND success = true),-- Unique Cumulative Usersarbitrum_bridge_summary2 AS (SELECTdistinct day,if(`to` = '0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f', 'One', 'Nova') AS target_chain_name,count(1) OVER (PARTITION BY `to` ORDER BY day) AS accumulated_user_countFROM (SELECT`from`,`to`,min(date_trunc('DAY', block_time)) AS dayFROMethereum.transactionsWHERE(`to` = '0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f' -- Arbitrum One Official Bridgeor `to` = '0xc4448b71118c9071bcb9734a0eac55d18a153949' -- Arbitrum Nova Official Bridge)AND block_time >= '2021-05-29' -- frst dayAND success = trueGROUP BY`from`, `to`)),arbitrum_bridge_summary3 AS (SELECTa.day,a.target_chain_name,a.accumulated_user_count AS accumulated_user_count, -- Repeated Cumulative Usersb.accumulated_user_count AS accumulated_unique_user_count -- Unique Cumulative UsersFROM arbitrum_bridge_summary aLEFT JOIN arbitrum_bridge_summary2 b ON a.day = b.day AND a.target_chain_name = b.target_chain_nameORDER BYa.day)SELECTa.day,a.accumulated_user_count AS one_accumulated_user_count,a.accumulated_unique_user_count AS one_accumulated_unique_user_count,b.accumulated_user_count AS nova_accumulated_user_count,b.accumulated_unique_user_count AS nova_accumulated_unique_user_count