WITH tinyman_transaction as (
SELECT
DATE_TRUNC ('day' ,BLOCK_TIMESTAMP ) as daily,
SUM(fee) as tinyman_transaction_fee
FROM flipside_prod_db.algorand.application_call_transaction
WHERE app_id in ('649588853',
'350338509',
'552635992')
GROUP BY daily)
SELECT
SUM(tinyman_transaction_fee)
FROM
tinyman_transaction