Query editor
with opiniondisperses as (SELECT DISTINCT tx_hash FROM bnb.logsWHERE tx_to = 0xD152f549545093347A162Dce210e7293f1452150AND tx_from = 0xe77AB06b731b059319439A042D66592014fe4694AND block_number >= 86504570),daily as (SELECT evt_block_date as "Date", to as "User" FROM erc20_bnb.evt_transferWHERE evt_tx_hash IN (SELECT * FROM opiniondisperses)AND "from" = 0xd152f549545093347a162dce210e7293f1452150AND contract_address = 0x55d398326f99059ff775485246999027b3197955AND evt_block_number >= 86504570),oldandnew as (SELECT "Date", new_users as "New", (unique_users - new_users) as "Old"FROM (SELECT sq."Date", COUNT(*) AS new_usersFROM (SELECT "User" as unique_users, MIN("Date") AS "Date"FROM dailyGROUP BY 1ORDER BY 1) sqGROUP BY 1) ssq LEFT JOIN (SELECT "Date" AS "Date", COUNT(DISTINCT "User") AS unique_usersFROM dailyGROUP BY 1ORDER BY 1) t2 USING("Date")ORDER BY 1 DESC),firstseen as (SELECT MIN("Date") AS "Date", "User" as unique_users FROM dailyGROUP BY 2)SELECT DISTINCT f."Date", "New", "Old", COUNT(unique_users) OVER (ORDER BY f."Date") as "Cumulative Unique Users" FROM firstseen fINNER JOIN oldandnew o ON f."Date" = o."Date"