select date_trunc('day', block_timestamp) as date, count(tx_id) as tx_count, sum(fee) as fees_amount
from flipside_prod_db.algorand.application_call_transaction
where app_id in ('776179559', '776176449', '752770929', '751285119', '747239433', '747237154', '743685742', '743679535', '696044550', '694464549', '694405065',
'686876641', '686875498', '686862190', '686860954', '686501760', '686500844', '686500029', '686498781')
group by 1