MLDZMNrand.first
Updated 2022-05-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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