Query editor
SELECTdate_trunc('DAY', block_time) day,if(`to` = '0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f', 'One', 'Nova') AS target_chain_name,count(distinct `from`) AS user_count,count(1) AS tx_count,sum(value / power(10,18)) / power(10,6) AS total_deposit_ethFROMethereum.transactionsWHERE(`to` = '0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f' -- Arbitrum One Official Bridgeor `to` = '0xc4448b71118c9071bcb9734a0eac55d18a153949' -- Arbitrum Nova Official Bridge)AND block_time >= '2021-05-29' -- frst dayAND success = trueGROUP BYday, target_chain_nameORDER BYday