with bounty_hunter_list as (
select
distinct receiver
from algorand.payment_transaction
where sender = 'TLR47MQCEIC6HSSYLXEI7NJIINWJESIT3XROAYC2DUEFMSRQ6HBVJ3ZWLE'
and amount < 10000
),
account_creation_block_id as (
select
address,
created_at,
block_timestamp
from algorand.account
left join algorand.block on (created_at = block_id)
where address in (select receiver from bounty_hunter_list)
)
select
date_trunc('day', block_timestamp) as time,
count(distinct address) as number_of_addresses
from account_creation_block_id
group by 1