Query editor
with transfers as (select day, address, token_address,sum(cast(amount as double)) as amount /* Net inflow or outflow per day */from(select date_trunc('day', evt_block_time) as day, "to" as address, tr.contract_address as token_address,cast(value as double) as amountfrom erc20_ethereum.evt_Transfer as trwhere contract_address = 0x8290333cef9e6d528dd5618fb97a76f268f3edd4 -- ankr tokenunion allselect date_trunc('day', evt_block_time) as day, "from" as address, tr.contract_address as token_address,(-1) * cast(value as double) as amountfrom erc20_ethereum.evt_Transfer as trwhere contract_address = 0x8290333cef9e6d528dd5618fb97a76f268f3edd4 -- ankr token) as tgroup by 1, 2, 3),balances_with_gap_days as (select t.day, address, sum(cast(amount as double)) over (partition by address order by t.day) as balance,lead(day, 1, current_timestamp) over (partition by address order by t.day) as next_dayfrom transfers as t),days as (select *from unnest(sequence(date('2019-02-21'), date(now()), interval '1' day)) as t(day)),balance_all_days as (select d.day, address, sum(balance/power(10, 18)) as balancefrom balances_with_gap_days as binner join days as d on b.day <= d.dayand d.day < b.next_day /* Yields an observation for every day after the first transfer until the next day with transfer */where balance/(power(10, 18)) >= 150000and balance/(power(10, 18)) < 100000000group by 1, 2order by 1, 2)select b.day as time, count(address) as whales,count(address) - lag(count(address)) over (order by b.day) as "change in 1 day"from balance_all_days as bgroup by 1order by 1