select block_timestamp::date as fecha,
count(tx_id) as mints,
count(distinct asset_receiver) as unique_wallets,
mints / unique_wallets as mint_per_wallet,
sum(asset_amount/pow(10,6)) as mint_volume,
sum(mint_volume) over (order by fecha) as cum_mint
from algorand.asset_transfer_transaction
where sender = 'J2E2XXS4FTW3POVNZIHRIHTFRGOWEWX65NFYIVYIA27HUK63NWT65OLB2Y'
group by fecha
order by fecha