-- number of transactions and sum of fees in folks finance by day
SELECT date(BLOCK_TIMESTAMP) date, COUNT(DISTINCT TX_ID) as number_of_transactions, sum(FEE) as sum_of_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)
or TX_GROUP_ID in (select TX_GROUP_ID 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 date
order by date