WITH folkfinance_transaction as (
SELECT
DATE_TRUNC ('day' ,BLOCK_TIMESTAMP ) as daily,
SUM(fee) as folkfinance_transaction_fee
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 daily)
SELECT
SUM(folkfinance_transaction_fee)
FROM
folkfinance_transaction