select block_timestamp::date as day,
count(tx_group_id) as wallets,
sum(tx_message:txn:aamt::number/pow(10,6)) as mint_amount,
sum(mint_amount) over
(order by day) as total_mint_amount
from algorand.transactions
where SENDER='J2E2XXS4FTW3POVNZIHRIHTFRGOWEWX65NFYIVYIA27HUK63NWT65OLB2Y'
and day >= '2022-03-01'
group by 1
order by 1