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))

select date_trunc('day', BLOCK_TIMESTAMP) as "date", count(*) as "Folks Finance"

from flipside_prod_db.algorand.transactions

where BLOCK_TIMESTAMP >= '2022-01-01'

and TX_GROUP_ID in (select TX_GROUP_ID from folksfinance)

group by 1

order by 1 asc