with mint_transaction as (
select
block_timestamp,
asset_receiver,
asset_amount/1e6 as amount
from algorand.asset_transfer_transaction
where asset_transferred = 684649988
and sender = 'J2E2XXS4FTW3POVNZIHRIHTFRGOWEWX65NFYIVYIA27HUK63NWT65OLB2Y'
)
select
date_trunc('day', block_timestamp) as time,
sum(amount) as minted_amount,
count(distinct asset_receiver) as number_of_wallets,
sum(minted_amount) over (order by time) as total_minted_amount
from mint_transaction
group by 1