Query editor
SELECTDATE_TRUNC('day', evt_block_time) AS day,address,COUNT(*) AS transaction_countFROM (SELECTevt_tx_from AS address,evt_block_timeFROM bonk_base.Bonk_evt_TransferUNION ALLSELECTevt_tx_to AS address,evt_block_timeFROM bonk_base.Bonk_evt_Transfer) AS transactionsGROUP BY1, addressORDER BYday,transaction_count DESCLIMIT 10;