MLDZMNrand.first
    Updated 2022-05-25
    with tb1 as (select
    distinct SENDER as purchasers,
    min(BLOCK_TIMESTAMP) as first_use

    from algorand.payment_transaction
    where tx_group_id in (select
    tx_group_id
    from algorand.payment_transaction where RECEIVER='RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE')
    and RECEIVER not in('RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE') group by 1)

    select
    date_trunc('day',first_use) as day,
    count (distinct purchasers) as new_users
    from tb1
    group by 1
    Run a query to Download Data