Query editor
WITH daily_unique_wallets AS (SELECTDATE_TRUNC('day', evt_block_time) AS day,"from" AS wallet_addressFROM bonk_ethereum.bonk_eth_evt_TransferUNION ALLSELECTDATE_TRUNC('day', evt_block_time) AS day,"from" AS wallet_addressFROM bonki_ethereum.Bonki_evt_TransferUNION ALLSELECTDATE_TRUNC('day', evt_block_time) AS day,"from" AS wallet_addressFROM bonk_base.Bonk_evt_TransferUNION ALLSELECTDATE_TRUNC('day', evt_block_time) AS day,"from" AS wallet_addressFROM bonkeytoken_bnb.BonkeyToken_evt_Transfer)SELECTday,COUNT(DISTINCT wallet_address) AS unique_walletsFROM daily_unique_walletsGROUP BYdayORDER BYday