Query editor
SELECTDATE_TRUNC('day', evt_block_time) AS time,COUNT(DISTINCT address) AS users,SUM(CASE WHEN row_num = 1 THEN 1 ELSE 0 END) AS new_users,COUNT(DISTINCT address) - SUM(CASE WHEN row_num = 1 THEN 1 ELSE 0 END) AS existing_users,SUM(SUM(CASE WHEN row_num = 1 THEN 1 ELSE 0 END)) OVER (ORDER BY DATE_TRUNC('day', evt_block_time)) AS total_usersFROM (SELECTevt_block_time,address,ROW_NUMBER() OVER (PARTITION BY address ORDER BY evt_block_time) AS row_numFROM (SELECTevt_block_time,"from" AS addressFROM evms.erc20_transfersWHEREcontract_address = 0xde4EE8057785A7e8e800Db58F9784845A5C2Cbd6 -- ethor contract_address = 0x6E88056E8376Ae7709496Ba64d37fa2f8015ce3e -- bnbUNION ALLSELECTevt_block_time,"to" AS addressFROM evms.erc20_transfersWHEREcontract_address = 0xde4EE8057785A7e8e800Db58F9784845A5C2Cbd6 -- ethor contract_address = 0x6E88056E8376Ae7709496Ba64d37fa2f8015ce3e -- bnb) AS transfers)WHEREevt_block_time >= CURRENT_DATE - INTERVAL '2' yearGROUP BY1