select
date_trunc('day',block_timestamp) as dt,
sum(asset_amount/1e6) as total_amount,
count(distinct asset_receiver) as minter,
count(tx_id) as number_transaction
from algorand.asset_transfer_transaction
where block_timestamp>= '2022-03-31 12:00:00' and block_timestamp<= '2022-04-14 06:00:00'
and sender='4STYTA6TLA2YIPVDX6CAGFD3I6FOAUFXEXVY4C6SAFF4GU557OENP5JBJM'
and asset_id='694432641'
and inner_tx='TRUE'
group by dt
order by dt