binhachonFlipside Algorand Wallet Behavior - Creation time
    Updated 2022-04-08
    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

    Run a query to Download Data